I have a SSRS report that has several columns. Some of those columns may contain NULL data for the row some may have data in this column or that column. I want to hide all rows that have NULL data in across 5 or 6 columns of the 10 columns I am selecting. If one of the columns have data in it, I want that row to show. I try the hidden property in details on the column, but if the column was NULL it made the whole roll disappear. How do I change the report to hide the row if all columns are NULL.
I tried to do this in the query, but the query is very doing a lot of convulted joins and when I put in the is NOT NULL for each column, it eliminates all rows even when it shouldn't so I am trying to handle this on the reporting side.