So it seems that you are indeed missing your input fields in the where
You should have something like
ROW_DATE = [Dates:] and Split = [Splits:] and ACD=$acd GROUP BY ROW_DATE, CALLSOFFERED, ABNCALLS10, SPLIT
Where [Dates:] and [Splits:] are your input fields. You can find your input fields via Edit - Inputs - Prompt column
I suggest that you take a copy of an existing report and check the where clause. You will see the references to the input fields.
|