April 15, 2008 at 11:09 pm
Hi All,
We are using the SSRS 2005 for developing reports. In that I have some problems/doubts.
My problems are:
I developed / designed the report using the SSRS 2005. And I uploaded the reports in to the report server. I can able to view the reports in the preview section as well thro the browser.
Problem 1:
Reports are having the huge amount of data (For: report is having > 800 Pages). So, when ever I am trying to export in to EXCEL that time I am getting MemoryOutOfException. If I having the less number of pages that time I getting the result. How I can export the report into excel with out MemoryOutOfException.
Problem 2:
Some Excel sheets are having more data for ex: 75000. In EXCEL it self we are having the limitation we can not create more than 65536 rows per sheet. So If I want to export these 75000 records into excel how I do it.
Problem 3:
For delivering the reports I am using file share subscription method in SSRS. For example my reports are having the huge amount of data. That time I getting the following status in report server “Failure writing file Weekly Install Base Report @timestamp: An error occurred during rendering of the report.”"
Software Platform:
1. SQL Server Reporting Services 2005
2. SQL Server 2000 Data base
3. Microsoft Office 2003
Thanks
Sundaraguru S
April 17, 2008 at 3:20 am
Using a Table, you can force an explicit page break after a certain number of rows. Because the Excel renderer creates a new worksheet for every explicit page break, you can use this technique to make sure no more than 65,536 rows are exported to a single sheet.
Create an outer table group using this group expression:
=Int((RowNumber(Nothing)-1)/65000).
Set Page break at end on the group.
Keep in mind that there isn't a one-to-one relationship between SSRS table rows and Excel rows unless the table is the only report item in the report body. So, if you have other report items in addition to your table you will have to also take that into account.
May 8, 2008 at 12:55 am
Hi,
I am facing a similar problem , I added the RowNumber(Nothing)
But I get the following error message.
Error1A group expression for the table ‘table2’ uses the RowNumber function with a scope parameter that is not valid. When used in a group expression, the value of the scope parameter of RowNumber must equal the name of the group directly containing the current group.C:\Local_Copy_Shell.MPCT.Development\Shell.MPCT.UI\Reports\MaterialNetOrPocketPriceReport.rdlcShell.MPCT.UI
Please advise.
July 8, 2008 at 3:31 pm
I am also getting the same error. Please advice
May 7, 2009 at 9:54 pm
click table properties and click the Groups tab and select the new added group and Change to top order by clicking the upper arrow at the right side
May 13, 2009 at 12:07 pm
Thanks for sharing the solution for a table. On the same note, how do you insert page breaks after a custom count of rows using a Matrix to avoid excel export errors?
For example, if Category is row group #1, Item is row group #2, I need the report to look like this. I've adjusted the table solution and changed scopes but can't seem to get it to work:
Category 1
>>>>Item #1
>>>> ...
>>>>Item #60,000
------ page break -------
>>>>>Item #60,001
Category 2
...
June 17, 2010 at 5:45 pm
Tks. The better explanation about this issue.
August 24, 2010 at 11:20 am
It has been a couple of years since I have had this issue but; in one of your group footers you need to programmatically insert a page break conditionally on the row count before it hits that number 65365. The result on the export is: there will be additional worksheets for each time you hit the defined threshold. Let me know if you can’t iron out the syntax. There is/was an MSDN article on this topic.
Dennis Graham
August 25, 2010 at 12:58 am
i have sam eproblem for about columns not row.Can you provide me any solution?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply