Changes related to PDF in SQL Server 2005 Reporting Services

Hi All,

I am working on SQL Server 2005 reporting services. In reports I am required to make changes related to exporting report to PDF. Following are those changes:

1) Change PDF export page format to letter from legal

2) Fix page break to ensure that all details related to a specific issue are viewable on the same page

In reports exporting is done through the control given by services itself. So can any one please guide me regarding how this changes can be done. Please help me ASAP...

Thanks....

For (1), it seems like you should be able to just change the page size of the report. Or do you need to change the size just for PDF? If you are using URL access or SOAP, you can specify page sizes via device info settings. See http://msdn2.microsoft.com/en-us/library/ms154682.aspx

For (2), you will need to modify the RDL; try looking into the KeepTogether and RepeatWith settings on report items.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp|||

With regard to page breaks I can see a KeepTogether property that refers to the whole report but not to individual groups. There is no RepeatWith setting within my rdl (SQL2005).

I would like my report to group on a particular field but don't want it to break before or after the report header / footer. Any idea how I can do this?

Change quality rendering to PDF

PDF - rendering of reports that contain images, makes very large pdf-files.
Is there any option that I can set the export quality of the images?
I have seen in this forum that there have been many questions about
rendering images, but very few good answers ... can anyone tell me if there
are any solution to my problem ? .... changes in SP2?What is your source for images? There are lots of good tools out there for
reducing the size of images. For example, if your images are stored in a
file system, IrfanView is an easy tool to use, and it has good compression
as well.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TiJei" <TiJei@.discussions.microsoft.com> wrote in message
news:7BAA23AF-4337-4145-B957-06E80ABBB79B@.microsoft.com...
> PDF - rendering of reports that contain images, makes very large
> pdf-files.
> Is there any option that I can set the export quality of the images?
> I have seen in this forum that there have been many questions about
> rendering images, but very few good answers ... can anyone tell me if
> there
> are any solution to my problem ? .... changes in SP2?|||Thank you for your answer Jeff,
I know there is a lot of tools for resizing images, but why should the
pdf-rendering "enlarge" my images?
If i use a jpeg as source, with the size about 300kb and 96*96 dpi, I got a
export file at about 2,3 MB.
When rendering to pdf, I want to have the possibility to declare the
properties for the image, today the size of the exported file indicates that
the quality always are high?
"Jeff A. Stucker" wrote:
> What is your source for images? There are lots of good tools out there for
> reducing the size of images. For example, if your images are stored in a
> file system, IrfanView is an easy tool to use, and it has good compression
> as well.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "TiJei" <TiJei@.discussions.microsoft.com> wrote in message
> news:7BAA23AF-4337-4145-B957-06E80ABBB79B@.microsoft.com...
> > PDF - rendering of reports that contain images, makes very large
> > pdf-files.
> > Is there any option that I can set the export quality of the images?
> >
> > I have seen in this forum that there have been many questions about
> > rendering images, but very few good answers ... can anyone tell me if
> > there
> > are any solution to my problem ? .... changes in SP2?
>
>