on 12-02-2011 1:04 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
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
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.