August 21, 2009 at 9:02 am
HI,
I want to avoid showing the column name of the column which is not having any value.
For ex,
EmpId Name Phone
1SachinNULL
2VinodNULL
3AzarNULL
4SauravNULL
In my SSRS table type report I'm getting the Phone column name and no value. I do not want to show this(Phone) column if it is not having any value.
Let me know how to do this.
August 21, 2009 at 3:15 pm
Why don't you simply filter the NULL values from your dataset? I guess we need to know how your dataset is populated. SQL Query or a Stored Procedure?:cool:
August 21, 2009 at 3:22 pm
OK, If the example you showed was the report, abe the word "NULL" is visible on the report. In this case, you can use a change it based on a condition. like this:
=iif(Fields!Phone.Value = "NULL","",Fields!Phone.Value)
Something like this in the detail cell that prints the phone number would print a blank.
Is that what you wanted?
August 24, 2009 at 2:32 pm
Select the complete column and go to the hidden property in properties tab. Set the Hidden property to true.
August 25, 2009 at 10:25 pm
Basically i do not want to show a column which is having null value. In my example i don't want to show the 'Phone' column (not even the name of the column) if it is having all null values.
August 26, 2009 at 1:12 am
You can set the hidden property of the Phone TableColum (select the entire column, not just the header or detail cell) to an expression:
=IIf(CountDistinct(Fields!Phone.Value) = 0, True, False)
Peter
August 26, 2009 at 9:20 am
Hey Thank you very much it worked 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply