• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Tabular Section & Total Comparison

ssolberg

VIP Member
I can't seem to figure out how (or if) I can do this with a Tabular Section on a report. The report itself is quite simple, just doing a tabular report to show amount vouchered (gross amount) for a vendor within a date range. Everything works just fine and now I want to compare the $ amount that I am getting (via the automatic totalling that occurs with a tabular at the level break) to a processing option so that I can "print just those vendors with a $ amount greater than X". I can't use Data selection because that is going against each detail line as it is gathering the total and Event Rules on the tabular section DO allow me to "do things" (like populate a text variable) based on the total value but I can't seem figure out how to compare this value to the processing option so it doesn't print the line if it is "less than" the processing option. (it seems really simple!). I realize that I can probably do this with a Columnar Report and use Level Breaks and event rules on them to accomplish but it would make the report a bit more complex. Am I missing something?

OW XE (Coexistant)
 
Top