Dynamic column header name best on data
Hello All,
I have a report to display as below
Product
Active
(Active=3,Inactive=1, All=1, Total=4)
ABC
Yes
XYZ
No
KLM
Yes
All
Yes
Currently I am able to display header as Product but i need to display as above. How can I do it. Any help is highly appreciated.
Thanks.
December 17th, 2011 3:09pm
Hi,
Add below expression to Group Header, if you do not have group, create it on product
="(Active=" + SUM(IIF(Fields!ActiveField.Value = "YES" AND Fields!Product.Value <> "All",1,0)).ToString() +
", Inactive=" + SUM(IIF(Fields!ActiveField.Value = "No" AND Fields!Product.Value <> "All",1,0)).ToString() +
", All=" + SUM(IIF(Fields!ActiveField.Value = "All",1,0)).ToString() +
", Total=" + COUNT(Fields!ActiveField.Value).ToString() + ")"
Regards,
Asim Bagwan
Kindly mark the replies as Answers if they help!
Free Windows Admin Tool Kit Click here and download it now
December 18th, 2011 5:27am