cancel
Showing results for 
Search instead for 
Did you mean: 

How do I suppress detail records for a group based on a WPR field in the footer?

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

abhilash_kumar
Active Contributor
0 Kudos

Oops. You're right; I just got a little carried away!

Subreport it is then. Good luck.

-Abhilash

Former Member
0 Kudos

Thank you.  For the subreport workaround, do I need to be passing the variables from the main report to the subreport and performing the group selection within the subreport or the other way around? 

abhilash_kumar
Active Contributor
0 Kudos

Yes, variables need to be passed from the Main Report into the Subreport. The Subreport is where the Group Selection needs to be done.

-Abhilash

Answers (0)