Spacing in header after page 1 -- sql server reporting services

sql server reporting services : Spacing in header after page 1

Carol
2/20/2006 7:51:55 AM

I have a report that has information in the header that only needs to
print on the first page, as well as info that needs to print on all
pages. I have successfully been able to make the visibility on the
first section so that it only shows on page 1.

However, that is causing a spacing issue on the rest of the pages. I
cannot just move the 2nd piece of the header into the report body
because it contains (1) page totals and (2) a grand total.

Does anyone have any suggestions? More detailed info on the report
below:

In the page header, I have 5 textboxes of information that only need to
show up on Page 1. On pages 2-n, making the textboxes hidden does
indeed hide them but causes about a 1 1/2 - 2" gap of space between the
header and body of the report.

Under those 5 textboxes, I have another set of textboxes that needs to
print on page 1 and all successive pages. Since page totals are
included, I was unable to move those into the body of the report.

If I could do that, I could just set the page header to print on page 1
only.

Thank you for any help you can give me on this!

Chris
2/20/2006 12:03:17 PM

What sort of control are you using? List, Table or Matrix?
I'll assume Table for now.
If you are setting the visibilty of the individual cells to hidden then
this means the row will still "print", just with the data hidden. You
probably need to hide the whole row which can be done by clicking the
row handle on the left hand side of the table then changing the
visibility property.

Cheers
Chris

[quoted text, click to view]

--

Carol
2/20/2006 12:48:10 PM

I'm not using a control - list, table and matrix are not allowed in the
page header. I have textboxes. I did just discover that if I create a
rectangle and then put a table in that, it's allowed (weird).

I am going to try hiding the row, although it has to be in a separate
table b/c of the layout.

Thanks for your help!

Carol
2/20/2006 1:04:15 PM

The table in the rectangle in the page header threw an error: The table
'table2' is in the page header or footer. Data regions and
subreports cannot be used in page headers or footers. Is there a way
to do a one-page report header separate from the page header? Thank
you once again.

golf4fun
4/6/2006 12:12:02 PM

Carol,
Did you ever get the spacing issue on the 2nd and consecutive pages
resolved. I had the same problem and used some expressions in the visibility
properties of the text fields to hide or display the fields. This worked
pretty well and appears to have eliminated the extra space at the top, but a
date field justified to the right of the page moves over to the left about 2
inches now when an image that displayed on the first page is hidden. All
fields that were too the right of the image now shift to the left in place of
the image. It's great for 1 of the fields that I want left justifiied, but
not the date field that I want right justified on the page. It shifts with
everything else. Anyone know of a way to set a field in a permanent location
on the page and have it stay there.
TIA Randy

[quoted text, click to view]

calvin
6/30/2006 6:03:02 AM

Hi carol

I got a report contains somepages I want to export that to excel, after
exporting to excel the pageHeader shouldn't been seen. Tell me how to solve
this issue

Calvin

[quoted text, click to view]

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