I have a report that when the user drills down I need to change the formatting to include borders and/or colours. I tried adding the following statement to top border of the element without luck. Since I don't know when the detail is the last line of the drop down, I am uncertain how to try adding it there.
I do not want the underline to show when there is no expanded drill down.
=iif((Previous(Level) > 0, "Dotted", "None")
g1 name1 total1
g1 name2 total2
d po#3a total3a
d po#3b total3b <<-- want to add underline between total3b and total3
g1 name3 total3
Thank you
Just a quick stab...but couldn't you include the "underline" as a border on the top of your "g1 name total3" line as opposed to on the bottom of the last subtotal? That way it looks like it's rendering on the lowest one, but in reality it's not.
|||I'm sorry I wasn't clear enough. I need the correct statement to go on the border style TOP of the g1 entry so that it will only show when there is a drill down.
I have tried "=iff((previous(level)) > 0), "Dotted", "None")" however it did not work. Along with variations on a theme.
No comments:
Post a Comment