We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Re: Direct Export to XLS using Aspose.Cells for Reporting Services

Hi,

Why not to use reporting services interface, could you elaborate it. If you want to use SQL Server reporting services in the background, how do you implement reports. Aspose.Cells for Reporting Services is rendering extensions that provides multiple formats e.g.., .XLS, CSV etc.

Thank you.

Hi,

Why not to use reporting services interface, could you elaborate it. If you want to use SQL Server reporting services in the background, how do you implement reports. Aspose.Cells for Reporting Services is rendering extensions that provides multiple formats e.g.., .XLS, CSV etc.

Thank you.

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

Alternatively,

Is it possible to skip the usage of Reporting services altogether, and simply get the smart tags in the XLS file replaced by the actual data, and returned using a Java function?

In other words, is it possible to write a java class that creates a new Aspose.cells XLS object based on an rdl file, replaces it with real data at runtime (using a connection to the database) and returns the XLS file to the calling function - done so that all this is happening in the background between the time that the user clicks on the 'Get Excel file' button and him getting the file a second later.

Just a random thought.. I'm not sure if this is feasible..

Piyush

Hi Piyush,

Please try Aspose.Cells.reportingservices Designer.

This is a report designer tool that is integrated with MS Excel in Add-Ins… form.With Aspose.Cells.Report.Designer users can design a report template in MS Excel instead of Visual Studio.The report template is then embedded into Reporting Services RDL file and can be published to Report Server. Users can also preview and export the report in Aspose.Cells.Report.Designer.

1. You design a report in MS excel with Aspose.Cells.ReportingServices Designer and publish to server.

2. Users direct export report data file in Ms Excel .