last reminder sent

[rita42071]

I am writing a payment reminder with 4 different supressed text sections.
Now the problem:
I have a report selection of "next_reminder_date is between 9/1/2004 and 9/30/2004" and had a return of all reminders including past reminders from those with no payments ie 1 2 3 and 4. I need to supress all of the reminders except the last one. Selection criterial "reminder_num=4" does not work because of records with varing number of reminders sent.

Help please.
Thanks.
Rita

 

[synapsevampire]

Try posting technical information rather than text descriptions:

Crystal version
Database/connectivity used
Example data
Expected output

I'll assume that this:

"Selection criterial "reminder_num=4" does not work because of records with varing number of reminders sent."

Means that the number is a count of the reminders sent, rather than a field containing the amount.

You might try grouping by the client, and then in the Report->Edit Selection Formula->Group place something like:

{table.next_reminder_date} = maximum({table.next_reminder_date},{table.client})

-k

 

[rita42071]

Let's try again.
Crystal Version: 10
Database: DB2

The fields I draw from are
MSTR.ID,
MSTR.LAST_NAME,
MSTR.FIRST_NAME,
PLDG.PLDG_NUM,
PLDG.PLDG_AMT,
PLDG.PLDG_BAL,
PLDG.PLDG_BILL_AMT,
PLDG_BILL_SCHED.NEXT_RMNDR_DATEDB, PLDG_BILL_SCHED.PLDG_RMNDR_NUM
PLDG.PLDG_CMPGN_CD

The report is filtered by PLDG_BILL_SCHED.NEXT_RMNDR_DATEDB is between 9-1-2004 and 9-30-2004 and grouped by Lname, Fname then ID with section conditional suppression for PLDG.PLDG_CMPGN_CD.

The end result should be one pledge payment reminder for each constintuent with a payment due between 9-1-2004 and 9-30-2004. What is actually happening is that: if a constituent has not paid last months bill I am getting more than one reminder printed ie. PLDG_BILL_SCHED.PLDG_RMNDR_NUM #1 and PLDG_BILL_SCHED.PLDG_RMNDR_NUM #2 etc.

I have tried section conditional suppress on the MSTR.ID group PLDG_BILL_SCHED.PLDG_RMNDR_NUM} = Maximum(PLDG_BILL_SCHED.PLDG_RMNDR_NUM,MSTR.ID). It still returned multiple copies of pledge reminders.

I hope this is more clear.


Thanks
Rita

 

[synapsevampire]

It is more clear, but it doesn't address what was asked for, which is a basic spec:

Example data
Expected output

You don't need conditional suppression, use the method I outlined before, except that your group field is different, use it.

If you're willing to supply what is needed to understaqnd the structures, I'll work out the specifics, if you just want to chat about theory, I've already addressed that.

Posting the fields pulled DOESN'T demonstrate where you have these dupes.

Hope this resolves.

-k

 

[rita42071]

Thanks for your help synapsevampire!
It works fine now that I put the formula in the group section.

Thanks