Kbase 18296: How to get rid of repeating field values in a RB report.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/5/1998 |
|
How to get rid of repeating field values in a RB report.
Report Builder: How to get rid of duplicate field values in a report.
Customers often report that they are getting duplicate values
displayed on their reports. This typically happens when the report
is pulling information from 2 or more tables. For example, if you
create a report using the Customer and Order tables in the sports
database, you will see the Cust-Num, and Name repeated for every
Order-Num in the Order table. To avoid getting the repeating values,
the following steps should be taken:
1. The report should be Sorted and Grouped by Cust-Num or Name field.
2. A Group-Header bandline should be created on the report.
3. Move the Cust-Num and Name fields to the Group-Header bandline.
4. Order-Num should remain on the Record bandline if you want to see
all the Orders for that Customer.
5. Preview the report.
The above steps should take you from:
Cust-Num Name Order-num
1 Lift Line Skiing 6
1 Lift Line Skiing 36
1 Lift Line Skiing 79
1 Lift Line Skiing 177
1 Lift Line Skiing 185
2 Urpon Frisbee 94
2 Urpon Frisbee 125
2 Urpon Frisbee 171
3 Hoops Croquet Co. 55
.
.
To:
Cust-Num Name Order-Num
1 Lift Line Skiing
6
36
79
177
185
2 Urpon Frisbee
94
125
171
3 Hoops Croquet Co.
55
160
.
.
SAS, 10/05/98.