want to skip lines with line numbers

pbuethe

Returning User
Local time
Yesterday, 22:49
Joined
Apr 9, 2002
Messages
210
I have a report with columns Patient Name, Medicaid Nbr, Rate Code, etc.
Each patient has their own Medicaid Nbr but may have multiple rate codes causing them to have multiple lines on the report. I want to number only the lines where the patient changes. I tried a textbox with running sum on Over All, but it numbers every line. Over Group started each patient at 1. I have been able to get it to only print the patient name and medicaid number once for each patient by setting HideDuplicates = Yes on those fields. I want to increment and print the line number once for each patient. Here is an example of what I want:

1. John Smith ab12345c 2983....
2. Joe Jones cd23456e 2984....
...............................2987....
3. Mary Jonson ef34555f 2983...

In this example, there are two records for Joe Jones, but only the first record gets a line number. (The leading dots before 2987 are just placeholders so this will format correctly; they represent blanks.)
How can this be done? Thanks for your assistance.
 
Last edited:
This will probably work

Put only the name in your report and do your running Sum then put the "subrecords" in a subreport linked to the Name field.
 

Users who are viewing this thread

Back
Top Bottom