jasper report page header

Stack Overflow Public questions & answers
Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
Talent Build your employer brand
Advertising Reach developers & technologists worldwide
About the company

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Connect and share knowledge within a single location that is structured and easy to search.

Jasper Reports - Removing pageHeader/columnHeader from subreport

I have a master report with 2 subreports. I use the same report to generate PDF and xls. Pagination is enabled but for excel, i need to disable pagination, which i do by rendering all in one sheet. The page header/column header get repeat for each page. These page header/column header are from the sub reports. This is fine for PDF but in case of excel, i want to get rid of the repeating header. I set these properties:

But these arent reflected in the data rendered by the subreport. In xls, i still see the pageHeader/columnHeader gets repeated. Please let me know, how to fix this.

jasper-reports

2 Answers 2

For XLS (and HTML) reports, you may want to set the parameter IS_IGNORE_PAGINATION to true. See http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRParameter.html for documentation.

Thanks a lot. I am generating pdf and excel at the same time and intend to fill it once and export them into required formats. But now i need to fill them separately for each export. But i will take the answer, which solves my problem. I still wondering why the properties are not getting applied to subreports. – Dhanagopal Sivaraman Aug 2, 2011 at 13:39

I know this is an old question, but I keep forgetting how to do this myself and each time I search I seem to find this question so thought I'd put something so I find it next time.

In the main report file you also need to add the sub report to the filter:

Thanks man, it works! Just a clarification: since the subreport tag doesn't accept the attribute "name", "sub-report-name" should always be replaced by the string "subreport". – Tiago Peres França Sep 18, 2014 at 13:46

Your Answer

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct .

Not the answer you're looking for? Browse other questions tagged jasper-reports ireport or ask your own question .

Hot Network Questions

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy .

Report Sections

We discussed the structure of a simple report template in the chapter Getting Started . On similar lines, JasperReports structures the report template into multiple sections. Sections are portions of the report that have a specified height and can contain report objects like lines, rectangles, images, or text fields.

The report engine iterates through the virtual records of the supplied report data source, at report filling time. Depending on each section's defined behavior, the engine then renders each report section when appropriate. For instance, the detail section is rendered for each record in the data source. When page breaks occur, the page header and page footer sections are rendered as needed.

In JasperReports, terminology and report sections are also called as report bands . Sections are made up of one or more bands. These sections are filled repeatedly at report-generating time and prepare the final document.

Main Sections

A report template in JasperReports has the following main sections −

The following table summarizes each of the sections −

Section, Elements and Attribute Relation

The following diagram shows the elements and attributes relationship in a section of a report.

Section Elements

All the above mentioned report sections are optional. But any report template will have at least one such section. Each of these sections contains a single < band > element as its only sub-element. A < band > can contain zero or more following sub-elements −

Each of these elements must contain a single < reportElement > as its first element (except elementGroup). A < reportElement > determines how data is laid out for that particular element. Unlike variables and parameters, report elements are not required to have a name, because normally you do not need to obtain any individual element inside a report template.

The table below summarizes the attributes of < reportElement > −

Section Attributes

Following are the attributes of a report section −

Height of the section specifies the height in pixels for that particular section and is very important in the overall report design.

Print When Expression

A Boolean expression that determines whether the section should be printed or not.

Split Allowed

A flag indicating whether the section is allowed to split when it does not fit on the current page. If true, the section will be transferred to the next page. Note that in case, the section does not fit on the next page, then the section will be split regardless of the flag's value. splitType can take following values −

splitType="Stretch:" Splits stretched content. If the section stretches on the current page (if the available space is less than declared height), the region that is added to the original height is allowed to split onto the next page.

splitType="Prevent:" Prevent split on first attempt. If the section does not fit on the next page, the split occurs normally, as band split prevention is effective only on the first split attempt.

splitType="Immediate:" Split immediately. The band is allowed to split anywhere except above, its topmost element.

To demonstrate each section, let's write report template (jasper_report_template.jrxml). Save this file to C:\tools\jasperreports-5.0.1\test directory. In this file, we would be displaying a text in each of the sections (we discussed above). The contents of the file are as given below −

The java code to fill and generate the report is given below. Let's save this file JasperReportFill.java to C:\tools\jasperreports-5.0.1\test\src\com\tutorialspoint directory.

Here, we use an instance of JREmptyDataSource when filling reports to simulate a data source with one record in it, but with all the fields in this single record being null.

Report Generation

We will compile and execute the above file using our regular ANT build process. The contents of the file build.xml (saved under directory C:\tools\jasperreports-5.0.1\test) are as below.

The import file - baseBuild.xml is picked up from the chapter Environment Setup and should be placed in the same directory as the build.xml.

Next, let's open command line window and go to the directory where build.xml is placed. Finally, execute the command ant -Dmain-class=com.tutorialspoint.JasperReportFill (viewFullReport is the default target) as follows −

As a result of above compilation, a JasperViewer window opens up as in the screen below −

Here, we can see in each of the sections a text is printed. It is to be noted that as JRXML contains a <lastPageFooter> element, it will be displayed in the last page of the report instead of the <pageFooter> element being displayed. The <columnHeader> and <columnFooter> elements will only be displayed on the report, if it has more than one column.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Page headers and footers in a paginated report (Report Builder)

9 contributors

A paginated report can contain a header and footer that run along the top and bottom of each page, respectively. Headers and footers can contain static text, images, lines, rectangles, borders, background color, background images, and expressions. Expressions include dataset field references for reports with exactly one dataset and aggregate function calls that include the dataset as a scope.

Each rendering extension processes pages differently. For more information about report pagination and rendering extensions, see Pagination in Reporting Services (Report Builder and SSRS) .

By default, reports have page footers, but not page headers. For more information about how to add or remove them, see Add or Remove a Page Header or Footer (Report Builder and SSRS) .

Headers and footers commonly contain page numbers, report titles, and other report properties. For more information about how to add these items to your report header or footer, see Display Page Numbers or Other Report Properties (Report Builder and SSRS) .

After you create a page header or footer, it is displayed on each report page. For more information about how to suppress page headers and footers on the first and last pages, see Hide a Page Header or Footer on the First or Last Page (Report Builder and SSRS) .

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder , and in Report Designer in SQL Server Data Tools.

Report Headers and Footers

Page headers and footers are not the same as report headers and footers. Reports do not have a special report header or report footer area. A report header consists of the report items that are placed at the top of the report body on the report design surface. They appear only once as the first content in the report. A report footer consists of report items that are placed at the bottom of the report body. They appear only once as the last content in the report.

Displaying Variable Data in a Page Header or Footer

Page headers and footers can contain static content, but they are more commonly used to display varying content like page numbers or information about the contents of a page. To display variable data that is different on each page, you must use an expression.

If there is only one dataset defined in the report, you can add simple expressions such as [FieldName] to a page header or footer. Drag the field from the Report Data pane dataset field collection or the Built-in Fields collection to the page header or page footer. A text box with the appropriate expression is automatically added for you.

To calculate sums or other aggregates for values on the page, you can use aggregate expressions that specify ReportItems or the name of a dataset. The ReportItems collection is the collection of text boxes on each page after report rendering occurs. The dataset name must exist in the report definition. The following table displays which items are supported in each type of aggregate expression:

The following sections in this topic show ready-to-use expressions that get variable data commonly used in headers and footers. There is also a section on how the Excel rendering extension processes headers and footers. For more information about expressions, see Expressions (Report Builder and SSRS) .

Adding Calculated Page Totals to a Header or Footer

For some reports, it is useful to include a calculated value in the header or footer of each report; for example, a per-page sum total if the page includes numeric values. Because you cannot reference the fields directly, the expression that you put in the header or footer must reference the name of the report item (for example, a text box) rather than the data field:

=Sum(ReportItems!Textbox1.Value)

If the text box is in a table or list that contains repeated rows of data, the value that appears in the header or footer at run time is a sum of all values of all TextBox1 instance data in the table or list for the current page.

When calculating page totals, you can expect to see differences in the totals when you use different rendering extensions to view the report. Paginated output is calculated differently for each rendering extension. The same page that you view in HTML might show different totals when viewed in PDF if the amount of data on the PDF page is different. For more information, see Rendering Behaviors (Report Builder and SSRS) .

For Reports with Multiple Datasets

For reports with more than one dataset, you cannot add fields or data-bound images directly to a header or footer. However, you can write an expression that indirectly references a field or data-bound image that you want to use in a header or footer.

To put variable data in a header or footer:

Add a text box to the header or footer.

In the text box, write an expression that produces the variable data that you want to appear.

In the expression, include references to report items on the page; for example, you can reference a text box that contains data from a particular field. Do not include a direct reference to fields in a dataset. For example, you cannot use the expression [LastName] . You can use the following expression to display the contents of the first instance of a text box named TXT_LastName :

=First(ReportItems!TXT_LastName.Value)

You cannot use aggregate functions on fields in the page header or footer. You can only use an aggregate function on report items in the report body. For common expressions in page headers and footers, see Expression Examples (Report Builder and SSRS) .

Adding a Data-Bound Image to a Header or Footer

You can use image data stored in a database in a header or footer. However, you cannot reference database fields from the Image report item directly. Instead, you must add a text box in the body of the report and then set the text box to the data field that contains the image (note that the value must be base64 encoded). You can hide the text box in the body of the report to avoid showing the base64-encoded image. Then, you can reference the value of the hidden text box from the Image report item in the page header or footer.

For example, suppose you have a report that consists of product information pages. In the header of each page, you want to display a photograph of the product. To print a stored image in the report header, define a hidden text box named TXT_Photo in the body of the report that retrieves the image from the database and use an expression to give it a value:

=Convert.ToBase64String(Fields!Photo.Value)

In the header, add an Image report item which uses the TXT_Photo text box, decoded to show the image:

=Convert.FromBase64String(ReportItems!TXT_Photo.Value)

Using Headers and Footers to Position Text

You can use headers and footers to position text on a page. For example, suppose you are creating a report that you want to mail out to customers. You can use a header or footer to position the customer address so that it appears in an envelope window when folded.

If you are only using the text box to populate a header or footer, you can hide the text box in the report body. Placement of the text box in the report body can have an effect on whether the value appears on the header or footer of the first or last page of a report. For example, if you have tables, matrices, or lists that cause the report to span multiple pages, the hidden text box value appears on the last page. If you want it to appear on the first page, place the hidden text box at the top of the report body.

Designing Reports with Page Headers and Footers for Specific Renderers

When a report is processed, data and layout information are combined. When you view a report, the combined information is passed to a renderer that determines how much report data fits on each report page.

If you view a report on the report server using a browser, the HTML renderer controls the content on the report pages that you see. If you plan to deliver reports in a different format than you use for viewing, or if you plan to print reports in a specific format, you may want to optimize the report layout for the renderer you plan to use for the final report format. For more information about report pagination, see Pagination in Reporting Services (Report Builder and SSRS) .

Working with Page Headers and Footers in Excel

When defining page headers and footers for reports that target the Excel rendering extension, follow these guidelines to achieve best results:

Use page footers to display page numbers.

Use page headers to display images, titles, or other text. Do not put page numbers in the header.

In Excel, page footers have a limited layout. If you define a report that includes complex report items in the page footer, the page footer won't process as you expect when the report is viewed in Excel.

The Excel rendering extension can accommodate images and absolute positioning of simple or complex report items in the page header. A side effect of supporting a richer page header layout is reduced support for calculating page numbers in the header. In the Excel rendering extension, default settings cause page numbers to be calculated based on the number of worksheets. Depending on how you define the report, this might produce erroneous page numbers. For example, suppose you have a report that renders as a single large worksheet that prints on four pages. If you include page number information in the header, each printed page will show "Page 1 of 1" in the header.

A more accurate page count is based on logical pages that correlate to the dimensions of a printed page. In Excel, the page footer uses logical page numbers automatically. To put the logical page count in the page header, you must configure the device information settings to use simple headers. Be aware that when you use simple headers, you remove the capability of handling complex report layout in the header region.

For more information, see Exporting to Microsoft Excel (Report Builder and SSRS) .

Embed an Image in a Report (Report Builder and SSRS) Rectangles and Lines (Report Builder and SSRS)

Additional resources

JasperReports Tutorial: What is Jasper report for Java? Example

What is jasperreports for java.

JasperReports is an open-source reporting tool for Java that is used for reporting of applications. This reporting tool helps in writing rich content onto the screen, to the printer, or into a variety of files like HTML, PDF, XLS, RTF, CSV, XML, ODT and TXT. JasperReports can also be used for Java-enabled applications like Java EE or web applications to generate dynamic content.

In this JasperReports step by step tutorial, you will learn:

Why use Jasper Reports?

Life-cycle of JasperReports

Features of Jasper Reports

Jasper vs. pentaho, creating a report template example, challenges faced while creating jasperreports, disadvantages of using jasper reports, how to install jasper reports- environment setup.

Now in this Jaspersoft Studio tutorial, let’s learn the step by step process for JasperReports environment setup:

Step 1) Download jasper reports community edition Go to this Link and click on Download Now option to install Jasper Reports Community edition .

Step 2) Select Jaspersoft Studio CE From the community editions, Select Jaspersoft Studio CE

Step 3) Download Jaspersoft Studio Go to this link and click on Download button. open the download TIB_js-studiocomm_6.9.0_windows_x86_64.exe file.TIB_js-studiocomm_6.9.0_windows_x86_64.exe.

Step 4) Click on agree button Following screen will appear, select the I agree button.

Step 5) Choose location Select your installation location and click on Next button.

Step 6) Progress is running now You will see the progress on the next screen.

Step 7) Click on finish button In the next screen, click on the finish button.

Step 8) Progress is complete Following screen will appear in your window.

Step 9) Get Started Next, Click on Get started option.

Step 10) Start working with Jasper Reports studio Following screen will appear you can start working with Jasper Reports studio.

Here, are many reasons for using a Jasper report tool:

Lifecycle of JasperReports

Now in this JasperReports tutorial, we will learn about Lifecycle of JasperReports.

Following are General flow of Life cycle of Jasper Reports:

Designing the report:

This will be the first step where we create the JRXML file. It is the file is a simple XML document which defines the report layout. You can develop this file using any text editor, or report designer.

However, if you are using the report designer, we can visualize the layout of the report, and the real structure of the JRXML should be ignored.

Compiling the report:

In this life cycle stage, the JRXML which is built in the first stage is compiled, and a binary object called the Jasper file (file with jasper xtn) is generated.

This compilation is done to get better performance during execution. These generated Jasper files should be shipped along with your application to run the reports.

Executing the report:

In this stage, the data from the application is gathered and filled in the compiled report format. There is a class called net.sf.jasperreports.engine.JasperFillManager which offers functions to fill the data in the reports.

The output will be stored in Jasper print file (file with jprint xtn) which can be used to print or export the report.

Exporting the report to the desired format:

In this last stage, you need to export the Jasper print file which is created earlier into any format using the class JasperExportManager. As Jasper offers multiple formats of exports, we can use the same input to create various representations of the data.

Now, we will cover the features of JasperReports in this JasperReports step by step tutorial.

Here, are Important Features of Jasper Reports tool:

Now, we will learn about the difference between Jasper and Pentaho in this Jasper Reporting tutorial.

Here are major differences between Jasper and Pentaho:

Now in this JasperReports tutorial, let’s learn how to create a Report template in JasperReports.

The report template file used in JasperReports is a simple XML file having jrxml extension. This file contains the tag as its root element. JasperReports framework can handle different types of data sources.

Report template is designed and created using the following two steps –

Step 1) Creating the JRXML file in Jaspersoft Studio.

Step 2) Selecting the desired template.

Step 3) Selecting a parent folder.

Step 4) In Data Source window , click on “New” button to create new data adapter.

Step 5) Selecting a data adapter.

Select data adapter from the list box. For example, “Collection of JavaBeans.”

Step 6) Entering data adapter details and selecting factory class.

Step 7) Entering prefix or pattern.

Step 8) Defining factory class and adding the path to jar files.

Step 9) Click on the “Next” button.

Step 10) Congratulations! You have added all necessary report creation information successfully. Click on “Finish” button.

The report will be generated as shown in below screen.

The above file requires to compile into JasperReport Binary format, which is called the jasper file.

The Interface net.sf.jasperreports.engine.design.JRCompiler, which is part of the JasperReports library, plays an important role in the compilation of this report template file.

Implementation of this interface can be written in Java , JavaScript , Groovy , or any other scripting language.

You can compile a JRXML file in the following two methods:

Understanding the different report bands

Following are standard report format adopted by most of the commercial report generating tools.

Let’s Learn each reporting bands in detail:

This band is shown at the starting of the report. It can be used as the first page by setting the attribute isTitleNewPage="true."

Page Header:

Page header reporting band shown at the beginning of each page. It excludes the first page if the title band is used and the last page if this summary band is used with setting isSummaryWithPageHeaderAndFooter="false.".

Column Header:

Column headers appear before the detail band on each page.

Detail section iterated for each record in data source supplied. It also allowed having multiple detail band ( 1, 2, etc.)

Column Footer:

This section appears below the detail band on each page where detail band is present. The default setting is the end of the page, but this can be switch to under last detail band by setting the attribute isFloatColumnFooter=" true."

Page Footer:

This section will be displayed at the end of each page excluding summary band, title band, the and last non-summary band.

Last Page Footer:

This section appears on the previous page (if not a summary band is given) in place of normal page Footer.

The summary section only appears at the end of the report on a new page. when isSummaryNewPage="true" is set and with page header and footer is set isSummaryWithPageHeaderAndFooter="true".

Group Header:

This section only appears when it is defined every time the group expression change before the detail band.

Group Footer:

This section only displays if a group is defined every time before the group expression change after the detail band.

Background:

It is displayed on all the pages as background to all other reporting bands.

This band will appear when no data source was passed, or the data source is empty and whenNoDataType=”NoDataSection” is set.

Here, are a few challenges you will face while creating Jasper Reports:

Here, are drawbacks/cons of using Jasper Reports.

jasper-reports

jasper-reports Getting started with jasper-reports Understanding the different report bands

Fastest entity framework extensions.

This band is showed once at the beginning of the report. It can be used as first page by setting the attribute isTitleNewPage="true"

Page Header

This appears at the beginning of each page excluding first page if Title band is used and last page if Summary band is used with setting isSummaryWithPageHeaderAndFooter="false"

Column Header

This appears before the detail band on each page.

This section is iterated for each record in datasource supplied. It is allowed to have multiple detail band (detail 1, detail 2 .. detail n), the are iterated as follows

Column Footer

This appears below the detail band on each page where detail band is present. The default setting is end of page (before Page footer) but this can be switch to under last detail band (last record) by setting the attribute isFloatColumnFooter="true"

Page Footer

This appears at the bottom of each page excluding title band, summary band (without page footer) and last non summary band if Last Page Footer is used.

Last Page Footer

This appears on last page (if not summary band without page footer) instead of normal Page Footer

This appears at the end of the report in new page if isSummaryNewPage="true" is set and with page header and footer if isSummaryWithPageHeaderAndFooter="true"

Group Header

This section appears if a group is defined every time the group expression change, before the detail band.

Group Footer

This section appears if a group is defined every time before the group expression change, after the detail band.

This band is displayed on every page as background to all other bands.

This appears only if no datasource was passed or the datasource is empty (0 records) and whenNoDataType="NoDataSection" is set.

Got any jasper-reports Question?

Get monthly updates about new articles, cheatsheets, and tricks.

Custom Jaspersoft Studio Report: How to avoid having repeated headers in Reports and Jobs in Clarity

Article id: 194696, updated on:, issue/introduction.

We are running a custom Data dump / extract report with many records in immediate mode in Advanced Reporting. We cannot run it from Reports and jobs as when we do, we have issue with repeated headers on each page in Excel. The results are imported into another system so we cannot have this duplicate headers. Please advise.

Environment

Release : All supported Clarity releases

Component : CA PPM JASPERSOFT

The reason for the difference in behavior between Advanced Reporting and Reports and Jobs in Clarity:

The headers are automatically suppressed in Advanced Reporting in $Jaspersoft\webapps\reportservice\WEB-INF\classes\jasperreports.properties

In Clarity - Reports and Jobs a API is used that does not go through this file. This is why you should configure your report in Jaspersoft Studio to avoid the difference in behavior on Excel export.

Open your report for editing in Studio.

1. If you are using a Group, you should not check the option Reprint Header On Each Page

2. If you do not use a Group, then you should use the Print When Expression option:

Use an expression such as below:

Once modified, save the report back to Jaspersoft and try again after reloading it to run it from Reports and Jobs in Clarity.

Additional Information

Note : If you want the headers but you don't want the headers only when you are exporting, there is a property in Excel to remove the headers:

How can I suppress page headers and footers when exporting to XLS?

Attachments

IMAGES

Monitor More with Opspacks
PPT
Jasper reports Development
Jasper Report New Page
Jasper reportsJasper reports
jasper reports

VIDEO

Jasper Report Server Demo
احنا نقدر نعمل ايه بالـ Oracle Bi Publisher and Jasper Report
Jasper List Report Using parameter Passing method
Create multiple report In One Report Jasper report
031
Repeat ROW and COLUMN Headers on Each page in Excel

COMMENTS

Report Structure in Jaspersoft Studio
Overview A report is defined by means of a type page. This is divided into different horizontal portions named bands. When the report is joined with the data generating the print, this section is printed many times according to their functions (and according to the rules that the report author has set up). For instance, the page header is repeated at the beginning of every page, while the ...
How to enable different page headers on last and middle pages in jasper
I need to enable the reports with 3 types of the page headers: "first page header", "middle pages header" and "last page header". All of these headers can have different number of report elements and on different positions. Same goes for the footers. NOTE: The report must support the report elements like jr:table or jr:list in its Detail band ...
I want to display PageHeader only on first page
Hi, I am using ireport4 .0.2.I want Page Header only on first page..... Can someone help me on how can i display page header only at first page.
Reprint page Header and Footer on each page with report Summary band
By default, if report Summary stretches onto multiple pages, the Page Header and Page Footer bands will only get printed on the first page of the Summary. You can change this behavior with one of the approaches below. For reports created in TIBCO Jaspersoft® Studio In Jaspersoft® Studio this can be achieved by simply checking the "Summary With Page Header and Footer" option in report ...
Jasper Reports subreport on a new page
I solved it by add page break at the start of the sub report in the top side, no use "Print when expression" or anything else. Report formation: Master Report -> 1st page -> 2nd page -> Sub report -> (add page break on top) title+ 2 sub report -> master report end page
ireport
The page header/column header get repeat for each page. These page header/column header are from the sub reports. This is fine for PDF but in case of excel, i want to get rid of the repeating header. ... Jasper Report Column Layout. 3. display column header in jasper reports. 1. Jasper Reports: Page Number inside subreport does not work. 2.
Report Sections
This section appears only once at the beginning of the report. 2: Page Header. ... To demonstrate each section, let's write report template (jasper_report_template.jrxml). Save this file to C:\tools\jasperreports-5.0.1\test directory. In this file, we would be displaying a text in each of the sections (we discussed above).
Page Header Band Understanding Page Header in JasperSoft ...
- Java Swings consultants and developers - Jaspersoft Studio Reports consultants and developersPing me on Skype ID : [email protected] Header Band U...
Page headers and footers in a paginated report (Report Builder)
Report Headers and Footers. Page headers and footers are not the same as report headers and footers. Reports do not have a special report header or report footer area. A report header consists of the report items that are placed at the top of the report body on the report design surface. They appear only once as the first content in the report.
JasperReports Tutorial: What is Jasper report for Java? Example
Important Reports bands are: 1)Title 2) Page header 3) Column header 4) Detail 5) Column footer 6) Page footer and, 7) Summary. The biggest challenge of using Jasper Reports is that you need to change the core logic of the report if the business logic change.
jasper-reports Tutorial => Understanding the different report bands
Column Footer. This appears below the detail band on each page where detail band is present. The default setting is end of page (before Page footer) but this can be switch to under last detail band (last record) by setting the attribute isFloatColumnFooter="true".
Custom Jaspersoft Studio Report: How to avoid having repeated headers
We are running a custom Data dump / extract report with many records in immediate mode in Advanced Reporting. We cannot run it from Reports and jobs as when we do, we have issue with repeated headers on each page in Excel. The results are imported into another system so we cannot have this duplicate headers. Please advise.