Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Add multiple Detail Sections Post Reply Post New Topic
Author Message
Fgmodelsport
Newbie
Newbie
Avatar

Joined: 25 Aug 2009
Location: Belgium
Online Status: Offline
Posts: 2
Quote Fgmodelsport Replybullet Topic: Add multiple Detail Sections
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Fgmodelsport
Newbie
Newbie
Avatar

Joined: 25 Aug 2009
Location: Belgium
Online Status: Offline
Posts: 2
Quote Fgmodelsport Replybullet Posted: 26 Aug 2009 at 5:42am
I'm sorry.Embarrassed

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



IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
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.031 seconds.