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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab ???

Status
Not open for further replies.

lstieg

Technical User
Nov 5, 2010
18
0
0
US
In Crystal XI R2 is there a way to suppress the column headings if the crosstab spans multiple pages... I have tried EVERYTHING.

See below... if you look down you can see it repeats the dates.

02/01 02/02 02/03
Total Official / Unofficial/ Total 2865 2732 1766
73 87 56
2938 2819 1822
Name 0 0 0
0 0 0
0 0 0
Name 0 0 0
0 0 0
0 0 0
Name 41 46 31
0 0 0
41 46 31
Name 0 0 0
0 0 0
0 0 0
Name 49 39 92
0 0 0
49 39 92
02/01 02/02 02/03
Name 22 0 16
1 0 0
23 0 16
Name 26 28 6
0 2 0
26 30 6
Name 29 38 22
5 3 0
34 41 22
Name 149 95 69
0 0 0
149 95 69


Thanks
 
Use a conditional suppression formula:

pagenumber <> 1

You can then format the grid lines to remove the lines surrounding the empty labels (although this will remove them on the first page also). There isn't a way to remove the empty space altogether.

Another option might be to set up use a printer that allows continuous feed--not sure what that would be, and it assumes that you are not planning to actually print this, but perhaps to export it without the headings.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top