Header issue in Crosstab report

[Former Member]

Hi,

I am using Crystal Report XI to create a crosstab report. i have created header using "Insert Text Objects" option on top of the crosstab report.The headers are not repeating in the subsequent pages. can anyone please tell me how reolve this issue? please find the attachment.

in the first screenshot i have headers present. but in the second screenshot, which is the second page of the report, the headers are not coming.

[abhilash_kumar · Accepted solution]

Hi Syed,

What section is the Crosstab in? I'm assuming the Crosstab is the Report Header and the Text object is also in the same section and that's the reason why the text object doesn't repeat.

Here's what you need to do:

1) Create this formula:

whilereadingrecords;

""

2) Go to Group Expert > Move this formula to the right pane so that a group is created on this formula. If there are any other groups in the list, move this formula to the top. This won't affect the other groups. While in the same window, select the Group > Options > Options tab > Check Repeat Group Header on each page option.

3) Insert a Group Header 1b section. To do this, go to the Design tab > Right-click the gray area beside Group Header 1 and select Insert Section Below.

4) Then move the Crosstab to this Group Header 1b section.

5) Move the text object to Group Header 1a section.

6) Next, go the Section Expert > Select Group Header 1a > check Underlay Following Sections.

Hope this helps!

-Abhilash

[Former Member · Accepted solution]

Brillaint...its working for me. thanks a lot

[Former Member · Accepted solution]

I used this solution as well and works great but one additional obstacle.  I have other non-crosstab  items in the report that follow the crosstab.  I need the Group Header 1a labels to stop at the end of the crosstab in 1b so they do not continue on pages of the report that come after the crosstab is done.  How can I achieve this?