In SQL Server Reporting Services, I have a column "Status" in my report. Somewhere in the footer of the report, I would like to Count how many "New" jobs are there.
In the Status column, the possible values are (New, Cancelled, Rescheduled).
Somewhere in the footer I want to see:
Is there a way to do this with the help of "Expressions"?