AnsweredAssumed Answered

How can I structure this layout report...?

Question asked by lymetyme24 on Jul 15, 2011
Latest reply on Jul 15, 2011 by philmodjunk

Title

How can I structure this layout report...?

Post

Hello All -
I'm an intermediate developer creating a database for a small business. I'm having trouble achieving what I hope to with the way I want to display line items on an invoice:

The way this company works, there may be 50 line items on an invoice. Some of them have "sub-line items" associated with them, some do not. So I'm trying to figure out how to create a report (which will be printed as the invoice that gets sent to clients) that shows all the line items... and then IF a line item has "sub-line items", then they show up directly underneath that specific line item.

What I'm trying to get it to look like is something resembling this:

Line Item 1
Line Item 2
Line Item 3
- Sub-Line Item 3
- Sub-Line Item 3
- Sub-Line Item 3
Line Item 4
Line Item 5
- Sub-Line Item 5
- Sub-Line Item 5
Line item 6
Line Item 7
...and so on

I just can't wrap my mind around how to structure the layout for the report. If I use "Sub-Line Items" as the BODY... then only Line Items that have "subs" will show up. If I use "Line Items" as the BODY... then how do I get the "Sub-Line Items" to show up?

Any help would be greatly appreciated. I feel like there is an answer, I just have coders block.
Thanks.

Outcomes