Got a real puzzler on this one - realativly new to CR and BO, but the following is throwing off an error and I can't track what I did wrong:
Dim OrgLevel As String
If Not IsNull({ORG_REPORT.LEVEL7_DESCRIPTION}) Then
OrgLevel = “LEVEL7”
Else
OrgLevel = “ORG Level”
formula = OrgLevel
End If
I get the :
FORMULA CHECKING ERROR
"A Number, currency amount, boolean, date, time, date-time, or string is expectedhere"
Also is there a way to get different varibles back from 1 formula
ie
Dim OrgLevel As String
Dim OrgNameAs String
If Not IsNull({ORG_REPORT.LEVEL7_DESCRIPTION}) Then
OrgLevel = “LEVEL7”
OrgName= "Level 7"
Else
OrgLevel = “ORG Level”
OrgName= "Org" <These are what I want to display
formula = ???WHAT????
End If <If I sent formula = to something - Thats all I get and I want these as
seperate values so OrgLevel &" "
&OrgName won't do it
Thanks for any help
Rich