Hiding data on each row.
Hi
In my SSRS report, I need to hide duplicate data in each row except the first row.
there are some fields i should show and some fields i should hide in the duplicate row depending on the condtion.
Thank you.
October 21st, 2010 1:15pm
There should certainly be a "Hide Duplicates" Property for the textbox to which you want to hide duplicates , select the property and give the field name to avoid duplications in your report
Thanks .Rajkumar Yelugu
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 1:52pm
Thank you
I solved the prob using below formula
=iif(Previous(Fields!ID_Number.Value) = Fields!ID_Number.Value,true, false)
I have set this for visibility of all the textboxes i want to hide.
This will only work, if the report is sorted on ID_Number.
October 21st, 2010 2:46pm