Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab Report that Spans more than one Page

Status
Not open for further replies.

kcopeland

Technical User
Mar 19, 2001
9
US
I have a Crystal generate cross-tab report that spans over to another page. I am able to repeat the row and column headers of the cross tab but can I repeat the Group, Page header, and Footer (with page numbers) from the report?

Question #2: I have 4 column headers like:
ETWN
A B
B
1 2 3

Is there any way to have the top and subsequent column headers repeat (within the same page)


 
hello

Here is what you can do

1. Create a formula:

      @Title

      WhileReadingRecords;
      StringVar x:= "Title for the Cross-Tab" + Chr(13)
+ "Period from Year X to Year Y"

*:->* Chr(13) inserts a carriage return, allowing the title and subtitle to display on seperate lines.

2. Go to Format | Crosstab and add @Title to the Column Fields box.

3. Drag @Title so it is the first field listed in the Column Fields box.

The String variable now appears on the main report and on each page of the cross-tab.

Hope this helps. E. McEvoy
Crystal Reports Consultant
emcevoy@crystalconsulting.ca
 
That worked on the header on the Cross-tab but I would really like to have the reports page header and group headers repeat.

Page Header (would like repeated if cross-tab grows to more than 1 page)
Group 1 Header (" ")
Detail (hidden)
Group 1 Footer (Cross-tab is located here)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top