I have a report that needs to have the victims name, race sex and DOB. The only problem is the victim can also be "Society" which has none of those.
when nametype = "Victim" then "Individual" and "Society" can both be selected. however, when I use the following code:
{nmmain.lastname} &","& {nmmain.firstname}&" "& {nmmain.middlename}&"("&{nmmain.race}&","&{nmmain.sex}&","&{nmmain.age}&")" to show the vicitms name, race sex and DOB, the records with the victim of Society dissapear from my report.
Is there a way I can do something like the following:
if nametype = "Victim" then {nmmain.lastname} &","& {nmmain.firstname}&" "& {nmmain.middlename}&"("&{nmmain.race}&","&{nmmain.sex}&","&{nmmain.age}&")" else
if nametype = "Society" then "Society"
Thank you so much for your help!