Search code examples
sql-serverreporting-servicesssrs-2008ssrs-tablix

BC30201 Error SSRS

Good morning,

Using SSRS, I am getting the following error:

The Value expression for the textrun ‘Textbox63.Paragraphs[0].TextRuns[0]’ contains an error: [BC30201] Expression expected."

I am using this expression in the 

Textbox: 
=iif(Fields!jhapostingdate.Value>'06/30/2016',(Sum(Fields!CurrentBalance.Value)-117722085)/25000000," ")

I'm confused as I believe that the expression is setup correctly.

Any input is highly appreciated!

Solution

  • Put double quotes around the date.

    =iif(Fields!jhapostingdate.Value>"06/30/2016",(Sum(Fields!CurrentBalance.Value)-117722085)/25000000," ")