I have an existing report. I am trying to find a way to indicate on the report if a person is deceased. 99% of names listed will NOT be, so if I can have an indication of deceased only, that would be best.
3 Answers
-
Sep 14, 2017 at 07:37 PM
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.
Add comment
-
Sep 15, 2017 at 07:55 AM
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
-
Add comment