Milti Level Report Structure Question

[AJM]

Hi All,

I have been trying to figure this out for a while.

I have a complex query that basically generates the following data;

Part Number, Assembly Level


PN0001, 1
PN0002, 2
PN0003, 2
PN0004, 1
PN0005, 2
PN0006, 2
.
.
Etc.

I am trying to create a report that will display the data like this;
PN0001
-----PN0002
-----PN0003
PN0004
-----PN0005
-----PN0006
.
.
Etc.

Problem is, I get this;
PN0001
PN0004
-----PN0002
-----PN0003
-----PN0005
-----PN0006

I've tried to use grouping Etc. but can't quite get it to do what I want, any help would be appreciated.
Apologies if this is all a bit vague, not sure what other info will help.

Thanks in advance.

AJM

[pbaldy]

I would think there would need to be another field that related the level 2 items to their parent, and that field would be the primary grouping field. A level 1 would either have itself or Null in that field, either of which could be used.

[AJM]

You are right, there is another field that links the records together (Used on).
I need it to print level 1 then all the related Level 2's, then move onto the next Level 1, Etc.

I seem to have all the data in the query, but can't quite get it to do what I want?

Cheers,
AJM.

[pbaldy]

Have you tried grouping first on that other field? Can you post the db here?

[AJM]

I am just about to have a go with that. Unfortunatly I am not able to post the DB.

Thanks for your help so far.

If I have no joy, i'll try and remove the sensitive data and post the DB.

Have a good weekend.

Cheers,
AJM.

[pbaldy]

No problem. I think the first grouping has to be on that field to keep the level 2's with their level 1.