Section header across page breaks

building reports desktopintelligence
1

I have a crosstab which spans across few pages horizontally. I want to display the section headers in all the pages across. Is there any way I can do it? I am using 6.1b.

Sara

Saraswathi :australia: (BOB member since 2004-05-17)

2

If I remember, right click on the table and go to format table. There should be a spot there for headers check box that spans for all pages. Let me know if you donā€™t see it and Iā€™ll have to look it up when I get back to my machine.

Have a great night.

MayhewM :us: (BOB member since 2003-10-22)

3

Hi

Why donā€™t you just copy your section header and paste it on the 2nd page on the same horisontal level as the 1st one?

Lee :south_africa: (BOB member since 2004-03-08)

4

Probably because you cannot always tell how many pages across you gonna get with a crosstable?

jobjoris :netherlands: (BOB member since 2004-06-30)

5

Yes My report spans across 50 pages approximately horizontally. Is there anyway I can set the cross tab property so that when the page breaks the remaining values will flow to the next page down instead of across? Spanning across has lot of problems. Section headers are not repeating horizontally. When one of the section has only 50 values and the other section has 100 values then the first section has 25 (with 2 values per page) empty pages horizontally.

Thanks in advance for any help.

Sara

Saraswathi :australia: (BOB member since 2004-05-17)

6

How many rows do you have? Try rotating the crosstabā€¦

xen :india: (BOB member since 2004-11-13)

7

If I rotate the report has maximum of five pages. But users do not agree to change the format of this report.

Thanks,
Sara

Saraswathi :australia: (BOB member since 2004-05-17)

8

I think there should be an enhancement for repeating the section header on every page.or is it already existing:?:Need to open up my BO and check.

venira :india: (BOB member since 2004-12-07)

9

Greetings,

For crosstab headers to appear on every page, follow these steps.

  1. Create the crosstab
  2. Right click on the table and choose ā€˜format crosstabā€¦ā€™
  3. Goto Page Layout and put a check in the box for ā€˜repeat header on every pageā€™

For section headers to repeat on each page, follow these steps.

  1. Create a section report. Can be crosstab or regular table.
  2. Right click on the object that is the master cell for the section.
  3. Click ā€˜format cellā€™
  4. Go to the ā€˜Alignmentā€™ tab and place a check in the box ā€˜repeat on every pageā€™

You will see other settings there as well.
Is this what you are looking for?

Hope this helps,
Have a great night.

MayhewM :us: (BOB member since 2003-10-22)

10

Hi Mathew,

The section header option repeat on every page will work only if the crosstab fits in one page horizontally. If the crosstab expands to the next few pages horizontally the section headers are not repeated on horizontal pages. I have pasted the section header manually in every page now.

Moreover I am getting lots of blank pages when the number of values of the column on which crosstab is based varies from section to section.

I havenā€™t seen any options in BO 6.1b to manage this.

Thanks,
Saraswathi

Saraswathi :australia: (BOB member since 2004-05-17)

11

Well, thereā€™s one solution. Add a row on top of your crosstab. The far most left you fill with your text/variable, the ones to the right you format out by removing the borders/pattern. Then go to the formatproperties of your crosstab, tab ā€œPage Layoutā€. In the Page Break Across-section, apply ā€œRepeat header on every pageā€ and your done. Good luck.

jobjoris :netherlands: (BOB member since 2004-06-30)

12

Hi Saraswathi

Section Header will appear only once for single section it cannot be repeated.
And still if you need a title that to be repeated on every page of your section you can do as follows

Method-1(will satisfy your need)

Create a Variable-Diemension
Give the name of the variable as your section header
Drag the variable to the top-tip-end of your crosstab
It will work out

method-2(not exact to your need)

Click the page layout button
create a cell with your heading
Drag it above the header

Both the method is implemented in my attachment .check out

Regards
Thangaraj
thangas.rep (54.0 KB)

Thangaraj (BOB member since 2004-12-08)

13

Problems with crosstab with mutliple pages across are, Section headers do not repeat on pages across and there are too many blank pages when the number of pages across vary section to section. BO suport has acknowledged these bugs and there will be an enhancement soon.

Thanks,
Saraswathi.

Saraswathi :australia: (BOB member since 2004-05-17)

14

Hi Saraswathi,

I am facing the same issue in one of the reports that you had earlier. Were you able to get rid of blank pages. Please let know if you have any solution in mind for this issue.

Thanks

friend (BOB member since 2006-07-03)