How to repeat cross tab row headers on multiple pages ?

building reports desktopintelligence
1

I have a cross tab report, which I am viewing in page layout mode. Now the number of columns are large enough to span the report horizontally to multiple pages. I want the cross tab row header to be repeated on every page.

It’s possible to have a header repeated on pages that span vertically by checking repeat header on every page option. But how to do it in case of pages spanning horizontally ?

Thanks in advance.

Pravin.

pravink81 :india: (BOB member since 2004-06-30)

2

Hi,

please clarify what headers you have in your crosstab.
In the case of normal crosstab the headers of columns are the values of the particular dimension. And these are displayed allways, doesn’t matter on how many pages the table lies across horizontally.

Maybe you have any breaks across edge?

So I am not sure what problem with the headers you have. Please describe.

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

By “row header” I mean the first column in the cross tab report, since it qualifies the data contained within each rows. You are saying about the column headers, which will appear on the second page.

pravink81 :india: (BOB member since 2004-06-30)

4

OK, now I see. 8)

In the Format Crosstab options, Page Layout tab there is Page Break Across group of options on the lower right side of the window. Select “Repeat header on every page” there.

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

As I had mentioned, “Repeat header on every page” works on pages that span vertically, that is in case of number of rows being large. But it does not work in case where pages that span horizontally, that is in case of number of columns being large.

pravink81 :india: (BOB member since 2004-06-30)

6

Not true.

In Page Layout tab of the Crosstab format you have two “Repeat header on every page” options. One is in the Page Break Down group of options and one is in the Page Break Across group of options. You are talking about the fist one but the later one is that you need to switch on.

Please check that.

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

7

Hi Marek,

I had missed “Page Break Across” options. My mistake. Got it now.

Thanks for all your help.

Pravin.

pravink81 :india: (BOB member since 2004-06-30)

8

OK, no problem.

Good to hear that it works not only for me. :mrgreen:

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)