Thanks for your prompt reply.
We use Reporting Services on a organization wide basis for getting our current data.
Our report manager has over 100 different reports, all for different departments.
However, there is one certain type of report, for which the users specifically need an editable excel bar chart.
The current way this is done is that :
1) the user logs into our internal application
2) user gets the client company name for which they need the figures
3) user logs into reporting services
4) user navigates to the report, chooses the client company name using a dropdown
5) user exports the filtered data to excel using native SSRS Excel export
6) user creates a bar chart out of the data in excel and then edits it to his liking
7) user pastes the edited chart into a powerpoint presentation.
The proposed solution is to use Aspose.Cells so that:
1) user logs into our internal application
2) user clicks a link next to the client company name that downloads an excel file containing the data only for the particular company, and the bar chart created out of the data - all using Aspose.Cells
3) user opens the excel file and edits the chart to his liking
4) user copies the chart from the excel file and pastes it into the powerpoint
So, the plan is to have a link that passes the clientCompanyID to SSRS, generates 'XLS using Aspose.Cells' in the background, and then returns the excel file to the user.
As such, the only thing that the user does is click the link and hit on either open/save when the excel file download pops up.
You might ask why we don't simply use Native chart functionality in SSRS. The reason is that the charts are not editable - in fact, they export just as an image.
So, do you think there is a way to have an HTTP request that directly gets the XLS file?
Thanks,
Piyush
