?
Solved

Grid and Detail in Crystal Reports XI R2

Posted on 2011-10-04
11
Medium Priority
?
339 Views
Last Modified: 2012-05-12
hi,
  I have a result set like below.
ID         Name           DOB           Gender       Address                                         Switch
1           ABC             1/1/2001      Male          39th st, Elwood, NY                   Incident
2           ABC              1/1/2001     Male           89 Howard Cross, NC               Current
3           ABC             1/1/2001     Male           West Pokland Dr, TX                  Default
2           DEF              5/21/2006    Female       Apt 4, Riggs St, WV                   Current    
3           IJK                6/8/2009      Male          10 Morning Side Avenue, VA      Default
 

Open in new window


I want to show the grid for ID, Name,DOB as a grid on top of the report, followed by a group on the name, which will display the details of the person, which will have all the details, including another grid for different addresses a person is involded with.

Please advise as to how to do this.

0
Comment
Question by:pvsbandi
  • 6
  • 5
11 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 36914198
Crystal doesn't have a grid control so you will have to simulate it with lines, boxes or borders.

Try this
Group on the Name
Put the ID, Name and DOB in the group header
Set the widths and turn on the borders.
Place so they touch or even the borders overlap.

In the details put the other nformation
Again align and turn the borders on

Borders are a FORMAT option.

mlmcc
0
 

Author Comment

by:pvsbandi
ID: 36914243
Hi,
   When i put the ID, Name and DOB in the group header, it is getting me only the first name in the list; not all of them.
 
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36914287
There should be several groups

Are you grouping on the NAME field?

mlmcc
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 36914299
Can you upload the report or show what you want the report to look like?

mlmcc
0
 

Author Comment

by:pvsbandi
ID: 36914328
I have attached the report. the "Other Members" subreport is where i have the issue.
TEST-REPORT.rpt
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36914419
I don't see the issue.  It seems you have several people in the group.

mlmcc
0
 

Author Comment

by:pvsbandi
ID: 36914452
yes, several people. So, i want the list of all people, thier DOB, gender etc, on top, under the header "Other members of Household". Then a detail section should show their details under the header "Referral Participants of the household".
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 36914851
Something like this

mlmcc
TEST-REPORT-RevA.rpt
0
 

Author Comment

by:pvsbandi
ID: 36916105
Wonderful! Do we have any control over the borders to make it look like a table?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36917073
You can add borders to the fields and set the cross tab to not show the margins.  

mlmcc
0
 

Author Closing Comment

by:pvsbandi
ID: 36917780
Great! Thank You!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question