I have table Posting with the following details.
id (int)
Wing (varchar)
Status (bit)
The table has the following values
id wing Status
1 al 0
2 al 0
3 al 1
4 db 0
5 db 1
6 db 0
7 db 1
The result should be displayed as under
Wing filled vacant
al 1 2
db 2 2
What code should I use in reports to display the desired results.