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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics