cancel
Showing results for 
Search instead for 
Did you mean: 

CrossTab headers and page count

Former Member
0 Kudos

I have a Crosstab in my Report Header, and in my Group footer 1 and I am wanting to:

1) Place a header for each crosstab that would say something like 'Crosstab1 Totals' and have that repeated at the top of every page when it is printing 'Crosstab1'

2) Display a unique page N of M that is reset for each crosstab, but without changing the main page count.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi,

Could you please help us visualize point # 1.

Also, for point # 2, do you wish to see the Page N of M on horizontal pages or on the Group Footer? Does the Group Footer have 'New page After' enabled?

-Abhilash

Former Member
0 Kudos

D

GF2

GF1 "Fruit Totals" Page1 of 5

CROSSTAB Here in GF1, but it extends over the next 5 pages

GF1(continued on next page) "Fruit Totals" Page2 of 5

CrossTab still here, but the heading 'Fruit Totals is printed again at the top to illustrate

that this is still the Summary of the Fruit totals and we are on page 2of5 for those summary pages.

Hopefully that help a bit more

patrick_genest
Advisor
Advisor
0 Kudos

Hi,

To repeat a header on each horizontal pages that is created when a cross-tab expand past the page size defined, you can use the formatting option "Repeat on Horizontal Pages"

To do so:

1. Insert a text object in the same section of your cross-tab

2. Type the heading text you want

3. Right click on the Text Object, and select: "Format Text"

4. In the "Format Editor", under the tab: "Common", check the option: "Repeat on Horizontal Pages"

As for your second question, there is a special field called Horizontal Page Number.

It is not a page N of M for horizontal page, but it will tell you on which horizontal page you are.

Hope this help!

Patrick

Former Member
0 Kudos

Thank you for your help, but I think 'Horizontal pages' is not what is happening here. I am not too sure what that is but I am guessing that means the width is too much so it creates extra pages. My issue is that I have about 6 columns wide and up to 20 or more long, so the pages are coming from the vertical length of the page not the horizontal.

patrick_genest
Advisor
Advisor
0 Kudos

Hi,

There is no option to repeat the text object when the cross-tab print on more than one page vertically.

A suggestion will be to add a formula that contains the text you want to display as the first column of your cross-tab.

Then suppress the grand total for the row and column for the first column.

This will repeat the text you entered in the formula on each page the cross-tab print.

Patrick

Former Member
0 Kudos

Thank you for your help. On the page thing...Is there a way to create a formula of the 'Page N of M' and then reset it somehow?

That way I could create a separate formula that would display the page 1 of 5, but I dont know if there is a way to reset it...

abhilash_kumar
Active Contributor
0 Kudos

Hi,

Well, if you want every cross-tab placed in the Group Footer to show Page N of M, then you would need to insert a subreport (Linked) that contains the cross-tab. This way the Cross-tab would reset for every group which would also reset the Page N of M.

The subreport, however, would show the Page numbers only on the last page as it does not have a Page header.

Here's a workaround to show the Page N of M on each page:

1) In the subreport, create a new formula called 'FakeGroup':

whilereadingrecords;
"";

2) Create a Group on this formula

3) Right-click the group header 1 and select Insert Section Below. This will create another Group Header b section

4) Place the cross-tab in this section (Group Header 1b)

5) Go to Group Expert > select the Fake group > Options > options tab > check 'Repeat Group Header in Each Page'

6) Place the Page N of M on the 'Group Header 1a' section

Hope this helps!

-Abhilash

Answers (0)