You'll have to pull the Item info into a group header and make the Discount the detail
>Hello there,
>
>I need to modify a report, it's an invoice report. This report has a cursor1 for the header (customer info), cursor2 for the detail (items bought), now I have some data that needs to be added to the report, basically every item bought needs to have discount data displayed. So the invoice should look like this, right now the first 2 levels are there, I have to add the third level (Discounts)
>
>--- Customer
>---------- * Item 1
>---------------- - Discount 1
>---------------- - Discount 2
>---------------- - Discount 3
>---------- * Item 2
>---------- * Item 3
>---------------- - Discount 1
>---------------- - Discount 2
>
>I usually do a big query to get all the data in a cursor then do my groupings in the report but if I can avoid that then I'll save myself some redesigning issues since it's a messy report. Any ideas on how to implement this?
>
>Thanks!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer