Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / June 2006

Tip: Looking for answers? Try searching our database.

Spacing in header after page 1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carol - 20 Feb 2006 15:51 GMT
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 - 20 Feb 2006 20:03 GMT
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


> 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
[quoted text clipped - 21 lines]
>
> Thank you for any help you can give me on this!
Carol - 20 Feb 2006 20:48 GMT
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 - 20 Feb 2006 21:04 GMT
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 - 06 Apr 2006 20:12 GMT
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

> 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.
calvin - 30 Jun 2006 14:03 GMT
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

> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.