ISSUE with CROSS TAB Report.

[khan007]

I ahve a problem in cross tab report.
I have "time" in Row and "Instructor_Name" in Column and description in "Summarized field".

I have 100 of records. I want time to be on left of each page and four colums of "Instructor_Name" on each page.
But problem is that it goes to more pages but take whole report as 1 page (because it is in report header)and displaying time only on left of report, which i need to display on each page.

My desireable output is:

Ins_1 Ins_2 Ins_3 Ins_4
6:00 am 111 222 444 333
7:00 am 112 221 666 667
8:00 am 113 765 678 876
9:00 am 111 765 765 765

Now i want time on left again on next page before Ins_5 and again time on left on third page befire Ins_9.

please inform me with any sujjestion.
Thanks

 

[lbass]

Thread 149-575997 shows a method for creating "real" page breaks in your crosstab, which would result in repeating row labels. Basically, you devise a formula in the main report which clusters your crosstab columns into page groups, e.g.,

if {table.instructornumber} in 1 to 4 then 1 else
if {table.instructornumber} in 5 to 8 then 2 else
if {table.instructornumber} in 9 to 12 then 3 //etc.

Insert a group on this formula in the main report (not in the crosstab) and make it your highest order group.

Place your crosstab in the group header for this group, instead of the report header, and in format section->group header, be sure to check "new page after."

-LB