BC30201 Error SSRS

Question

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!

You need double quotes around the date. – SS_DBA Jan 11 '17 at 13:57 — SS_DBA, Jan 11 '17 at 13:57

score 3 · Accepted Answer · answered Jan 11 '17 at 13:58

3

Put double quotes around the date.

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

answered Jan 11 '17 at 13:58

SS_DBA

1 Answers1