How to duplicate data from main report lines for sorting purposes

[tlbrown88]

Hi All - I'm wondering if anyone could tell me how I can get the data on my main (GF1) to repeat when I have multiple items on the linked Sub-report (GF1).

I am writing a report for our transportation team that on the main report has a shipment number and other shipment detail (carrier, leg, start/end dates, etc.) and in the sub report I am linking the Delivery's on that shipment along with the order numbers and customer ship to info.

When downloaded, I have a single shipment number from the main and 5+ lines of delivery numbers and related detail from the sub but because the main data doesn't repeat, it's not sortable and the shipment data looses it's integrity.

I have attached a pic of my .rpt if that helps explain the issue I am having.

Thanks for any help. I've tried everything I can think of.

 

[dgillz]

Does the picture include the subreport or not? I'm not clear what you are trying to accomplish or if a subreport is even required. Why did you resort to a subreport?

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[lbass]

If you reversed it so that the subreport items were the main report and the current main report was the subreport, you would get the desired output, I think.

-LB