October 18, 2016 at 3:45 pm
Good Afternoon Guys,
Would it be possible to have a report with a Parameter that can control if you could have a gridline in your report body? Can this be done by passing a parameter and have a property/value changed to have this effect on a report.
Best Regards,
Noel
October 19, 2016 at 2:23 am
I assume you mean by gridlines the borders on your table? You can do this using an expression on your cells.
This is using the assumption that all your cells have the same border width throughout, if not, you will need to do each group[ of cells separately. Select the cells you want, and then hit F4, to display the properties pane. Locate the border section, and then BorderWidth. If you're doing the whole lot, Select the Default width and click the down arrow to bring up the expression menu. Assuming you have a parameter named "Borders" of type Boolean, enter the following:
=iif(Parameters!Borders.Value = TRUE, "1pt", "0pt")
If you are using a different default size, replace 1pt with the correct one.
if you have a range of different border types, you will need to do this in the left, right, bottom, top sections, for each similar group (depending on your report size, this may take a little while).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 19, 2016 at 12:02 pm
Worked like a charm!!
Much Thanks!
Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply