Hi All - I'm wondering if anyone could tell me how I can get the data on a Detail line to repeat when I have multiple items on the linked sub-report.

When exported, my end users are not able to sort the data without it messing up and not aligning with what was on the sub-report.

For example how do I get "A boy walks in to a" to repeat on each line for car, door, house?

A boy walks in to a bar
                            car
                            door
                            house

Thanks so much!

you could pass the 'A boy walks into to a' as a parameter to the subreport, and then display it for every line.

Since the subreport has multiple lines and the main report does not, the main repoort 'sees' only 1 line to display.

It is worth a try.

HTH

The only problem with passing it to the sub is that the narrative changes on each line in the main report i.e.,

A cow strolls in to a
A horse gallops in to a
A snail slithers in to a, etc.

It changes each time.

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

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

I wish I could upload a picture but I'm not sure how I can do that.