asp.net - ASP Chart Control - issue displaying all SQL data -


i new @ using mschart control. know how single series of data display in column chart, having issues displaying multiple data values in chart. here data sql query need display:

area      totalcnt   compliant  cpercent     noncompliant   ncpercent area1      29027      25468      87.7            3559        12.3 area2      13659      12035      88.1            1624        11.9 area3      25358      22221      87.6            3137        12.4 area4      47747      42340      88.7            5407        11.3

here's series section of column chart:

<series> <asp:series isvalueshownaslabel="true" chartarea="chartarea1" label="#valy" name="compliant" bordercolor="180, 26, 59, 105" color="#00cc00" xvaluemember="area" yvaluemembers="compliant"></asp:series> <asp:series isvalueshownaslabel="true" chartarea="chartarea1" label="#valy" name="non-compliant" bordercolor="180, 26, 59, 105" color="255, 0, 0" xvaluemember="area" yvaluemembers="noncompliant"></asp:series> </series>

any appreciated. added entire chart control below:

<asp:chart id="chart1" runat="server" datasourceid="sqldatasource1" width="800px" height="400px" palette="brightpastel" bordercolor="181, 64, 1" borderlinedashstyle="solid" backgradientstyle="topbottom" borderwidth="2" backcolor="#f3dfc1" imagetype="png" imagelocation="~\tempimages\chartpic_#seq(300,3)">    <titles>    <asp:title shadowcolor="32, 0, 0, 0" font="trebuchet ms, 14.25pt, style=bold" shadowoffset="3" text="datasource data binding" alignment="topleft" forecolor="26, 59, 105"></asp:title>    </titles>     <legends>         <asp:legend name="legend1" enabled="true" istextautofit="true" backcolor="transparent" font="trebuchet ms, 8.25pt, style=bold">         </asp:legend>         <asp:legend headerseparator="line" name="legend2">                 <cellcolumns>                     <asp:legendcellcolumn columntype="seriessymbol" headertext="region" name="column1">                         <margins left="15" right="15" />                     </asp:legendcellcolumn>                 </cellcolumns>             </asp:legend>      </legends>     <borderskin skinstyle="emboss"></borderskin>         <series>             <asp:series isvalueshownaslabel="true" legend="legend1" chartarea="chartarea1" label="#valy" name="compliant" bordercolor="180, 26, 59, 105" color="#00cc00" xvaluemember="area" yvaluemembers="compliant">             </asp:series>     <asp:series isvalueshownaslabel="true" legend="legend1" chartarea="chartarea1" label="#valy" name="non-compliant" bordercolor="180, 26, 59, 105" color="255, 0, 0" xvaluemember="area" yvaluemembers="noncompliant">              </asp:series>         </series>     <chartareas>         <asp:chartarea name="chartarea1" bordercolor="64, 64, 64, 64" borderdashstyle="solid" backsecondarycolor="white" backcolor="oldlace" shadowcolor="transparent" backgradientstyle="topbottom">         <area3dstyle rotation="10" perspective="10" inclination="15" isrightangleaxes="false" wallwidth="0" isclustered="false"></area3dstyle>                       <axisx linecolor="64, 64, 64, 64" islabelautofit="false">         <labelstyle font="trebuchet ms, 8.25pt, style=bold" />         <labelstyle enabled="true" />         <majorgrid linewidth="1" />         <majortickmark enabled="false" />         </axisx>         <axisy linecolor="64, 64, 64, 64" islabelautofit="false">         <labelstyle font="trebuchet ms, 8.25pt, style=bold" />         <majorgrid linecolor="64, 64, 64, 64" />         <labelstyle enabled="true" />         <majorgrid linewidth="1" />         <majortickmark enabled="false" />         </axisy>     </asp:chartarea>   </chartareas> </asp:chart>


Comments

Post a Comment

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

i using magento ver. 1.9.1.0 want remove shipping information , shipping method step 1 page checkout page. changed code in core file like in app\code\core\mage\checkout\block\onepage.php public function getsteps() { $steps = array(); $stepcodes = $this->_getstepcodes(); /* remove shipping address , shipping method */ $excludestep=array_diff($stepcodes,array('shipping','shipping_method')); //$excludestep=$stepcodes; if ($this->iscustomerloggedin()) { $stepcodes = array_diff($excludestep, array('login')); } foreach ($excludestep $step) { $steps[$step] = $this->getcheckout()->getstepdata($step); } return $steps; } and in app\code\core\mage\checkout\controllers\onepagecontroller.php public function savebillingaction() { if ($this->_expireajax()) { return; } if ($this->getrequest()-...
Read more

tcpdump - How to check if server received packet (acknowledged) -

Image
i running tcpdump on server capture traffic between server (servera) , remote server (serverb). not know how read output tcpdump. point out if serverb acknowledging packets being sent servera being received serverb? here tcpdump log: 2015-03-31 11:32:18.038284 ip (tos 0x0, ttl 64, id 30781, offset 0, flags [df], proto tcp (6), length 60) servera.14033 > serverb.8004: flags [s], cksum 0x02bd (correct), seq 337482636, win 14600, options [mss 1460,nop,nop,ts val 506588081 ecr 0,nop,wscale 7], length 0 0x0000: 4500 003c 783d 4000 4006 bae4 0a04 7a0e e.. servera.14033: flags [s.], cksum 0x3b2a (correct), seq 1742982091, ack 337482637, win 4140, options [mss 1380,nop,wscale 0], length 0 0x0000: 4500 0030 5ff2 0000 f606 5d3b cefd b48a e..0_.....];.... 0x0010: 0a04 7a0e 1f44 36d1 67e3 cbcb 141d 938d ..z..d6.g....... 0x0020: 7012 102c 3b2a 0000 0204 0564 0103 0300 p..,;*.....d.... 2015-03-31 11:32:18.078622 ip (tos 0x0, ttl 64, id 30782, offset 0, flags [...
Read more