Print Page | Close Window

Cross Tab Header for Groups

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20742
Printed Date: 02 May 2024 at 8:29pm


Topic: Cross Tab Header for Groups
Posted By: HEMREDDY
Subject: Cross Tab Header for Groups
Date Posted: 15 May 2014 at 10:58am
Hi,
 
I am trying to get a header Text created for the groups in the cross tab report like below.
 
Customer  Invno   12/2013   1/2014  2/2014  Total
 
The text highlighted in bold above comes from cross tab report of we want column totals by month for the two groups Customer and Invoice no.
 
I want to get the header :Customer   and Invno on each page. It comes blank for all pages.
 
Some one in another forum suggested the following. Still i am getting the text field on the first page only and not on all pages. Below is what was suggested. Can some one clarify what i am doing wrong.
 

Issue:

When designing a cross-tab in Crystal Reports (CR)

version 10, by default there is a blank rectangle

above the row headings where the column headings

are specified.

How can you add a text label at the top of the

rows in a cross-tab that spans multiple pages?

Resolution:

To add a text label at the top of the rows in a

cross-tab that spans multiple pages you must create

a "fake" report header and insert the cross-tab and

text label into it.

1. Create a formula for an empty group:

WhileReadingRecords;

""

2. Insert a group based on this formula. This

will be used instead of the report header and must

be the only group for the entire report or your

label will not be aligned properly.

3. Add the text object that you wish to display

as your label for the cross-tab to the group

header.

4. Right-click the text object, then click 'Format

Text'.

5. On the Common tab, click 'Repeat On Horizontal

Pages'.

6. On the 'Report' menu, click 'Section Expert'.

7. Click Group Header 1 and then click 'Underlay

following sections'.

8. Place the cross-tab in the group header and

adjust the alignment of the text object as needed

to display your label in the correct place.

 
I am on ver 12 with crystal reports.
 
Hem reddy



Replies:
Posted By: Erik
Date Posted: 18 Jun 2014 at 5:54am
I hope it's OK to link to another site. This seems to address your issue.

http://stackoverflow.com/questions/7587626/row-header-for-cross-tab-report-in-crystal-reports



Print Page | Close Window