Report Builder Expressions Help
I am about as much of a newbie as possible. I've been working with Report Builder 3.0 for a week now. We have a piece of software built on SQL 2008R2. I want to build a custom report that will auto-populate from certain tables. The problem: I want the report to list data from only the active session. The only way I see to differentiate between sessions is that in the SessionActivity dataset, the "SessionEnded" will be blank. My thought was an expression either to hide all rows not null in that column or show only rows that are null in that column. I've been unable to successfully stumble through on my own. Any help would be greatly appreciated.
November 24th, 2012 5:22pm

Hi tfink ! You need to set the following expression in Row Visibility option; =IIF(Fields!SessionEnded.Value IS NOTHING OR Fields!SessionEnded.Value = ""),TRUE,FALSE) Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham Niaz
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2012 6:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics