We are trying to publish a group of financial reports using SQL Server
Reporting Services. We have hit a snag when we try to render the reports in
PDF format. The leading spaces of each line are stripped in the output
file. For example:
Department 10.7240 - ICU
Expenses SubDepartment
-- -
1,200 100
454 150
Becomes:
Department 10.7240 - ICU
Expenses SubDepartment
-- -
1,200 100
454 150
Does anyone know a solution for this problem? By the way, we did upgrade to SP2.
That did not correct the problem.
This blog entry (actually the comments for the entry) discusses same. Long story short, the PDF extension strips leading spaces in this version of SSRS, and there is no workaround :(
http://blogs.msdn.com/bimusings/archive/2005/06/15/429607.aspx
It sounds like you are "artificially" adding these spaces to make things line up. Can you re-position the textboxes which show the values and/or use the alignment settings to make the same thing happen?
|||Thanks for the information. Actually we are moving a fully formatted report from an old DEC Alpha system to .pdf files. Currently this is done manually. It is a process that involves cutting and pasting hundreds of pages of the original report into output for individual departments. The SSRS report consists of a single text box to hold the lines of the source report. That is why we have leading spaces.
We are able to do all the breakout of individual sections using SQL Server, but It looks like we will have to find another product to do the final conversion from text to .pdf. Actually, tiff files come out great, but they are huge and slow.
Thanks again for the good information.
No comments:
Post a Comment