nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to display the header page for every sheets in excel reports

Persa

<div style="margin:0px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;">Hi,</div><div style="margin:0px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;"> I am using BIRT eclipse 4.3.1. In my project I got multi tabbed output in Excel and assigned the name for every respective tabs.But the header page is not displayed for every tab.I need to display the Master page for every tabs.Anyone please help me.</div><div style="margin:0px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;"> </div><div style="margin:0px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;"> </div><div style="margin:0px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;">Thanks In Advance.</div><div style="margin:0px;color:rgb(40,40,40);font-family:helvetica, arial, sans-serif;">For more reference I have attached a sample design file.</div>

Find more posts tagged with

Comments

GLO_FR

Hi, If you want to have your header in each excel sheets, you have to use the master page and not a field.

Persa

Dear GLO_FR, [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] Thanks for your response,[/color] If i used master page while exporting the report in Excel format, the master page is not displaying first sheet itself.Is there any other way to display the header page in every sheet.

GLO_FR

In the previous example, I put a simple "HELLO" in the master page. This header is displayed on every sheet. Maybe I don't understand exactly your needs so attach an excel file to see how the final result have to look like.

Persa

[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Dear GLO_FR,[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] [/color]In your example the 'Hello' in the master page is not displaying in every sheet of my excel when I export the report. I am using BIRT 4.3.1. My report should be multi tabs with naming for the respective tabs. I have done multi tabbing with name but the header page is not displaying in every sheet. Thanks.[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]For more reference I have attached a sample design file.[/color]

GLO_FR

Hi sorry for the late answer.I've checked it with the BIRT OS.you're right the excel export doesn't use the header in the master page. Create an header on your table and your problem should be solved.(I've used the xls_spudsoft or xlsx export)

Persa

Dear [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]GLO_FR,[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Thanks for your response. I have done header page in master page itself.I have used script for this one.[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Because If I put header page in table ,the lines are not displaying [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]when I export the report in server.So i used this method.[/color] [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Please find the attached design.[/color] [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Thanks.[/color]