I just did simple scenario creating Excel ready report with Aspose.Cells for SSRS and I stuck with the problem: I got only the first row of my report.
Windows Vista, MS Office 2007, MS SQL 2008, MS SSRS 2008, AdventureWorks2008 DB and sample RDL's, .NET 3.5 SP1
I have Adventure Works sample RDL: Company Sales 2008 base.rdl (see attachment)
I have opened it in MS Excel using Aspose.Cells from my local SSRS repository and prepared Excel ready report: Company Sales 2008.xlsx
I have published it to SSRS. It was stored with RDL Company Sales 2008 public.rdl
I have tried to generate Excel ready report and Company Sales 2008 public.xlsx is the result what I got.
Report contains only one row, but I'm sure, that this report has more rows. I have tried with few other reports and got the same result.
Your ASAP help would be very appreciated.
BTW. When I try to edit cell in Excel, Aspose.Cells add-in buttons disables (see attachment disabled.png) and enables again only if I click "Sub-Report" button. Sometimes (after publish report) even this button disables and there is no other way as to close report and try to open it again.
Thanks in advance for your answers and help.