OOo 2.0,122, Base on a MySQL db. I am a total newbie to Reports and am completely stuck.
I want to report on a Base query 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]