Error:[BC30201] Expression expected RSS

• • Reply
  

  karthik_newb...

  Member

  93 Points

  70 Posts

  Error:[BC30201] Expression expected

  Feb 07, 2012 07:56 PM|LINK

  Hi,

  I am trying to set the filter for the report.

  Here is my expression : [Cause_Code_1]

  Operator: In

  Value: "=iif(Parameters!Cause_Code.Value is NOTHING, CStr(Fields!CAUSE_CODE_1.Value), Split(Parameters!Cause_Code.Value, "","" ) )"

  When i click on OK buton, i am getting the following error:

  <Value>

  The value ') )"' contains an unexpected quotation mark(").

   

  And if i am using the following:

  Value: ="iif(Parameters!Cause_Code.Value is NOTHING, CStr(Fields!CAUSE_CODE_1.Value), Split(Parameters!Cause_Code.Value, "," ) )"

  I am getting the following error on preview of report:

  The filterValue expression for the tablix contains an error:[BC30201] Expression expected.

   

  Can anyone tell me the exact syntax of the value?

  Thanks!!

• • Reply
  

  jeeveshfulor...

  Participant

  1552 Points

  287 Posts

  Re: Error:[BC30201] Expression expected

  Feb 14, 2012 06:10 AM|LINK

  try with this expression:-

  syntax is:-=IIf(IsNothing([Your expression here]), [value if it is nothing], [value if it is something])

  =IIF(IsNothing(Parameters!Cause_Code.Value),CStr(Fields!CAUSE_CODE_1.Value), Split(Parameters!Cause_Code.Value,","))

  • Edited by jeeveshfuloria08 on Feb 14, 2012 06:10 AM
  • Marked as answer by karthik_newbie on Feb 14, 2012 01:10 PM