Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Report Builder Expressions Help

Traitée Report Builder Expressions Help

  • Saturday, November 24, 2012 10:22 PM
     
     
    Sign In to Vote
    0
    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.
     

All Replies

  • Saturday, November 24, 2012 11:55 PM
    Answerer
     
     Proposed Has Code
    Sign In to Vote
    0

    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

     
  • Thursday, November 29, 2012 8:21 PM
     
     
    Sign In to Vote
    0

    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
     
     
    Sign In to Vote
    1

    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 :
    Just saw it ways you have not specified a false part. Maybe you forgot a , ...

    IIf(Expression As Boolean, TruePart As Object --> , <-- FalsePart As Object)

    • Edited by Alex Jean Thursday, November 29, 2012 8:39 PM
    •  
     
  • Friday, November 30, 2012 7:28 PM
     
     
    Sign In to Vote
    0

    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 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi Tfink,

    Please try the expression below:
    =IIF((Fields!SessionEnd.Value IS NOTHING OR Fields!SessionEnd.Value = ""),TRUE,FALSE)

    Hope this helps.

    Regards,

    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Tuesday, December 11, 2012 8:33 PM
     
     
    Sign In to Vote
    0
    Thank you for your help!