Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Two Details sections? Post Reply Post New Topic
Page  of 2 Next >>
Author Message
Adagio
Newbie
Newbie
Avatar

Joined: 17 May 2007
Online Status: Offline
Posts: 11
Quote Adagio Replybullet Topic: Two Details sections?
    Posted: 17 May 2007 at 11:20pm
Is it possible to have two Details sections on one report?

I need to create a report like this:

-Some information-
-An items list-
-Some information-
-Another list-
-Some information-


Is this possible?
IP IP Logged
GuestX
Newbie
Newbie


Joined: 17 May 2007
Online Status: Offline
Posts: 12
Quote GuestX Replybullet Posted: 17 May 2007 at 11:33pm
Not directly. You need to use subreport/s. 
IP IP Logged
GuestX
Newbie
Newbie


Joined: 17 May 2007
Online Status: Offline
Posts: 12
Quote GuestX Replybullet Posted: 18 May 2007 at 8:37am
Hmm to think it again, maybe you can it just requires splitting some groups for 2 sections and maybe some supressing of group section. 
IP IP Logged
Adagio
Newbie
Newbie
Avatar

Joined: 17 May 2007
Online Status: Offline
Posts: 11
Quote Adagio Replybullet Posted: 21 May 2007 at 2:45am
Hmmm... I'll try that out, hoping it works
IP IP Logged
Adagio
Newbie
Newbie
Avatar

Joined: 17 May 2007
Online Status: Offline
Posts: 11
Quote Adagio Replybullet Posted: 21 May 2007 at 4:15am
Do you know where there is a good tutorial that shows how subreports works? I'm using vb.net, filling the reports using datasets
IP IP Logged
RobV
Newbie
Newbie
Avatar

Joined: 26 Apr 2007
Location: United Kingdom
Online Status: Offline
Posts: 13
Quote RobV Replybullet Posted: 22 May 2007 at 7:06am
Ok,
 
To obtain....
 
-Some information-
-An items list-
-Some information-
-Another list-
-Some information-
 
You do not need to use a subreport. You need to right click on the section bar which looks like this...
 
D
D
D
D
D
 On the Left hand side of the screen. Right click on one of your detail sections.
Select Insert Section Below. This will now give you a Details1 and a Details 2 section.
 
Hope this helps.
 
RobV
IP IP Logged
Adagio
Newbie
Newbie
Avatar

Joined: 17 May 2007
Online Status: Offline
Posts: 11
Quote Adagio Replybullet Posted: 23 May 2007 at 2:17am
Thanks
IP IP Logged
bha_vesh
Newbie
Newbie


Joined: 25 May 2007
Location: Iceland
Online Status: Offline
Posts: 5
Quote bha_vesh Replybullet Posted: 25 May 2007 at 8:09am
Hello , My problem is sm what similar,
The answer given in the last mail ( the one which is below my mail ) leads to 1  Detail Section immediately next to the other one.
My prob is that , the second detailed section should follow after sm space , where I can put in text which should not be repaeted 
 
So the format is like
 
Unique text
Details for data Set 1
Another Unique text
Deatils for  data Set 2
 
Plz help !!!!
 
Thanks !
 
*************************************
 
Ok,
 
To obtain....
 
-Some information-
-An items list-
-Some information-
-Another list-
-Some information-
 
You do not need to use a subreport. You need to right click on the section bar which looks like this...
 
D
D
D
D
D
 On the Left hand side of the screen. Right click on one of your detail sections.
Select Insert Section Below. This will now give you a Details1 and a Details 2 section.
 
Hope this helps.
 
RobV
IP IP Logged
RobV
Newbie
Newbie
Avatar

Joined: 26 Apr 2007
Location: United Kingdom
Online Status: Offline
Posts: 13
Quote RobV Replybullet Posted: 25 May 2007 at 9:32am
This all depends on the text and the reason behind it. Ok.... if your unique text is a persons name. Then you need to find a some identifier within your databse which will associate with this persons name.
 
An ID no or something.
 
You should then group by this field in your report.
 
You should then create a formula something like this.....
 
if GroupName ({@group headings}) = '1' then 'Jame'
else if GroupName ({@group headings}) = '2'  then 'Dave'
else if GroupName ({@group headings}) = '3'  then 'Angie'
else if GroupName ({@group headings}) = '4'  then 'Liz'
else if GroupName ({@group headings}) = '5'  then 'Chris'
else if GroupName ({@group headings}) = '6'  then 'Andrew
else 'MISSING INFO'
 
You then want to drop this into the group header section relative to the formula.
 
This will allow you to customize the unique text within the formula.
 
Like I said though, it kinda depends on what your unique text is for.
 
Can you post an example?
 
Take it easy
 
RobV
IP IP Logged
bha_vesh
Newbie
Newbie


Joined: 25 May 2007
Location: Iceland
Online Status: Offline
Posts: 5
Quote bha_vesh Replybullet Posted: 25 May 2007 at 10:07am
hey RobV thanks for your cooperation. I'm so sorry to use the word unique , it is sm entry in the Textobjects which should appear only once in that report( hence the word "unique" )
 
Its better that i post an example. 
 
*****************
16 : S.No  Name AmtPaid   Bank
this no 16 will be coming from the data base. so its exact no is not know , hence "detail" is used.
 
 
17- Balance payable amount (if any)
18- Refund amount (if any) The particulars given above are true to the best of my knowledge & belief. Place............................
 
No 17 n 18 are the texts that should come only once.
 
then i've the same  "detail" as in No 16
19 : S.No    Name  AmtPaid    Bank
********************************
 
So this sort of format is posing a problem .
 
Hope i'm lucid enough.
 
I ne1 can help it will be really nice.
 
Thanks !!
 
 
IP IP Logged
Page  of 2 Next >>
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.030 seconds.