Edit a report
"Gert Blij" <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Organization | Gert Blij |
| Message-ID | <[email protected]> |
I am a total newbie to Reports and am completely stuck. I want to report on a Base qury that produces: CatNo, CatDesc, ItemNo, Price There is a one to many relationship by CatNo to ItemNo I want the report to look like this: CatNo 1, Description1 Item No Price 1 9.99 2 8.99 CatNo 2, Description2 Item No Price 3 9.99 4 8.99 Etc. Can that be done? And if so how? When I use the Report Wizard I seem only to be able to group on CatNo and CatDesc goes to the item lines. TIA Gert