Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gashdc
Starting Member
12 Posts |
 Posted - 2004-11-12 : 11:26:00
|
| Hello all, have another question for anyone who can answer this. I have a report that is made up of several smaller reports. My main report has a main loop and then an inner loop. I have this set up so that each sub report is seperated by a page break. This works fine when it is published, but when I go to export it to a PDF, the first page is always blank (accept for the header at the top of the page which contains the correct data for the first page). I tried to do a little research on this issue and the closest thing that I found was someone else posing a similar question on an MSDN "Chat" (http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx) Microsofts response was essentially "we've seen it but cant fix it". Does anyone else have a similar issue or no of any sort of work around to fix this? Thanks in advance for your help.David |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-12 : 14:36:55
|
| Hi Dave,Check the report properties and change the sizing of the right / left / top / bottom margins of the report.Jon |
 |
|
|
gashdc
Starting Member
12 Posts |
Posted - 2004-11-15 : 09:12:19
|
| Jon,I changed my margins from .25inches all the way around to .5inches all the way around and still no luck. The first report (which is essentially the same as all the other reports, just with different data) is always blank. Ill try and work with it more though, thanks for the help!David |
|
|
|
gashdc
Starting Member
12 Posts |
Posted - 2004-11-16 : 13:01:56
|
| Jon,Well I worked around with the margins and size of the report itself and I finally figured it out ... sort of. What is happening is that I have a number of different tables, charts and marticies on my report. In order to make them all fit I have the following settings:width = 11 height = 8.5 margins: left = .25 right = .25 top = .15 bottom = .15This allows me to fit everything onto one page without spilling over and displays fine on the web through report manager and even exports to pdf fine ... except for the first page being blank. So I figured out if I changed everything to the following settings all pages would be displayed:width = 11 height = 7.55 margins: left = .25 right = .25 top = .45 bottom = .45Unfortunatly now the report no longer fits on one page and spills over onto two (essentially messing up all of my formatting), and if I decrease any margin value for the height by even .01 or increase the height any, the report will once again fit on one page, but will no longer display the first page. Anyways a rather lengthy explanation I know, but essentially I think it may be some sort of bug or just a quirk. Oh and also the same behavior is seen when exporting to a Tiff as well as a PDF.Thanks again,David |
|
|
|
|
|
|
|
|
Exporting to PDF results in first page being blank