on 08-23-2013 7:03 PM
I need to suppress the detail records for an entire group based on the outcome of a formula, which is based on a WhilePrintingRecords formula result and is located in the group footer. I can provide more details if needed.
Basically, I have a field for Employee Deduction, where I have suppressed some records. (The report was listing the deduction for each dependent record when I needed it to only list each deduction once per benefit plan). Anyway, I am then using WPR to calculate total deduction amount (not including the suppressed records) for each employee. Next I am taking Employer Total Cost for the employee -MINUS Employee Total Deduction to get a calculated field for Taxable Benefit. I need to suppress an entire group (detail records and all) based on this Taxable Benefit value. If it is 0 or less for the Employee (group), I don't want that employee or any of their records on the report. Is it possible to do this??
Thanks.
Hi Lauren,
You can't use a print-time formula in a Group Selection formula.
The workaround is to add the original report as a Subreport and using arrays/string formulas pass it into the subreport where you can then use the values in the Group Selection formula.
A better workaround is to use a conditional suppression formula for the Group Header, details and Group Footer.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, I am aware you cannot use a print-time formula in a Group Selection formula, which is why I am looking for a workaround. I cannot use a conditional suppression formula for the details, as the only condition is set by the result that is in the group footer. I cannot find a way to reference this group field at the detail level. I will attempt the Subreport work around and see if I can get that to work for me.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.