Filtering a sub-total

rbuser

I have an unusual requirement to filter a sub-total. The overall
query includes the field TransType which can have the values of
H and P. The report GROUPS on another field and the sub-total
cannot include records with a TransType of 'H'; only TransType of
'P'.

The grand total includes all records.

Not sure how to approach this!

Thank you...

Todd

nicocizik

Hi Todd,

If you are calculating the subtotals in the group footer, you can try making
the calculation manually using a TppVariable component rather than the
DBCalc. Inside the OnCalc event of the variable, place the logic to check
the TransType and only increase the total value for type P. The DBCalc can
remain at the end of the report.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com