Skip to Content
0

Noting Deceased in Crystal reports

Sep 14, 2017 at 04:39 PM

29

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Sep 14, 2017 at 07:37 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sophia, please comment directly on the post you are responding to. If you are trying to get Don's attention here, you can try to @mention him. Looping in Don Williams here.

To read more about @mentioning, in case you are interested, check out this blog: https://blogs.sap.com/2017/09/13/dont-mention-it-oh-wait-do/

0
Ian Waterman Sep 15, 2017 at 07:55 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
Sep 14, 2017 at 04:39 PM
0

Need a lot more details

Share
10 |10000 characters needed characters left characters exceeded