SSRS PDF Render Issue

Today I faced a problem with rendering pdf of a reporting services report. The problem was this:

n ssrs i have a report with a specific structure of 82 pages grouped by Area. If i open the report on Reportserver or reder it in Excel i see the correct structure and all the report:

enter image description here

But if i schedule in PDF or i render from internet the report in PDF this it the result: enter image description here

As you can see i haven’t north america, row o china. It’s like reporting stop the rendering of the report and do nothing. (in the pdf he prints 3 blank page after europa page)

Solution:

Place a TextBox in the report footer with the expression:

=IIF(Globals!RenderFormat.Name=”PDF”,Globals!TotalPages,””).

It’s a problem with the timeout, using the TotalPages global variable will force everything to be processed before it starts rendering the first page.

N.B. This causes indomitable delays when trying to view a lengthy report.

Annunci