How do I get Detail to repeat
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22947
Printed Date: 28 Apr 2024 at 7:35am
Topic: How do I get Detail to repeat
Posted By: tondalynn88
Subject: How do I get Detail to repeat
Date 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!
|
Replies:
Posted By: kevlray
Date 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.
|
Posted By: lockwelle
Date 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
|
Posted By: tondalynn88
Date Posted: 18 Aug 2021 at 8:35am
|
Nope, that did not work. Good thought though!
|
Posted By: tondalynn88
Date 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.
|
Posted By: lockwelle
Date 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.
|
|