PDF File size changes from SQL2000 to SQL2005

Hi All

A report that I have written in Visual Studio 2003 and published to an SQL2000 Server consists of 142 pages and is rendered in pdf format to be emailed to a user. The size of the attached pdf file is 814Kb - Application Microsoft Reporting Services 8.0

I have now opened the report in Visual Studio 2005 and converted it to this format. I have published this to our SQL2005 server and the 142 page pdf file created is 9.40Mb in size - Application Microsoft Reporting Services 9.0

Is there any way I can reduce the size of this back to it's original 814Kb

Cheers Alan

[605 byte] By [AlanBrowne] at [2007-12-24]

«« PHLAT
»» find/search button

# 1

Hi All

Further to this thread:

If i run the report in Visual Studio 2005 and then select the save as pdf option the file is saved and the size is 678Kb - Microsoft Reporting Services 9.0

This seems to be something to do with the encryption of the file

Cheers Alan

AlanBrowne at 2007-8-31 >

SQL Server

SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech