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
Hi Reena
Try using if...else rather than Case.
Hope this helps!!
Regards
Sourashree
That didnt help either.
It doesn't appear that you're defining the FormulaName variable before you use it -- might that be the problem?
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.
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