Add multiple Detail Sections
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=7476
Printed Date: 18 May 2024 at 7:15pm
Topic: Add multiple Detail Sections
Posted By: Fgmodelsport
Subject: Add multiple Detail Sections
Date Posted: 25 Aug 2009 at 7:39am
|
Hellow i want to know how to add multiple sections. So that the output looks like: Header Article Details: 1. First Article 2. Second Article Comment Details: 1. First Comment 2. Second Comment 3. Third Comment 4. Fourth Comment Footer Greetz PS:Sorry for my bad english |
Replies:
Posted By: DBlank
Date Posted: 25 Aug 2009 at 8:13am
| you will have to post how your data is set up in your table for someone to assist with that. |
Posted By: Fgmodelsport
Date Posted: 26 Aug 2009 at 5:42am
I'm sorry. Here is my data setup: Table Sale: Sale_ID Sale_Name Table Comments: Comment_ID FK_Sale_ID Comment Table Article: Article_ID FK_Sale_ID Article I'm trying to show all the comments and articles of one sale. When I remove ether the comments or the articles from the report It works. When I add a detail section i get something like: Comment Article Comment Article Comment Article Greetzz |
Posted By: DBlank
Date Posted: 26 Aug 2009 at 8:53am
|
This is still a little hard to tell because I can't see how the tables are joined and then what the row level data is but here is what I can try to help with...
Look at your grouping level.
Once you have eveything linked palce all of your fields on the details and you will see how you can use grouping to get what you want.
Your highest level (group1) will likely be on Sale.saleid.
From there likely you can sort by Article ID and then by commentID.
Do not use multiple detail sections, just one. You may need to do conditional suppression using Next() or Previous() functions but O can't tell from this information.
|