|
|
|
Valued Member
 
Group: General Forum Members
Last Login: Thursday, February 02, 2012 2:06 AM
Points: 51,
Visits: 234
|
|
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
Kind Regards,
Sundaraguru S
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Friday, June 13, 2008 6:32 AM
Points: 35,
Visits: 120
|
|
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.
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 08, 2008 1:57 AM
Points: 42,
Visits: 6
|
|
Hi,
I am facing a similar problem , I added the RowNumber(Nothing)
But I get the following error message.
Error 1 A 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.rdlc Shell.MPCT.UI
Please advise.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, August 26, 2008 1:51 PM
Points: 1,
Visits: 7
|
|
| I am also getting the same error. Please advice
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, November 10, 2009 3:19 AM
Points: 2,
Visits: 17
|
|
| 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
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:23 AM
Points: 118,
Visits: 122
|
|
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
...
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, June 17, 2010 5:44 PM
Points: 1,
Visits: 0
|
|
| Tks. The better explanation about this issue.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, November 21, 2011 12:57 PM
Points: 3,
Visits: 50
|
|
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
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, March 22, 2011 5:36 AM
Points: 32,
Visits: 152
|
|
| i have sam eproblem for about columns not row.Can you provide me any solution?
|
|
|
|
