Adding horizontal and/or vertical lines to a report in FRx will often make a good report just that much better.
Not to mention more legible for your audience. Can be very impressive and it’s really pretty easy. Here’s how.
Horizontal Lines
This will give you a solid line running across the page. In the row format, in column C Format Code, select LNE from the dropdown. In column D Related Rows, add one of these TYPE codes:
- TYPE=1 produces a thin line
- TYPE=2 produces a thick line
- TYPE=3 produces a dotted line (don’t use this one unless you’re really desperate)
- TYPE=4 produces a thick line followed by a thin line
- TYPE=5 produces a thin line followed by a thick line
My favorites are Types 2, 4 & 5. The last two look really good for Board presentations.
Vertical Lines
There are a couple of different ways to get vertical lines on a report, but my favorite way is in the column layout. Insert a column with a Type of FILL, set the column width to 1, then apply a font style that has shading enabled. You can adjust the shading lighter/darker as needed by editing the font style. It’s just that easy.
Enjoy!
Thanks for all of the great tips on this site. I’ve been using lines on alot of my reports for awhile now, however, I’ve never been able to figure out how to suppress horizontal lines in the first column. This columns is typically a description column so the lines are not necessary in this column. Is there a known way to show horizontal lines in all columns except for the first? I’ve even tried suppressing formats for this column (in the column fomr, and restricting columns on the rows with lines in the row format “Column” column, but nothing seems to work. Any help would be greatly appreciated.
Thanks.
Hi Brian,
Assuming your Column had A=Description, B=YTD, C=Month:
In Column G of the row format where you have the hortizontal line, you can put ‘B TO C’ and this will start the line in column B.
Sincerely,
Les