How can i display multiple records of same table in crystal report?

Hi,
I want to create a 1 crystal report which shows the Member detail form member section i have to display member records and in spouse section i want to display spouse details and also same for member dependents.i have all details in one table but there are different record for member,spouse and dependents. (e.g for member code OM0582 in database OM0582  01 for spouse OM0582  02 , if member have 3 dependants then OM0582  03,OM0582  04,OM0582  04). i am attaching screen shot of table records of 1 member. i want to display this records in one member form, how can i do this?
error.jpg
Vijay Kamblesoftware engineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I think you attached the wrong screen shot

Can you select all related records based on the member code OM0582 or do the dependents have their own record code?

Can you select using like?

{MemberCode} Like "OM0582*"

mlmcc
Vijay Kamblesoftware engineerAuthor Commented:
yes you are right I attached wrong screen shot. dependants have there own member code like spouse OM0582 02 same like dependants..
mlmccCommented:
How do you select records?

Did you try the LIKE method?

mlmcc
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Vijay Kamblesoftware engineerAuthor Commented:
I show above record for example purpose i will select all records from table.i have separate record for member spouse and dependants. first six digit is common for member spouse and dependants and from right 2 digits are different for member, spouse and dependants. e.g. if Mr x have member code om0582 01 his spouse have om0582 02 and if he have 3 child's then dependants codes are om0582 03,om0582 04 and om0582 05.This all records are in same table. so how can display in creating in single member form reports?
mlmccCommented:
Are u able to select all the records?

Then just put the fields on the report in the details section

mlmcc
Raghavendra HullurSoftware DeveloperCommented:
Hi,
Can you show us with a screenshot like how you want to display the details related to a single member code? I mean if you want to display the main member, then followed by spouse abd children in a specific order, then we can create a formula by selecting first 6 letters of member code and group by that to display all related info one below other.
In case, your requirement is different, then, if you provide a screenshot of how you need to display, we can think on that.
Provide a rough screenshot or in an excel sheet how you want the details to be displayed.
Vijay Kamblesoftware engineerAuthor Commented:
i am attaching my full format of member form report. i want to pass from member and to member no parameter in report for selected members. i have member photo in server area and name of file stored in table (field name is strcustomercode) . i am also attaching xlsx file some data for single member for your reference.
Member-Detail-Form-GURU.xls
Data-Structure.xlsx
mlmccCommented:
Is all the data for the form in a single view?

Looking at what you want, I would probably make the dependent information a subreport and just pull the appropriate information into the subreport linking on the member number and changing the selection formula in the subreport to
   Left({?pm_MemberNumber},6) = Left({subMemberNumber},6)

Sort it by member number to get the order correct

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vijay Kamblesoftware engineerAuthor Commented:
Mr.mlcc I am new in cr. please give me a example or any tutorial for my reference.
Vijay Kamblesoftware engineerAuthor Commented:
Mr mlcc all data in form is in single view. i have to pass parameter main report? On the basis of main report parameter how can display the subreport?
James0628Commented:
I don't know where all of the data in your sample form is coming from, but another option might be to use a group.  Create a formula that's just Left ({your table.strCustomerCode}, 6) and group on that, and then sort on strCustomerCode.  That will give you one group for each member (eg. OM0582), with the records in the group sorted by the number (01, 02, 03, etc.).  I assume that there will always be a 01 record.  You could put the fields for that record in the group header, and the fields for the other records (spouse, etc.) in the detail section.  If you need to display different fields for some records, you could have separate detail sections (eg. one detail section for the spouse (02), and then a different one for the dependents), and suppress the detail section(s) that you don't need based on the last 2 digits (eg. Right ({your table.strCustomerCode}, 2) <> "02" to suppress the spouse detail section on the "dependents" records).

 James
mlmccCommented:
Is there a way to determine the spouse?
Is it always the 02 dependent?

mlmcc
Vijay Kamblesoftware engineerAuthor Commented:
yes. 02 is fixed for spouse 01 for member.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.