Drop the "@Suppression _Sum" into your details line. (This is also a good check to make sure it is putting in a 1 or 0 when it should based on your parameter selection, e.g. selected Parameter={order_.actText} on that row then a 1 appears otherwise a 0).
Click on the Suppression_Sum field to activate it. Click on the Insert Summary option. The "X-1 Suppression_Sum" field should already be selected.
Change the Calculate this Summary to "SUM".
Under Summary Location choose Goup 2 and select OK.
Now in your report you should have a sum of the Suppresion_Sum field for each group. Now if there was any row in that group that had the the selected parameter the sum is >0 meaning you want to suppress that group header.
If you want to suppress the entire group1 line then click on the Secion Expert and select the group header 1 line.
Click on the X-2 formula button next to Suppress (no Drill down).
Under your report fields you should have a Sum group field option. Double click it to get it into your formula. it should be something like
Jst add the ">0" to the end to complete the suppression criteria.
You can delete the @Suppression _Sum from your details record. It does not have to be in the report for it to sum. You can also suppress the group footer 2 with the sum if you don't want it to appear.
Hope this helps.
IP Logged
