Reporting Services (Page Issue)

I have created a report in visual studio 2005, using the reportserver. I am able to create the report as a pdf, but for somereason, data is begin shown on every other page.

Does anyone know what might cause this?

Before deploying the report have a look at it in preview mode sounds like you may have a margin applied that is increasing the overall width of your page and causing it to go onto the next page|||Thank you. That was the problem

Reporting Services - Export to PDF problem with links

Hi,

After exporting a RS report to PDF the links(Jump to Report) are removed. Is there anyway to keep the links?

We moved to reporting services about a year ago and have been migrating reportings from our old platform webfocus which when we exported to PDF would retain the links.

Thanks in advance

Dave

*Bump* anyone?|||

Please anyone!!! We just migrated from webfocus to MSRS and you could get links working in PDF export in Webfocus... Can RS do this yes or No

anyone?

thanks

dave

|||

Daveycur,

This should work. I have a link to a document in one of the report and when exported to PDF the links is still active and I am able to open the document from PDF. So, links should work when exported to PDF. See if it has to do with the version of Reporting services you are using and also makre sure that there are nothing else that is blocking this.

|||

Thanks for the reply techquest

I am using RS2005. Can't find anything that would stop the link appearing in the PDF. When i export a webfocus report on the same machine the links work. Is there a reporting services options i need to check?

Thanks again

Dave

|||

What service pack are you on?|||

Hmm it seems you can do a jump to URL, but not a jump to report link.

So i guess the only around this would be by formulating a URL using the other report name and passing its params with it.

Thats a b*ll ache! especially when the report jumps to about 30 other reports!

thanks

Dave

Reporting Services - Export to PDF problem

We are facing some problem while exporting the SSRS (SQL Server 2005 SP2 installed on win2K3) Report to PDF format, problem is when we export report to PDF format all the data after 80 columns gets wrapped to next page which not only increases no. of pages in the reports but also disturbs the report format for example if a report contains only one page and 320 columns of data and if we export it to PDF format then the PDF file will have 4 pages each having 80 columns of date. Has anybody faced the similar issues? would appreciate if you can give solution for this problem or forward any link which discusses the same.

That is a common problem, you are exceeding the width of a sheet of A4. With 80 columns your column width would have to be tiny to fit them all on one page. You can get yourself a little extra width on the page by having it render in landscape mode, just swap over the width/height values under the PageSize parameter for the report. You can also reduce the margin sizes. These techniques will not get you a lot of extra space, if you still need more then the only way to get it is to redesign the report (more tables) or select less data (narrow the parameters or filter the returned data).

sql