Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Expression for sert visabilty for row of table not always working,

Answered Expression for sert visabilty for row of table not always working,

  • Monday, February 27, 2012 10:48 PM
     
     
    Sign In to Vote
    0

    Hi,

    I want to be able to write a function that will return ether a true or false for a row to be displayed,

    It seems like if I try to use a item in my data base it works, if it is a number. Text will not work

    example

    this expression works

    =2>Fields!id.Value

    and

    =2>Fields!company.Value

    but

    ="ALEX"=Fields!id.Name]

    does not work, non of the rows are hidden,

    why??????


    • Edited by Ted Pottel Monday, February 27, 2012 10:59 PM
    •  
     

All Replies

  • Monday, February 27, 2012 11:02 PM
     
     Answered
    Sign In to Vote
    0

      =2>Fields!company.Value

    Confirm Company.Value is an integer, if not, report will fail

     

    ="ALEX"=Fields!id.Name]

    For the above you are comparing the Field ID's Name (likely 'ID')?  Or are you after Fields!Name.Value="ALEX"  (']' definately does not appear to belong there.

    Best Wishes, The Redman; If something helps, please help show it by voting, if it solves, bonus!

    • Marked As Answer by Ted Pottel Tuesday, February 28, 2012 1:14 PM
    •