January 11, 2022 at 3:42 pm
I have several columns in a row. I am not able to modify the query to eliminate NULL data. How do i eliminate data where only certain columns are NULL. If any of those columns I want to filter on have data, then I want the column to be show the data (even if some of the other columns have NULL for that row). I only want to hide the row where there is NULL for specified columns.
I tried to use this for the "hidden" property of the 1 column, but it hid the entire row which is not what I was looking for.
HIdden Propery on Column in tablix.
IIf(IsNothing(Field!column.value), True, False)
CAn someone advise me on this, please.
Thank you!
January 12, 2022 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 13, 2022 at 3:19 pm
I am not 100% sure on what you are trying to do, but I have a guess. I think what you are going to want to do is for that hidden property to be on a row, not a column and it should be along the lines of:
IIf(IsNothing(Field!columnA.value),IIf(IsNothing(Field!columnB.value),IIF(IsNothing(Field!columnC.value),True,False),False),False)
Basically, needs all 3 columns to be nothing (empty or null) for the row to be hidden.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply