asked on

Grid and Detail in Crystal Reports XI R2

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.

Mike McCracken

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

pvsbandi

ASKER

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.

Mike McCracken

There should be several groups

Are you grouping on the NAME field?

mlmcc

Mike McCracken

Can you upload the report or show what you want the report to look like?

mlmcc

pvsbandi

ASKER

I have attached the report. the "Other Members" subreport is where i have the issue.
TEST-REPORT.rpt

Mike McCracken

I don't see the issue. It seems you have several people in the group.

mlmcc

pvsbandi

ASKER

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".

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pvsbandi

ASKER

Wonderful! Do we have any control over the borders to make it look like a table?

Mike McCracken

You can add borders to the fields and set the cross tab to not show the margins.

mlmcc

pvsbandi

ASKER

Great! Thank You!