on 03-28-2024 5:15 PM
I'm trying to get a group heading in crystal reports to show a different text to the one being returned is using the following formula but it just say error Boolean expected :
if {_PM_OSCT.U_Branch} := '53' then 'Branch 1' else
if {_PM_OSCT.U_Branch} := '54' then 'Branch 2' else
if {_PM_OSCT.U_Branch} := '55' then 'Branch 3' else
if {_PM_OSCT.U_Branch} := '67' then 'Branch 4' else
if {_PM_OSCT.U_Branch} := '68' then 'Branch 5' else
if {_PM_OSCT.U_Branch} := '69' then 'Branch 6' else
if {_PM_OSCT.U_Branch} := '70' then 'Branch 7' else
if {_PM_OSCT.U_Branch} := '72' then 'Branch 8' else
if {_PM_OSCT.U_Branch} := '73' then 'Branch 9' else
if {_PM_OSCT.U_Branch} ;: '74' then 'Branch 10' else "Error";
Any help would be greatly appreciated as its doing my head!
Thanks,
Simon.
You seem to be using an assignment operator (:=) instead of equal check (=).
For example,
if {_PM_OSCT.U_Branch} := '53'
should be changed to :
if {_PM_OSCT.U_Branch} = '53'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.