Link to home
Start Free TrialLog in
Avatar of William
William

asked on

SSRS Column Status

Hello, was wondering if a new column is created in a tablix to give status of other column groups in case a row in any of the column groups gets blank. Am trying to put in an expression in that column created but it always gives me a null or error sometimes. any idea whats the best way to handle this. What i would like for the column to report is if other column groups have an empty field then write "missing information" on the created column for that row.
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

>Am trying to put in an expression in that column created but it always gives me a null or error sometimes.
Then either your expression is incorrect or it uses columns that are also null.   Show us a screenshot of your tablix, copy-paste the expression and the error message.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.