My report is grouped by CATEGORY column. In my table there are some blanks in CATEGORY column.
So in my report all blank rows grouped as one and displayed in report. But I want show only in which CATEGORY column has value /not blank.
My report is grouped by CATEGORY column. In my table there are some blanks in CATEGORY column.
So in my report all blank rows grouped as one and displayed in report. But I want show only in which CATEGORY column has value /not blank.
bind the report to a query and use the expression "Is Not Null" as the criteria for the Category column
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick