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.
Solved
How to highlight alternate rows in the detail section of a report designer report e.g. a quote or invoice
Best answer by lauraj46
Hi
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
Hope this helps!
Laura
+8Hi
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
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Thank you - let me test this and see where I get to.
I will come back and let you know if it works.
1 person likes this
+10Instead 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
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.