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]

Reply via email to