We are using SSRS 2005 and Sql Server 2005. I have a requirement to do drilldown report with +/-. I need to do group by CID.
This is how my data looks
CID TID fund position amount
1 11 xx high 700
1 12 yy Low 500
2 13 zz Med 600
14 zz high 800
So, TID is unique and I have to group by CID. Some rows will not have CID. What I have to do is, When I group by CID and enable +/-, all my empty CID rows are coming under + sign with out CID.
My requirements are:
If CID is there and there are more that 1 row for that CID, enable +/-. IF CID exists and only 1 row for that CID, do not give +/- If there is no CID, show all those transactions as independent individual transactions with out +/- sign.
When I group by CID, I need to show total amount also in group header.
I appreciate your response, if some one can help me in figuring out this.
View Complete Post