Crosstab Report Help

[satyakumar]

Hi Friends,


I have a Crosstab report with 4 rows and 1 column.
Everything is working fine but, when i click on the next page ROW#1 repeated. Basically users wanted to export this report to Excel. When they export Row #1 is repeating for every page. They dont want it.

How do i supress the Row#1 repeatition on every page.


Now my report is looking like this....
Page#1
------

Row #1 Row#2 Row#3 Row#4 Col1
2009

ABCD 22312 dfadf dfdf3
34344 ererr 4542 13213
EFGH 24234 GHGHH GDFFH
42424 ererr 4543 13213
IJKL 78787 dfadf dfdf3
63636 RTRTT 4544 13213
Page #2
-------
IJKL 36366 RTERT YUYUT
67888 TYYYT GRGRG 13213


So the problem is they dont want to see the IJKL in the 2nd page.

we just need to show page #2 like below.

36366 RTERT YUYUT
67888 TYYYT GRGRG 13213

 

[lbass]

I found a way to do suppress a repeated row label in CR for a regular Excel export, but then the column headings for the summaries still appeared. Then I tested the Data Only export, and found that you won't get repeated page headers if you use this. I don't ordinarily like data only exports, but they seem to work great for crosstabs.

-LB

 

[satyakumar]

Hi Lbass,

Can you please tell me how you did supress the repeated row label in cross tab. For me thats ok if i get the column headings for the summaries.


Thanks
Satya..

 

[lbass]

The crosstab has to be in the report footer, too, so that the page footer is available.

Create two formulas:

//{@false} to be placed in the report header:
whileprintingrecords;
booleanvar x := false;

//{@true} to be placed in the page footer:
whileprintingrecords;
booleanvar x := true;

Select the row label->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
booleanvar x;
x = true;//note no colon

Then, while the row label is still selected, go to the borders tab->color->background->x+2 and enter:

whileprintingrecords;
booleanvar x := false;

This last formula gets processed later and resets the variable for the next row instance.

-LB