Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS error when exporting as PDF: Index was outside the bounds of the array Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 7:50 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:05 PM
Points: 54, Visits: 456
Hello all...

I have an SSRS report that, when you try to save it as a pdf, tiff, or print preview, returns the error: "An error occurred during the local report processing. Index was outside the bounds of the array". If you export it any other way, it works fine.

I've searched all over the internet, and of course the SSC forums, but have not found an answer that can be applied. There is a hotfix (link below) that specifies "Reporting Services 2008" and indicates "The fix for this issue was first released in Cumulative Update 6 for SQL Server 2008 Service Pack 1.", however, we use SQL 2008 R2 sp2 (and Reporting Services 2008 R2, sp2?). I assume the hotfix would have been included as part of the cumulative upgrade and subsiquent service packs - but if so, why are we even having this issue?

Since I couldn't find a fix specifically for 2008 R2, I went ahead and tried to install it (thinking Reporting Services may still be regarded as regular 'ol 2008), I receive the error: "There are no SQL Server instance or shared features that can be updated on this computer." SQL and Reporting Services are definately installed (tried to apply to 3 different servers and my local machine).

According to the hotfix, "This problem occurs because SSRS 2008 does not normalize the column header width for the inner tablix on the second page of the matrix."

This is the hotfix that appears to be the solution but does not seem to apply to 2008 R2 sp2: http://support.microsoft.com/kb/978636?wa=wsignin1.0

Any suggestions would be greatly appreciated, please let me know if i could supply additional information.

Post #1497863
Posted Thursday, September 26, 2013 6:23 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 531, Visits: 448
Hi Lisa,

Just this one report is acting this way? Have you tried renaming it and publishing it to the report server and seeing if that makes any difference?
Post #1498789
Posted Friday, September 27, 2013 7:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:45 AM
Points: 595, Visits: 2,111
what about the reporting services logs? any additional info there?

Post #1499367
Posted Friday, October 11, 2013 8:48 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:05 PM
Points: 54, Visits: 456
Thanks for the replies and sorry for the delay in response. The person I'm troubleshooting this for is out on leave so it became a lower priority.

Just this one report is acting this way? Have you tried renaming it and publishing it to the report server and seeing if that makes any difference?


We can recreate it with other reports if we set them up the same way, rename yields the same results. Reports that are not set up the same way can publish to pdf without a problem. I have not tried publishing the report yet...as I'm waiting for her to return so I do it correctly.

Per the user: The error I receive happens when I uncheck the ability to repeat header columns on one of the matrices. According to Microsoft this is occurs because SSRS 2008 does not normalize the column header width for the inner tablix on the second page of the matrix.

what about the reporting services logs? any additional info there?


I don't see anything in the ReportServerService error log when this error occurs.

Post #1504047
Posted Friday, October 11, 2013 8:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:45 AM
Points: 595, Visits: 2,111
When you say "the same way." What exactly do you mean, how do the reports that work and the ones that don't differ?
Post #1504049
Posted Monday, November 4, 2013 1:03 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:05 PM
Points: 54, Visits: 456
Thank you for your replies. It took some time but we've found a workaround and MS believes it is a bug and they are going to investigate further.

The answer was found here:
========
http://connect.microsoft.com/SQLServer/feedback/details/357255/reporting-print-layout-error-index-out-of-bounds

Scenario
========
The report needed to be set up with each different "policy holder" begining on a new page of the report and the header for the "policy holder" should only be visible on the first page of their group of policies.

Issue
========
When trying to export report to PDF getting an error “Index was outside the bounds of the array”.

Cause
========
The hidden property for the outermost column group, i.e. PolicyHolder was set to “True”.

Resolution
========
Edited the report in BIDS, for the outermost column group, set the Visibility to "Show" and changed the Hidden field to “False” (which was previously set to True).

Workaround
========
The report designer used floating text boxes for column groupings instead of using the combined tablix column groupings. Apparently there is a limit if there is more than one page per grouping.

Hopefully this could help someone else. As I mentioned, this appears to be a bug and we will be notified if a fix is created. If so, I will post the fix here, also.
Post #1511263
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse