Skip to Content
avatar image
Former Member

Noting Deceased in Crystal reports

Sep 14, 2017 at 04:39 PM | 29 Views

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.

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    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
    10|10000 characters needed characters exceeded

  • avatar image
    Ian Waterman
    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
    10|10000 characters needed characters exceeded

  • avatar image
    Don Williams
    Sep 14, 2017 at 04:39 PM

    Need a lot more details

    Add comment
    10|10000 characters needed characters exceeded