Hi,
I am using pivot for cross tab results in which i need to generate the report.Am using the Count aggregate function in the Pivot query.So if the Count is greater than 0 then i need to print as 'Yes' otherwise 'No'.
Can anyone please help me how to use case statement over aggregate function in Pivot
Thanks in advance
Shameer Khan
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)