Grid and Detail in Crystal Reports XI R2
hi,
I have a result set like below.
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.
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
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.
Last Comment
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.
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.
There should be several groups
Are you grouping on the NAME field?
mlmcc
Are you grouping on the NAME field?
mlmcc
Can you upload the report or show what you want the report to look like?
mlmcc
mlmcc
ASKER
I have attached the report. the "Other Members" subreport is where i have the issue.
TEST-REPORT.rpt
TEST-REPORT.rpt
I don't see the issue. It seems you have several people in the group.
mlmcc
mlmcc
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Wonderful! Do we have any control over the borders to make it look like a table?
You can add borders to the fields and set the cross tab to not show the margins.
mlmcc
mlmcc
ASKER
Great! Thank You!
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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