I have two temp-tables order and items. Single order may contain more than one item. My report is like below
Detail a
Order1 Order type
Detail b
Item1 itemname
When an order have more than two items then item section should repeat until the end of the items for that particular order like
Detail a
Order1 Order type
Detail b
Item1 itemname
Detail b
Item2 itemname
Detail b
Item3 itemname ……..
But I am getting as
Detail a
Order1 Order type
Detail b
Item1 itemname
Detail a
Order1 Order type
Detail b
Item2 itemname
I want to do it in section expert only without any stored procedure.
Use two reports in the report.
Dont place any columns in the report only columns should be placed in sub report.