Crystal Report - Database item Options

[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!