cancel
Showing results for 
Search instead for 
Did you mean: 

"A statement is expected here" error with formula

Former Member
0 Kudos

Hi,

I am getting "A statement is expected here" error in one of my report with a formula field. When I delete that formula from my report it works fine.

This is how I pass the value to assign it to the formula

Dim crFFDef As FormulaFieldDefinition

For liI = 1 To .FormulaFields.count

Set crFFDef = .FormulaFields(liI)

FormulaName = crFFDef.Name

Select Case LCase(FormulaName)

Case "{@pcopy}"

crFFDef.Text = " "

Case Else

End Select

Next

Here @pcopy is my formula.

This is not hapening on all the machine that has this report on it, only 2 out of the 5 have this problem.

Can someone pinpoint what is the problem with it.

Thanks,

Reena

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Verify it works in the designer first then if it's still an issue in code post your question to the Legacy Application Development SDKs Forum or purchase a case and have a dedicated support engineer work with you directly

Former Member
0 Kudos

Hi Reena

Try using if...else rather than Case.

Hope this helps!!

Regards

Sourashree

Former Member
0 Kudos

That didnt help either.

Former Member
0 Kudos

It doesn't appear that you're defining the FormulaName variable before you use it -- might that be the problem?

Former Member
0 Kudos

The formula value is left blank in the report itself.

But I set it in the application (front end) depending on some condition. You can see the way I set it in, check the first post I have put that information in it.

Thanks.