This Web Part requires write access to the wpresources\charts\ folder. The formatted chart will be written to the charts folder and embeded inside the Web Part via the img tag.

<rsb:info title="SQL Query Bar Chart and Data Table" description="Selects sales by country and displays the results in a YUI Data Table and Bar Chart.">
  <input name="yaxistitle" description="The y axis title." default="Order Count"/>
  <input name="xaxistitle" description="The x axis title." default="Country"/>
  <input name="charttitle" description="The chart title." default="2008 Sales"/>
</rsb:info>

<rsb:import lib="RSSBus.SqlOps"/>
<rsb:import lib="RSSBus.ChartOps" />

<rsb:set attr="conn" value="Data Source=Serverlocation;Initial Catalog=Northwind;User Id=sa;Password=Password" />
<rsb:set attr="query" value="select shipcountry, count(shipcountry) as x from Orders group by shipcountry order by x asc" />

<rsb:set attr="TableMeta.YUITableAttrs" value="sql:shipcountry, sql:x"/>
<rsb:set attr="TableMeta.YUITableLabels" value="Country,Orders"/>

<rsb:set attr="_meta.yaxis" value="sql:x" />
<rsb:set attr="_meta.xaxis" value="sql:shipcountry" />
<rsb:set attr="_meta.yaxistitle" value="[yaxistitle]" />
<rsb:set attr="_meta.xaxistitle" value="[xaxistitle]" />
<rsb:set attr="_meta.xaxislabelinterval" value="1" />
<rsb:set attr="_meta.height" value="500" />
<rsb:set attr="_meta.showlegend" value="false"/>
<rsb:set attr="_meta.charttype" value="bar"/>
       
<table>
<tr>
<td colspan="2">
<div align="center"><h1>[charttitle]</h1></div>
</td>
</tr>
  <tr>
    <td><rsb:call op="sqlQuery" meta="TableMeta" format="ToYuiTable" save="sqlChart"/></td>
    <td><rsb:call op="[_feeds.sqlChart]" format="mschart"/></td>
  </tr>
</table>