How get multiple properties to one column in report Definition.
I have a report definition in that report definition I have two columns name Total Number and Availability.
In the Availability column the Availability should display using ispaid and isnotpaid Boolean properties (ispaid and ispaid are both Boolean data types). So, in the Availability column I want to display the availability.
And in the Total Number column I want to display the TRUE count for those columns. How can I achieve this like in the bellow table?.
Item | Availability | Total Number |
---|---|---|
i-1 | Paid | 3 |
i-1 | Not Paid | 4 |
i-2 | Paid | 5 |
i-2 | Not Paid | 6 |