This template requires you to install RSSBus.SqlOps

<rsb:info>
<input name="conn" description="The connection string used to define the connection."  default="Data Source=YOURSERVER;Initial Catalog=Northwind;User Id=YOURUSERID;Password=YOURPASSWORD" required="true" />
  <input name="query" description="The query to execute" required="true" default="select shipcountry, count(shipcountry) as x from Orders group by shipcountry order by x desc" required="true"/>
  <input name="defaultcharttype" description="The type of chart to render." values="Pie,Doughnut" default="Doughnut"/>
  <input name="palette" description="The color palette to apply to this chart." values="Bright,Grayscale,Excel,Light,Pastel,EarthTones,SemiTransparent,Berry,Chocolate,Fire,SeaGreen,BrightPastel" default="SemiTransparent"/>
  <input name="3denable" description="Specifies whether this chart should be rendered in 3d." values="True,False" default="True"/>
  <input name="height" description="The height of this chart." default="240"/>
  <input name="width" description="The width of this chart." default="320"/>
</rsb:info>

<rsb:import lib="RSSbus.SqlOps"/>

<rsb:set attr="_meta.yaxis" value="sql:x"/>  
<rsb:set attr="_meta.xaxis" value="sql:shipcountry"/>
<rsb:set attr="_meta.defaultcharttype" value="[defaultcharttype]"/>
<rsb:set attr="_meta.width" value="[width]"/>
<rsb:set attr="_meta.height" value="[height]"/>
<rsb:set attr="_meta.3denable" value="[3denable]"/>
<rsb:set attr="_meta.palette" value="[palette]"/>
<rsb:set attr="_meta.showlegend" value="true"/>
<rsb:set attr="_meta.charttitle" value="Number of Orders per Country"/>
<rsb:set attr="_meta.3dinclination" value="40"/>

<rsb:call op="sqlQuery"  format="mschart" pagesize="5">
  <rsb:set attr="sql:shipcountry" value="[sql:shipcountry] ([sql:x])"/>
</rsb:call>