BC30201 Error SSRS

2
votes

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!

1
sql-serverreporting-servicesssrs-2008ssrs-tablix
You need double quotes around the date. – SS_DBA

1 Answers

1
votes

Put double quotes around the date.

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