Two Details 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=693
Printed Date: 27 May 2024 at 1:10pm
Topic: Two Details sections?
Posted By: Adagio
Subject: Two Details sections?
Date 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? |
Replies:
Posted By: GuestX
Date Posted: 17 May 2007 at 11:33pm
| Not directly. You need to use subreport/s. |
Posted By: GuestX
Date 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. |
Posted By: Adagio
Date Posted: 21 May 2007 at 2:45am
| Hmmm... I'll try that out, hoping it works |
Posted By: Adagio
Date 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 |
Posted By: RobV
Date 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
|
Posted By: Adagio
Date Posted: 23 May 2007 at 2:17am
| Thanks |
Posted By: bha_vesh
Date 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
|
Posted By: RobV
Date 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 ( mailto:%7b@group - {@group headings}) = '1' then 'Jame'
else if GroupName ( mailto:%7b@group - {@group headings}) = '2' then 'Dave' else if GroupName ( mailto:%7b@group - {@group headings}) = '3' then 'Angie' else if GroupName ( mailto:%7b@group - {@group headings}) = '4' then 'Liz' else if GroupName ( mailto:%7b@group - {@group headings}) = '5' then 'Chris' else if GroupName ( mailto:%7b@group - {@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
|
Posted By: bha_vesh
Date 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 !!
|
Posted By: RobV
Date Posted: 26 May 2007 at 12:21am
|
Hi,
In your post you say that......''this no 16 will be coming from the data base.'' Is trhis the case for all of the numbers? If so then you can group by those database numbers and drop text box with the required text in or add a fomula like the one in my previous post.
if GroupName ({WO.No}) = '16' then ': S.No Name AmtPaid Bank'
else if GroupName ({WO.Part_No}) = '17' then 'Balance payable amount (if any)' and so on......
if thgis isnt true to your case, and the nubers after 16 do not exist on your db, then check back again as I will have to think about that one!
 Take it easy!
RobV |
Posted By: bha_vesh
Date Posted: 26 May 2007 at 3:23am
|
Hi , i meant that the details of no 16 , ie the data on Name , Amt , Banks etc will come from the database.
the no 16 , 17 etc are shown thru the text objects.
So i think u'll have to think again.
 Thanks mate!!
|