So - I am working on a Report Builder 3.0 report and have run into a snag trying to get a conditional expression on one of my report columns. Essentially, I want the Start Date Column's row value to populate with the Start Date ONLY IF the Action Field meets a certain criteria, else, leave the Start Date Blank. I'm not a SQL jock and have tried all the options in the help files for RB 3.0. Need some expertise. The error I keep getting is this:
The Value expression for the textrun ‘START_DATE.Paragraphs.
]’ contains an error: [BC30451] Name 'CCSP' is not declared.
The expression itself is written as:
=IIf(Fields!ACTION.Value = CCSP Referral, "Fields!START_DATE.Value",
I'm not married to this expression; I just haven't mastered anything more complex.
I'm attaching a screen shot in hopes that will help to visualize what I want to do. Assistance as always most appreciated!