I have a parameter on my report that allows the user to see 1) orders that have invoiced in the current month and any open orders OR 2) just open orders. The issue is when option 2 is selected - the group headers are still showing for the sections where invoiced orders are being suppressed and there are no open orders. So I just have a bunch of random headers with no data underneath. Is there a way to conditionally suppress these if the group section is blank based on the parameter?

Thank you. I created the formula and it is returning the value of 1 or 0 properly, however when I got to sum that formula - the option to Insert Summary is not on the RMC menu. So I tried creating a separate formula that I could place in the group footer and it will not let me sum the formula field through that either because "1" or "0" are not numerical values. I then tried a count and that did not work either. Am I missing something on how to Sum this field?

if{?Order Status}="1" then "1"else "0"

{?Order Status} is the parameter field I set up - if 1 is selected on the parameter it shows only orders that are open. 2 returns orders that are open AND orders that have been invoiced in the current month.

I'm having the header issue only with the selection of parameter "1" and it's showing all the headers for all the groups of orders that do not have currently have an open. Hopefully that makes sense.