Solved

How to highlight alternate rows in the detail section of a report designer report e.g. a quote or invoice

  • 18 July 2023
  • 6 replies
  • 152 views

Userlevel 1

I am creating a quote form for a customer who has quotes / sales order and invoices with many line items.  They have requested that alternate rows on the detail section are highlighted in order for the customer to be able to read these better.

icon

Best answer by lauraj46 18 July 2023, 20:02

View original

6 replies

Userlevel 7
Badge +7

Hi @carolinehern40 ,

You can accomplish this be creating two similar sections and then using a visibility expression to hide one or the other based on the line number.

See this explanation by @Neil Cantral :

Hope this helps!

Laura

Userlevel 1

Thank you - let me test this and see where I get to.

I will come back and let you know if it works.

Userlevel 1

Thank you all so much - you have given me so much to work with.  

Userlevel 7
Badge +9

Instead of duplicating the row, you can also use a simple math to differentiate odd and even rows and style either one with whatever color you want.

You can use something like Mod function that gives the balance by dividing to two and checking if balance is zero for Line Number or if Mod doesn’t exist in the functions use something like

(Round(Line Number / 2, 0) * 2) = Line Number

if true then even if false then odd

Userlevel 1

I like this - I will test and come back to you.

Userlevel 7
Badge

Hi @carolinehern40 were you able to find a solution? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved