Skip to main content
Solved

Exported Excel reports with repeating Headers

  • 12 February 2024
  • 6 replies
  • 217 views

When you export reports from Acumatica to excel, the headers of the report are repeated at every screen break.  How do you stop these headers from repeating in excel?  There are no page breaks in the column sets or row sets.  This is something that annoys many clients, as they have to manually remove the headers from the excel file every time they export a report.

Best answer by Laura02

Hello,

It is possible to suppress headings on subsequent pages with an Iif statement, as outlined by Irina from Acumatica in the following Post:

https://community.acumatica.com/analytical-reports-238/how-to-print-header-in-arm-reports-only-on-the-first-page-293

If you want headers to print on every page *when printed to paper* and not print on every page when exported to Excel:

  1. Copy the Column Sets,
  2. Copy the Report Definitions, using different Column Set for Paper versus Excel, and
  3. Arrange the menu with two groups of financials: For Paper versus For Excel.

Laura

View original
Did this topic help you find an answer to your question?

6 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • February 12, 2024

Hello,

It is possible to suppress headings on subsequent pages with an Iif statement, as outlined by Irina from Acumatica in the following Post:

https://community.acumatica.com/analytical-reports-238/how-to-print-header-in-arm-reports-only-on-the-first-page-293

If you want headers to print on every page *when printed to paper* and not print on every page when exported to Excel:

  1. Copy the Column Sets,
  2. Copy the Report Definitions, using different Column Set for Paper versus Excel, and
  3. Arrange the menu with two groups of financials: For Paper versus For Excel.

Laura


  • Author
  • Freshman I
  • 4 replies
  • February 12, 2024

Thank you for the response.  That solution gets most of the result that is desired, however, the spacing and underline in the heading still translates over to the exported excel file.  Additionally, this client has over 30 financial reports, so creating Paper vs Excel versions is going to be very cumbersome and clumsy.  Is there a better solution? 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 13, 2024

Hello,

Yes, you might consider Velixo as another solution for Financial Reporting.

Especially if your client has many companies, intercompany reporting, GL budgets, projects reporting… it’s a very powerful reporting tool. Search this site and use your favorite search engine.

Laura


  • Freshman I
  • 10 replies
  • August 15, 2024

What specific role do I need to access the area where that link takes me to? I click on it and get this error message…

 

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • August 15, 2024

Some posts can only be seen by Partners. Here are the steps.

Step-by-step guide

 

There is no built-in formula to set visibility of a certain ARM report element based on the page index. To achieve this, you should utilize an IIF formula with the PageIndex global variable. To update the report, follow the steps below.

Step 1: On the Column Set (CS2060P2) form, open column set corresponding to the report you want to update (for example, Balance Sheet report).

Step 2: For a column header, specify header using an IIF formula with the PageIndex global variable:

=IIF( [PageIndex]=1, 'your header field', ' ' )

Step 3: Save changes.

 

Results

 

For the Balance Sheet report, the header is printed only on the first page.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2679 replies
  • August 15, 2024

Hi @cgndm - For some reason your portal account was not attached to your customer business account even though you used your company domain email address. I have fixed that and you should now have access. You may need to refresh your screen. Cheers!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings