I started with a Record Selection that limits the records to a date range and the med.  There are 3 groups on the report; Program, prescriber, and patient.

 

I need to end up with lists of the patients' charts that will be audited.

 

This is what I tried:

 

A formula field, @RandomNumber contains only {Rnd()} and was placed in the detail section but that gives a random # for each script written.  I moved the field to grpheader3 where it gives a random # for each patient and surpressed the detail line.

 

A running total {#grpcount} that does a distinctcount of the patient ID field, evaluate for every record, reset never - was added to groupfooter2

 

Group/Sort Expert for group3 is sorted on {all} and based on summary field Max of @RandomNumber which is placed in grpfooter3

 

I think I'm on the right track but need some help on the surpression part.

 

 

 

 

 

 

 

 

 

 

 

 

The record selection is a date range and the individuals receiving a certain med. The report has header 1 as the program, header 2 as the prescriber and header 3 as the individuals.  The detail line is supressed and contains a rnd() field, and the field is sorted so it is working correctly and the 'random-ness' is there.  Footer 2 has a running total, doing a distinct count on the individuals for each prescriber.  Also in footer 2 is a number which is 10 percent of the running total but rounded up so each prescriber will have at least one chart audited even if they have less than 10 clients.  So far, so good - everything works.

 

The problem:

They only want to see the individual's charts that will be audited.  So, prescriber 1 has 23 clients but only 3 will be choosen for audit so only those 3 names should appear in header 2. 

 

I've tried a number of things but either none of the names supress or all the names supress.  I don't do a lot in crystal and I'm hoping that there is a method to pick up the numbers in the footer and go back to the header.

 

Hope that this makes more sense.