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.
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: