200West

I am having trouble limiting my drill through query for a single series pie chart. I have an ASP page which displays 6 charts. I am using classic ASP along with Fusion Charts ASP Class to display a pie chart and drill through on the data. I have filters at the top of my page which filter the results of all 6 charts. I want to display one of the fields from the filters in the chart but allow the chart to drill through to additional data using all of the filters. Is there a way to drill through on multiple parameters without specifying them in the select statement? Select Statement for chart: select BV, ROUND(SUM(AMT)) amt from KPI_BACKLOG_V WHERE YEAR = 2013 and SITE = 'CIC' group by BV Drill Through and Chart display: Call FC6.addDataFromDatabase(oRs6, "amt ", "BV","","N-Drilldown/Request.asp?period=##PERIOD_NAME##&segment=##SEGMENT##&site=##SITE##&BV=##BV##&BSV=##BSV##&Market=##STRAT_MKT##&Family=##STRAT_FAM##")

Actually, I think I figured it out. I used the decimals=2 without any quotes and it seems to work perfectly. XML Data: <chart caption="Company Shipments" subCaption="Dollars" showBorder="1" showLabels="1" numberPrefix="$" canvasbgAlpha="0" rotateValues="1" rotateLabels="1" slantLabels="1" formatNumberScale="%26apos;1%26apos;" forcedecimals="%26apos;1%26apos;" sDecimals="3" decimals="2"><set value="1526531.25" label="6/19/2012" /><set value="1570983.375" label="6/20/2012" /><set value="1774865.125" label="6/21/2012" /><set value="2498688.75" label="6/22/2012" /><set value="61605.171875" label="6/23/2012" /><set value="0" label="6/24/2012" /><set value="2794867.75" label="6/25/2012" /></chart>

Here is the XML data. Thank you for your help. XML Data: <chart caption="Company Shipments" subCaption="Dollars" showBorder="1" showLabels="1" numberPrefix="$" canvasbgAlpha="0" rotateValues="1" rotateLabels="1" slantLabels="1" formatNumberScale="%26apos;1%26apos;" forcedecimals="%26apos;1%26apos;"><set value="1526531.25" label="6/19/2012" /><set value="1570983.375" label="6/20/2012" /><set value="1774865.125" label="6/21/2012" /><set value="2498688.75" label="6/22/2012" /><set value="61605.171875" label="6/23/2012" /><set value="0" label="6/24/2012" /><set value="2794867.75" label="6/25/2012" /></chart>

I'm having trouble formatting the decimal places in the 3D column chart that I'm trying to use. We are running the Fusion Charts XT paid product. Here are the chart parameters: strParam3="caption=Company Shipments;subCaption=Dollars;showBorder=1;showLabels=1;numberPrefix=$;canvasbgAlpha=0;rotateValues=1;rotateLabels=1;slantLabels=1;formatNumberScale='1';forcedecimals='1';" The lablels on the left side are formatted correctly but I'm trying to change the data values to $1.48M instead of $1.482755M. When I add the parameter decimals=2 then the data values get rounded too much for example $1.482755M becomes $2M and I lose the data precision. Attached is an image file. Any help is appreciated.

Thank you for your reply. The page is rendering a chart and the data from the db appears in the chart but it's all showing up on the same day so I've got something wrong with my categories I think. I've attached the classic ASP page. Is this what you meant by a scaled down version? Thanks again.

Hi, I'm using ASP class and trying to display data in a multiseries chart - MSColumnLine3D. I'm having trouble getting the data to be spread across the categories. I'm trying to use the addCategoryFromDatabase and addDatasetsFromDatabase functions. Here is the code snippet. Any help would be appreciated. dim strQuery2 strQuery2 = "Select WeekDate, SUM(Value) as Shipments From Forecast Where ID='2' and WeekDate >= '2012-03-14' and TypeID = '7' Group By WeekDate" ' Add category names dim recordset recordset = Server.CreateObject("ADODB.Recordset") Set recordset = oConn.Execute(strQuery2) Call FC.addCategoryFromDatabase(recordset, "WeekDate") ' Add a new dataset with dataset parameters dim oRS Set oRS = Server.CreateObject("ADODB.Recordset") oRS.open strQuery2,oConn,1,1,1 Call FC.addDatasetsFromDatabase(oRs, "WeekDate","Shipments","","")