pdf size due to images

We have a report with a number of external images. When the report is run
and exported to pdf, the resulting document is over 2mb (regardless of
whether the report is run in VS or the ReportManager). When the images are
changed from external to embedded, the resulting pdf document is around
500kb. This is great since the 2mb was causing issues with our client's
email server. When the modified rdl is imported to our client's system, the
resulting document is still around 500kb.
When the original rdl is modified on the client's system using
ReportDesigner - and all of the images are changed from external to embedded
- the resulting pdf document is still over 2mb!! I've verified any number
of times that the images are of type embedded.
Both systems are have reporting services at sp1. The only obvious
difference is that our environment is a developer edition of SQL Server and
the client's is Standard.
Is the difference in SQL the reason? Any other ideas/suggestions'
ThanksThis is NOT an issue between external vs. embedded images. During testing
the wrong image file was being used.
It DOES appear to be an issue with the way images are rendered to PDF.
Using other document types such as Word results in a smaller overall document
size.
Any suggestions/ideas for rendering to pdf are appreciated.
"PD" wrote:
> We have a report with a number of external images. When the report is run
> and exported to pdf, the resulting document is over 2mb (regardless of
> whether the report is run in VS or the ReportManager). When the images are
> changed from external to embedded, the resulting pdf document is around
> 500kb. This is great since the 2mb was causing issues with our client's
> email server. When the modified rdl is imported to our client's system, the
> resulting document is still around 500kb.
> When the original rdl is modified on the client's system using
> ReportDesigner - and all of the images are changed from external to embedded
> - the resulting pdf document is still over 2mb!! I've verified any number
> of times that the images are of type embedded.
> Both systems are have reporting services at sp1. The only obvious
> difference is that our environment is a developer edition of SQL Server and
> the client's is Standard.
> Is the difference in SQL the reason? Any other ideas/suggestions'
> Thanks|||The issue was resolved by: (1) upgrading to SP2 AND (2) reducing the size of
jpg images that are used in the report. ONLY upgrading to SP2 DID NOT solve
the problem - the original images were simply distorted/gray AND without a
reduction in overall pdf document size. The size of the images were reduced
using MS Photo Editor, although other editors seem to work also.
"PD" wrote:
> This is NOT an issue between external vs. embedded images. During testing
> the wrong image file was being used.
> It DOES appear to be an issue with the way images are rendered to PDF.
> Using other document types such as Word results in a smaller overall document
> size.
> Any suggestions/ideas for rendering to pdf are appreciated.
>
> "PD" wrote:
> > We have a report with a number of external images. When the report is run
> > and exported to pdf, the resulting document is over 2mb (regardless of
> > whether the report is run in VS or the ReportManager). When the images are
> > changed from external to embedded, the resulting pdf document is around
> > 500kb. This is great since the 2mb was causing issues with our client's
> > email server. When the modified rdl is imported to our client's system, the
> > resulting document is still around 500kb.
> >
> > When the original rdl is modified on the client's system using
> > ReportDesigner - and all of the images are changed from external to embedded
> > - the resulting pdf document is still over 2mb!! I've verified any number
> > of times that the images are of type embedded.
> >
> > Both systems are have reporting services at sp1. The only obvious
> > difference is that our environment is a developer edition of SQL Server and
> > the client's is Standard.
> >
> > Is the difference in SQL the reason? Any other ideas/suggestions'
> > Thanks

PDF Rendering - Page break with images

Hi,
I have a main page which has subreports, images and tables. in Preview i can
see the reports with proper page breaks, but when i render it to pdf, the
image and table in the main page is moving to another page, actually only 3
pages has to be printed in pdf but it is printing to 10 pages.
any suggestions please.
Thanks and regards,
AnithaI got the solution, i need to put all the lables and data in a Table to
display it in one page.
"Anitha Naidu" wrote:
> Hi,
> I have a main page which has subreports, images and tables. in Preview i can
> see the reports with proper page breaks, but when i render it to pdf, the
> image and table in the main page is moving to another page, actually only 3
> pages has to be printed in pdf but it is printing to 10 pages.
> any suggestions please.
> Thanks and regards,
> Anitha
>|||Try placing everything inside a rectangle control.
Place a rectangle in a blank area of the body.
Cut the controls including tables you want to contain, select the
rectangle, then paste the controls back in. Align things the way you
want inside the rectangle. This is the best way to restrict things in
RS. It may not work, but it's worth a try.
Cheers
Chris
Anitha Naidu wrote:
> I got the solution, i need to put all the lables and data in a Table
> to display it in one page.
>
> "Anitha Naidu" wrote:
> > Hi,
> >
> > I have a main page which has subreports, images and tables. in
> > Preview i can see the reports with proper page breaks, but when i
> > render it to pdf, the image and table in the main page is moving to
> > another page, actually only 3 pages has to be printed in pdf but it
> > is printing to 10 pages.
> >
> > any suggestions please.
> >
> > Thanks and regards,
> > Anitha
> >

PDF Image Rendering issue with SP/2

When i export a report to PDF using the preview, my images are
seriously pixelated. I've updated to the SP2 and the issues still
occur.
Any advice would be greatly appreciated.Ok, this was not an issue with SSRS. The images that were being
included (External) in the report were coming from an ASP.NET web
application. In the application when i was saving the images to disk
(Image.Save(...)) i was not specifying an imageformat. I am not sure
what the default format is, but from attempting to view the images as
"JPEG" it would appear that it is not "JPEG". I corrected this and now
my images render "CRISP" in the PDF.
-Beau

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211sql

PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?

Can anyone give me a hint on this one?

Thanks,
Neno

There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.

|||

i want to download some programme so i need urgent thanks

|||

I would suggest installing RS SP2 and the latest QFE available (KB912424).

Thank you,

Nico

|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211