Vertical Page number in multiple crosstabs in multiple report headers

[Former Member]

Guys,

Not sure if this was already answered.

I have below scenario

Report Header A having Crosstab-A

Report Header B having Crosstab-B

Report Header C having Crosstab-C

Report Header D having Crosstab-D

Report Header E having Crosstab-E

Page Header- blank suppressed

Details - blank sippressed

Report Footer - blank

Page Footer - blank

When you run the report only one crosstab will be visible based on what you selected in input prompts.

My issue is when I add field Page N of M i get only page number on last page.

I even tried added in Report Footer but still it comes only on last page pnly

How do you add page number on all page of display?

I want vertical page number

Thanks

Vishal

[abhilash_kumar · Accepted solution]

Hi Vishal,

The easiest solution is to place the Cross-tab in the Report Footer.

If you do not wish to place the cros-tab in the Report Footer, here's what you need to do:

1) Create a formula;

whilereadingrecords; 
"";

2) Create a group on this formula. If the report already contains groups, move this formula to the top of the grouping list. It won't affect the other groups or records in any way.

3) Move the Cross-tab from the Report Header to the Group Header1 and suppress Group Footer1

4) Add the Page Number field to the Page Footer

Let me know how this goes!

-Abhilash

[Former Member · Accepted solution]

this response i have seen in other threads but i have multiple cross-tabs and report headers..

Can you be specific to my scenario what to do?

also i created a formula field pageno with formula, then what next?

how to create group on this formula field?

I cannot move cross tab to header as I have 5 cross tabs each in different report headers?

[abhilash_kumar · Accepted solution]

If you can't move the Crosstab from the Report Header to the Group Header, then you won't be able to workaround this issue.

The steps above are as detailed and specific as they can be.

Use the Group Expert to create the group on the formula.

The steps above also state where the Page Number field should be placed.

-Abhilash

[Former Member · Accepted solution]

you mean to say move all 5 report headers in 1 group header?

[abhilash_kumar · Accepted solution]

Of course not!

Just like you've created multiple Report Header sections and applied suppression logic on each of them, create multiple Group header sections and apply the same suppression logic.

-Abhilash