Crystal Report - Database item

[pmacduff]

Hi everyone...I'm working on a census report and I want it to show the "reason not eligible" element for the ineligbles. I can't seem to find a database field that will work. Does anybody know the table/field that I can use to get this info to print? TIA for any suggestions.

[Tom Poje]

I use the following in my census reports

if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='A' then '-age'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='B' then '-service'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='U' then '-hours'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='E' then '-union'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='F' then '-alien'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='G' then '-hourly'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='H' then '-salaried'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='J' then '-commission'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='K' then '-elects out'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='L' then '-elects out'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='M' then '-in other plan'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='N' then '-died'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='T' then '-terminated'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='O' then '-other'

else if {PLANEE.CATEGCD}='8' and {PLANEE.INELIGCD}='D' then '-excluded division'

(no charge for this one!)

[pmacduff]

Thanks Tom!