on 04-08-2009 4:30 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reena
Try using if...else rather than Case.
Hope this helps!!
Regards
Sourashree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.