Auto-marking a field. 1

[Jetter88]

I'm currently created a report (entry form style) that has checkboxes on it. The report obtains data entered and displays it on the report. I will be have a section that will mark itself depending on the values.

for example:
Service Type will have 2 option on the form: Commercial or Residential with same boxes (fields) beside it. Depending on the data in the records (C or R), i want the proper field to mark an "X" and the other to remain blank.

I think i need a formula field with an IF condition in it? Pls help if it on the right path and what the solution is.

Thanks in advance!

 

[BJCooperIT]

I find the easiest is to decode a field in your query to create a "calculated" field:

select decode(COMM_RES,'C','X','') Commercial_X,
       decode(COMM_RES,'R','X','') Residential_X,
...

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[Jetter88]

Thanks again BJCooperIT!

The solution was quick and easy to understand!

I'm sure I'll have another roadblock!