Graham86
05-21-2009, 12:38 PM
Hi,
On my report I have the Bill of Materials (BOM) that I am making a report for. Within the BOM there are 3 levels of data:
1- Product Name
2- Main part
3- Colour/Manufacturing
What I currently have the report doing is to (All data is within a query and each is its own record):
1-Burger
2-Bun
3-Relish
3-Mustard
3-....
2- Hamburger Patty
3-....
3-....
and so on
what I would like to do is to have the report be formatted so that all the level 3 items are on a single line between each of the level two Items as they currently are(Note within the BOM it have what line item they are as well as what level they are on and the line order must stay intact):
1-Burger
2-Bun
3-Relish / Mustard / ....
2- Hamburger Patty
3-.... / ....
I have been searching for a way to do this unsuccessfully so far, any help would be much appreciated and/or if you know if this is unable to be that would be appreciated as well.
Thanks
Graham86
On my report I have the Bill of Materials (BOM) that I am making a report for. Within the BOM there are 3 levels of data:
1- Product Name
2- Main part
3- Colour/Manufacturing
What I currently have the report doing is to (All data is within a query and each is its own record):
1-Burger
2-Bun
3-Relish
3-Mustard
3-....
2- Hamburger Patty
3-....
3-....
and so on
what I would like to do is to have the report be formatted so that all the level 3 items are on a single line between each of the level two Items as they currently are(Note within the BOM it have what line item they are as well as what level they are on and the line order must stay intact):
1-Burger
2-Bun
3-Relish / Mustard / ....
2- Hamburger Patty
3-.... / ....
I have been searching for a way to do this unsuccessfully so far, any help would be much appreciated and/or if you know if this is unable to be that would be appreciated as well.
Thanks
Graham86