By using this website, you agree to our Terms of Use (click here)
Hi, does anyone know a way to add vertical borders to ARM reports. Horizontal ones are covered in the F350 manual but I want to display three groups of three columns each and want to distinguish each group in some way. I can't see a way to add a vertical border after each group of three. I tried selecting shading on the Style row but it gives me blocks (i.e. it only shades where there are figures, not where I have blank lines between e.g. subtotal and total. There doesn't seem to be an option in the row set. Help greatly appreciated.
Shaded columns is the only way that I can think of as well. Seems though like your rows with a Type of Caption are the only ones with problems.
What if you change the Type from Caption to Total for all of those rows? Does that solve the problem?
Thanks so much for this - worked a treat. Your solution was spot on but in addition: in the row set under the style column, I had to set the colour as well, but only for those rows that didn't have any data in the description column (so first blank row under the line, colour is set, second row that has Month to date is not set, the third row is set, then remaining rows to Net Revenue is picked up from the format in the column set etc).
I've got one more query (can open a new post if you like). I have the text MONTH TO DATE and YEAR TO DATE (top of pages 1 & 2), is it possible to put in a formula to in show the actual month on page 1 and the start and end period on page 2? I've been messing around with this but it doesn't look like this is possible in the row set. I also can't think how to add this to the column set so it's different on pages 1 and 2 (one shows figs for the month, in this case July 2016 and the second page is our full year, Aug 15 to Jul 16).
ARm-Reports-Launcher-2018-10-27.pdf
Have you tried something like this?
https://www.augforums.com/augforums/acumatica-analytical-report-manager-financial-report-writer/formula-to-print-month-description/
Haven't tried it in a Row Set, but can't think of reason why it wouldn't work.
Thanks for this - I did take a look at this thread earlier but I can't figure out which column in the row set it would go in. The only column that will accept a formula is the Value column but I would think this field is for the main column of numbers, ie this isn't a description field. It's also throwing up an error if I leave the description field blank. Maybe needs to be in col set after all?
Not pretty, but you could do something like this where you define two hidden columns, then a third column that decides which column to print.
Online Members
