Free Support Forum - aspose.com

How to create charts using data from SQL server

I want to create charts in reports after fetching data from SQL. Is it feasible to create the PPT report using ASPOSE only. If yes how can we create the report.

If it is not possible to use the ASPOSE then is it feasible to use SQL server reporting services to generate the report and use it through aspose? Could you please send some sample if possible to do that.


This message was posted using Aspose.Live 2 Forum

Dear princeofmrec,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thanks for considering Aspose.Slides and Aspose.Slides for RS.

Yes, you can create Excel charts inside your presentations via Aspose.Slides by adding them as OLE objects.

You can see one such an example at the following link. Here, Excel chart is read as a stream from source excel file, but in your case, the stream will come from SQL database.

http://www.aspose.com/documentation/file-format-components/aspose.slides-for-.net-and-java/working-with-ole-object-frames.html

If you will use the above approach, then you will face an issue “Object Changed” image, please see this link, it talks about how to resolve it with your own image.

http://www.aspose.com/documentation/file-format-components/aspose.slides-for-.net-and-java/object-changed-issue-when-adding-oleobjectframe.html

Also see the code here, where I used Aspose.Cells to get the image of Excel chart and used it to replace Object Changed image.

http://www.aspose.com/community/forums/121497/how-to-access-ppt-chart-using-aspose/showthread.aspx#121497

You can also create charts with Aspose.Slides for Reporting Services, in this case, you will design your RDL report, once you design your RDL, then you can use SQL Server Reporting Services to export it in any available format. For example, you can export it in html, pdf and if you have also installed Aspose.Slides for Rerporting Services then, you can also export it in ppt.