Koushik

Hello Rajroop, I have been trying to understand how server-side export of FC works. We have a requirement in our project to generate Batch Reports where user can create an SQL Query from a screen and submit the same for Excel-based Report Generation. The Excel Report which will be generated needs to have grid-data as well as FusionCharts, embedded as images on an excel sheet. Now, we are using server-side processes to generate the grid-data in the background (by querying SQlServer) and creating the Excel file (suing ASP.Net) and putting the grid data on a sheet. Problem is, we need to put the fusionchart as well on the sheet and I couldnt find a way to generate the bitmap (or chart image) from the chart in the background without rendering it on a page. The intention is to generate a Report which will have a Data grid on top and a Fusionchart at the bottom, and this report will be generated server-side (a backend process after user submits the query). Is there a way to create the chart in memory based on the XML data and then call the export handlers to generate bitmap from it in the background, and then embed in Excel sheet? Please advise. Thanks, Koushik Chakrabarti Hartford,CT.

Hi, This is Koushik Chakrabarti from Hartford, Connecticut - USA. I have been using Fusioncharts in our project where we need to show MSCombiDY2D chart for statistical data display. I need to know whether there is any feature or property in the fusionchart V3 API to set the dimensions of the legends in a MSCombiDY2D chart. In one example in our project, the legend description is so long that it wraps to the next line. Whereas it already has lots of white space to its left. See the image attached. Would appreciate if someone responds to this requirement. Thanks, Koushik.

Thanks for the reply Dhruva. Will these attributes in chart element help me to make the legend text 'Cumulative % Mailed' appear on one line? Or will it break into the next line the way it happens now? Thanks,

Is that possible in the purchased version or not possible at all? Is there any API to convert the chart to an image?

Hi, I am working on FusionCharts and using the chart 'MSColumn3DLineDY.swf' to display data. The XML which I am using for this chart is as follows: <chart palette='1' caption='' shownames='1' showvalues='0' numberPrefix='' connectNullData='0' PYAxisName='Image Volume' SYAxisName='Total Percent Printed' showYAxisValues='1' numDivLines='1' formatNumberScale='0' SYAxisMaxValue='100' SYAxisMinValue='0'> <categories> <category label='Wed 12/16' /> <category label='Tue 12/19' /> <category label='Mon 12/22' /> </categories> <dataset seriesName='Total Images' color='FF6600' showValues='0'> <set value='2876' /> <set value='4899' /> <set value='5390' /> </dataset> <dataset seriesName='Total Documents' color='6699CC' showValues='0'> <set value='11540' /> <set value='19872' /> <set value='23415' /> </dataset> <dataset seriesName='Percent Printed' color='000000' showValues='0' parentYAxis='S' > <set value='52' /> <set value='86' /> <set value='100' /> </dataset> </chart> The code I am using to display the chart is as follows: <div id="chartPrint" align="center"></div> <script type="text/javascript"> var chart = new FusionCharts ("Data/Charts/MSColumn3DLineDY.swf", "ChartId1", "370", "300", "0", "1"); chart.setDataURL("Data/CVChartData/PrintDate.xml"); chart.render("chartPrint");</script> </script> The problem I am having is, when the line 'S' is rendered, even though the data shows 100%, the line actually doesn't touch the 100 mark in the Y-axis. It stays well below 100 though actual value for the point is 100. See the snapshot below. Can anyone guide me to figure out how to solve this issue and have the line reach 100% mark? Thanks,

Thanks for your reply. I tried putting use3DLineShift='0' on the 1st line of XML (as chart attribute) and also on "<dataset seriesName='Percent Printed' " entry in XML. But it didn't fix my problem. As you mentioned this is a problem for 3D rendering,do you think this will be solved if I use the 2D version of MSColumn and Line combination? Thanks,