only want records where running total in subreport

[bobalou]

i have the following formula in a subreport that sets a variable to the running total of one column.


whileprintingrecords;
shared currencyvar payable_total :={#RTotal0} ;

i want the main report to only show results where the running total exceeds a certain value (in this case 750000). i have not had any luck. i have tried using just a selection formula in the but using a running total does not appear to be an option in the selection formula as they do not show up on the list of available fields. there are no groups in the subreport either.

suggestions are greatly appreciated.

 

[synapsevampire]

You have options, but that depends on what the Running Total is doing and how you're displaying the result, which you didn't share.

Probably the simplest given what you've shared is to right click the section or formula and add in a suppression formula which states:

whileprintingrecords;
shared currencyvar payable_total;
shared currencyvar payable_total > 750000