Kbase P166010: Query/Results: Is it possible to modify Results/Query to display the first record of a child table w
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/05/2010 |
|
Status: Unverified
GOAL:
Query/Results: Is it possible to modify Results/Query to display the first record of a child table without manually editing the code?
GOAL:
Can a Query/Results report joining the Customer and Order tables return only the first Order of each customer?
FACT(s) (Environment):
Windows
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
No. There is no way to modify the query of the report generated using Results to return only the first record of the child table. The only way to achieve this result is to generate the .p code for the report, edit the .p code to specify FIRST Order instead of EACH Order, save the modified code and run it.