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.