displaying values

[mrnez]

Hello

I am not sure if this is possible but what I want to achieve is to have a report which checks a database field and depending on it's contents displays a value in a field only local to the report, eg

database field dir_security.dir_access if this equals 1 then the report should display VIEW. if it equals 4 then the report should display EDIT,CREATE,MOVE etc

Many thanks in advance

Rich

 

[AyJayEL]

Create a formula;-

If{dir_security.dir_access} = 1 then "View" else
If{dir_security.dir_access} = 2 then "Move" else
If {dir_security.dir_access} = 3 then "Create" else
If {dir_security.dir_access} = 4 then "Edit"

If that's not exactly what you want you should be able to amend it to fit!

Drop the formula into the report. Learn something new every day *:->*
AyJayEl

 

[mrnez]

Hi

I tried that and got the following message when trying to save the report, The result of the Selection formula must be a boolean

Thanks

Rich

 

[AyJayEL]

Selection Formula? Where are you trying to create the formula? Learn something new every day *:->*
AyJayEl

 

[mrnez]

I sorted it, I putting the formula in the record selection part doh !!

thanks for your help

Thanks

Rich