Hi, I was wondering if I can split the detail section in a crystal report so that detail section 1 displays the first record and section 2 displays the second. I know that I will always get 2 records that will be displayed in the detail section. The reason
I want to do that is because each section needs to be displayed differently. I don't mean just different color and stuff. The size of the field has to be different and there has to be some images to the left of the field in Detail Section 2.
Try to get both records returned into one record, by altering the stored procedure / data source you are using. You will have all the fields from both records in the one data source for the report. Then you can take the fields from the first record in the detail
1 section, , and have the fields from the second record and put them into the detail 2 section.
Sam: I think you can do that. Basically, right-click on the Details section (left-hand side of the report), and select "Insert Section Below" from the menu. That will split the section into a "Details a" and "Details b". Then, right-click the "Details a" section
and select "Section Expert..." from the menu. From here, check the box next to "Suppress (No Drill-Down)" under the "Common" tab, and to its right, click the button with the "X+2" on it. Basically, you'll have to indicate some kind of condition to suppress
the "Details a" section when you want to show the "Details b" (different display) section. So in other words, for the first record, you'll suppress "Details b" and not "Details a"; and for the second record, "Details a" instead of "Details b". Hope that makes
sense - the trick will be selecting the criteria that makes each section invisible and at the right time. Good luck!
_______________________________________
You know how it is when you're walking up the stairs, and you get to the top, and you think there's one more step? I'm like that all the time.
Here is an example using the pubs database Sql Server 2000 First is a view which returns 2 records: CREATE VIEW dbo.v2Records AS SELECT au_id, title_id, au_ord, royaltyper FROM dbo.titleauthor WHERE (au_id = '213-46-8915') Then these are joined together CREATE
VIEW dbo.v2RecordsSideBySide AS SELECT dbo.v2Records.au_id, dbo.v2Records.title_id AS Title1, dbo.v2Records.au_ord AS Ord1, dbo.v2Records.royaltyper AS Roy1, v2Records_1.title_id AS Title2, v2Records_1.au_ord AS Ord2, v2Records_1.royaltyper AS Roy2 FROM dbo.v2Records
INNER JOIN dbo.v2Records v2Records_1 ON dbo.v2Records.au_id = v2Records_1.au_id AND dbo.v2Records.title_id <> v2Records_1.title_id Made into one query this is: SELECT v2Records.au_id, v2Records.title_id AS Title1, v2Records.au_ord AS Ord1, v2Records.royaltyper
AS Roy1, v2Records_1.title_id AS Title2, v2Records_1.au_ord AS Ord2, v2Records_1.royaltyper AS Roy2 FROM (SELECT au_id, title_id, au_ord, royaltyper FROM dbo.titleauthor WHERE (au_id = '213-46-8915')) v2Records INNER JOIN (SELECT au_id, title_id, au_ord, royaltyper
FROM dbo.titleauthor WHERE (au_id = '213-46-8915')) v2Records_1 ON v2Records.au_id = v2Records_1.au_id AND v2Records.title_id <> v2Records_1.title_id The records show up twice, once with one in front, and the second time with the other in front.
SamU
Contributor
2895 Points
1627 Posts
Is there a way to split the Detail section?
Jul 30, 2003 08:40 PM|LINK
Sam
v1rich
Member
100 Points
20 Posts
Re: Is there a way to split the Detail section?
Jul 31, 2003 01:17 PM|LINK
SamU
Contributor
2895 Points
1627 Posts
Re: Is there a way to split the Detail section?
Jul 31, 2003 01:52 PM|LINK
Sam
Daspoo
Member
90 Points
18 Posts
Re: Is there a way to split the Detail section?
Jul 31, 2003 07:06 PM|LINK
You know how it is when you're walking up the stairs, and you get to the top, and you think there's one more step? I'm like that all the time.
-- Steven Wright
v1rich
Member
100 Points
20 Posts
Re: Is there a way to split the Detail section?
Aug 01, 2003 03:39 PM|LINK