Sqlserver 200 reporting services -- sql server reporting services

sql server reporting services : Sqlserver 200 reporting services

lamba
3/1/2006 12:46:05 PM

I have created a sql server report with one main report and 4
subreports and one rectangular label having height as of four
subreports in the tablefooter. table has detail row and below there is
a table footer which has subreports and rectanle merged in it. When
detail and subreportsits fit on first page, it shows good in preview
but when exported in pdf format it shows one extra empty page which I
don't want. Another problem is that when detail is bigger and table
footer does not fit, it does not slide the table footer on second page
instead it overwrites the detail section. I want to show the
tablefooter at the end of the page but if it does not fit, the whole
table footer should slide on second page. all margins and page height
etc work fine on first page if detail lines fit into it except a blank
page in pdf format. Other problem is when detail lines are much more to
expand at the end of first page and table footer stuff does not go on
other page. My report can not go beyond 2 pages.

Kaisa M. Lindahl Lervik
3/2/2006 12:00:00 AM

First of all, make sure that the report width and hight + margins is not
greater than your page width. If your page is 29cm wide, the sum of (report
+ left margin + right margin) must be less than 29. PDF are rendered a bit
differently from the preview, so you need to be carefull with these widths.
This goes for subreports too.

Both tables and matrixes has a property setting called "Fit on page if
possible", try checking it to see if it all fits on one page.

(Also, friendly advise - split your questions up in sections. It's easier
for us to read if you start each question on a new line. :) )

Kaisa M. Lindahl Lervik

[quoted text, click to view]

lamba
3/7/2006 10:36:21 AM

I have tried the above. My page is 11by 8.5. I have set all margins as
..25. Report as 10 " wide and body height 6", header as 1". Subreports
are all lesser in dimensions included in table footer.. Page footer is
0 height. I don't see there is anything wrong with the page
settings.The report fits on one page in preview. Only when it exports
to PDF format it shows an extra blank page.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn