Groups | Blog | Home
all groups > sql server reporting services > march 2007 >

sql server reporting services : Large report export to pdf = corruption error


Jeje
3/7/2007 11:54:28 AM
Hi,

I have a report which can produce 220 pages if the user select "all" in my
multiple choice list.

if the user try to export this report the PDF file is corrupted.
the same report with only a small amount of item selected instead-of the
"all" (so around 1 to 20 pages) is correct.
The export works fine.

any idea why?

Thanks.

Jerome.
Jeje
3/8/2007 12:00:00 AM
I'm trying to create another report with less pages and a better query.
if this doesn't works, we'll change the prompt options to restrict the user
to 1 value only.

[quoted text, click to view]
EMartinez
3/8/2007 5:39:01 AM
[quoted text, click to view]


I've never experience this issue; however, it sounds like a rendering
problem w/the quantity of data being exported to PDF. Have you tried
splitting up the results via the report query/stored procedure to
obtain a manageable amount of exported data? This might be a viable
solution.

Regards,

Enrique Martinez
Sr. SQL Server Developer
AddThis Social Bookmark Button