Kbase 15750: Repeating values in Report Builder, that should not be there.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
SYMPTOM(s):
Repeating values that should not be there, appear.
Report Builder values repeat in report.
Report Builder
CAUSE:
If you are experiencing repeating values in a report developed in Report Builder, it may be due to the way you have defined your joins. You see this in the following example using the sports database.
Create a report with customer joined to invoice and customer also joined to order. Place just the Cust-Num and Invoice-Num fields on the report. The invoice number prints multiple times. The repeating Invoice-Num seems strange
because the customer number is set to only print once, and the Invoice-Num is a unique field (there are no repeating values stored in the database)..
Cust-Num Invoice-Num
1 6
6
6
6
6
36
36
36
36
36
This is because the join to the order table is also being processed. You can see if you add the Order-Num to the report.
Cust-Num Invoice-Num Order-Num
1 6 6
6 36
6 79
6 177
6 185
36 6
36 36
36 79
36 177
36 185
FIX:
You can eliminate the repeating values by sorting and grouping on Invoice-Num and selecting Print once. The report will then look like the following:
Cust-Num Invoice-Num Order-Num
1 6 6
36
79
177
185
36 6
36
79
177
185
The Process
-----------
1) Choose Group Order from the Database Menu.
2) Choose the field from which you wish to eliminate repeating values.
3) Select Edit.
4) Check the Print Once box.
5) Click OK.
6) Click OK.