Skip to main content
Solved

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

  • July 18, 2023
  • 6 replies
  • 492 views
  • Translate All

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.

Best answer by lauraj46

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

View original

6 replies

lauraj46
Captain II
Forum|alt.badge.img+9
  • Captain II
  • Answer
  • July 18, 2023

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

Translate

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

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

Translate

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

Translate

aaghaei
Captain II
Forum|alt.badge.img+11
  • Captain II
  • July 25, 2023

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

Translate

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

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • August 22, 2023

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

Translate