It's a solicitor report listing their donors & the donors' spouses. If a spouse is deceased, I would like to note that. Say with an asterisk. It is mu understanding I have to write a formula in the Crystal report. I need step by step how to. This is an existing report I am simply updating for the new campaign year.
You will need to find a field in database that indicates deceased either a Boolean flag field or Deceased date field, so your formula will look something like
If {Yourflagfield} = 'Y' then '*' else ''
Or
If Not(isnull(deceaseddatefield)) then '*' else ''
Ian
Add comment