Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How do I get Detail to repeat Post Reply Post New Topic
Author Message
tondalynn88
Newbie
Newbie


Joined: 28 Oct 2008
Online Status: Offline
Posts: 7
Quote tondalynn88 Replybullet Topic: How do I get Detail to repeat
    Posted: 13 Aug 2021 at 7:04am
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!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 16 Aug 2021 at 4:31am
It might work with a second detail under the first detail.  I have not tested this so I am not 100% sure it will work correctly.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 17 Aug 2021 at 7:23am
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
IP IP Logged
tondalynn88
Newbie
Newbie


Joined: 28 Oct 2008
Online Status: Offline
Posts: 7
Quote tondalynn88 Replybullet Posted: 18 Aug 2021 at 8:35am
Nope, that did not work. Good thought though!
IP IP Logged
tondalynn88
Newbie
Newbie


Joined: 28 Oct 2008
Online Status: Offline
Posts: 7
Quote tondalynn88 Replybullet Posted: 18 Aug 2021 at 8:44am
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.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Aug 2021 at 1:25pm
I think that you need your subreport to figure out your solution. You probably need to use some of the logic from the main report to properly complete your sentence in the subreport.

Not too helpful, I realize.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.