Reports: displaying field only once for each group!

[Guest_imported]

Hi, could somebody please help me with reporting output like this:

WorksheetNo DeliveredFrom No StoreName
-----------------------------------------
112233 Minchinbury 1133 Young
1209 Wagga

15577 Minchinbury 1152 Griffith
1308 Leeton
Yennora 1774 Blah


Instead the only output I can get is:

WorksheetNo DeliveredFrom No StoreName
------------------------------------------
112233 Minchinbury 1133 Young
112233 Minchinbury 1209 Wagga
115577 Minchinbury 1152 Griffith
115577 Minchinbury 1308 Leeton
115577 Yennora 1774 Blah

I need to display the Worksheet No. for each group only 'once'.
Any help will be greatly appreciated!

Thank you!
-Peter

 

[PaulF]

Try grouping on Worksheet, and setting Hide Duplicates to Yes for the textbox displaying the Delivered From Field, or setting Hide Duplicates to Yes for both Worksheet and Delivered From and do not use grouping.

PaulF