Saturday, November 24, 2012 10:22 PMI 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.
Saturday, November 24, 2012 11:55 PMAnswerer
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
- Proposed As Answer by Syed Qazafi AnjumMicrosoft Community Contributor, Moderator Sunday, November 25, 2012 11:15 PM
Thursday, November 29, 2012 8:21 PM
I apologize for my delay - been out of the office.
I selected Row Visibility, then selected Show or Hide by Expression, then pasted the expression. (I corrected the field name to SessionEnd - which was my error).
I received the following error when I ran the report:
The definition of the report 'Main Report' is invalid.
The Visibility.Hidden expression for the tablix 'Tablix4' contain an error: [BC30455] Argument not specified for parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
Thanks for your help!
Thursday, November 29, 2012 8:36 PM
I would bet the problem is in the 'FalsePart' expression!
Could you paste what you typed exactly in the visibility expression?
Maybe you have written FLASE or something like that!
edit :IIf(Expression As Boolean, TruePart As Object --> , <-- FalsePart As Object)
Just saw it ways you have not specified a false part. Maybe you forgot a , ...
- Edited by Alex Jean Thursday, November 29, 2012 8:39 PM
Friday, November 30, 2012 7:28 PM
My expression is:
=IIF(Fields!SessionEnd.Value IS NOTHING OR Fields!SessionEnd.Value = ""),TRUE,FALSE)
Which yields this error:
The Visibility.Hidden expression for the tablix ‘Tablix6’ contains an error: [BC30455] Argument not specified for parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
- Edited by tfink717 Friday, November 30, 2012 7:29 PM
Monday, December 03, 2012 1:20 AMModerator
Please try the expression below:
=IIF((Fields!SessionEnd.Value IS NOTHING OR Fields!SessionEnd.Value = ""),TRUE,FALSE)
Hope this helps.
TechNet Community Support
Tuesday, December 11, 2012 8:33 PMThank you for your help!