Repeat Header on every page

[Former Member]

Dear Experts,

I have created report header using table since BO report header/footer won't available after export to excel. Now I have issue to repeat this table format header on every page eventhough I have format the option "Repeat on every page". So can anyone tell me any other format need to do it to repeat header on every page?

Please note: we not use default report header provide by BO

Platform: BI4.1 SP01

Regards

Karuppiah N

[gleo_SRAM · Accepted solution]

Hi Karuppiah

I know you have mentioned that you have already selected the "Repeat on every page".

Is the screen shot below what you have selcted - "Repeat header on every page"?

With regards

Gill

[former_member182342]

Hi Karuppiah Natesan,

    As per Gill reply, Select table and go to the properties of table and in Layout you will find the option Repeat header on each page . Check that option and apply .It will resolved your issue.

Regards,

Anish

[Former Member]

Hi Gill/Anish,

Even after selected "Repeat header on every page", Report header is not display in the second page.

I have included header as Horizontal Report not vertical report.

please help me on this.

Regards

Karuppiah N

[gleo_SRAM]

Hi Karuppiah,

I am not clear on one thing Karupahiah, are you talking about the header of a table or are we talking about a cell that you are using as a report header?

"Repeat header on every page" relates to the header row of a table. If that table flows over onto page 2 then the header will be repeated.  That's the setting in the screen shot above.

If we are talking about a cell that you have a heading the through Format Cell - Layout - Vertical the check box for Repeat on every page will do the job for you.

Remember that each page means within one tab, as you move to other tabs you will have to setup whatever tables you have on those tabs per tab.

With regards

Gill

[former_member182342]

Hi Karuppiah Natesan,

   Can you provide the screenshots of the both the pages??

Regards,

Anish

[Former Member]

check you report tables or individual cells, if they are continuing to the 2 nd page.

[Former Member]

Hi Gill,

Here I'm talking about Table Header created using another Horizontal Table since actuall Header provided by BO can't export to Excel so as suggested I have put anoth table in the Report header.

Now I want to repeat those table to multiple page, please suggest how we will do this.

Structure:

Tab1:

Horizontal Table act as Report header

Vertical Table having data; If data goes to second table I want to repeat Horizonatl Table to second table as well.

Plz help me.

Regards

Karuppiah N