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
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
ASKER
yes you are right I attached wrong screen shot. dependants have there own member code like spouse OM0582 02 same like dependants..
How do you select records?
Did you try the LIKE method?
mlmcc
Did you try the LIKE method?
mlmcc
ASKER
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?
Are u able to select all the records?
Then just put the fields on the report in the details section
mlmcc
Then just put the fields on the report in the details section
mlmcc
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.
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.
ASKER
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
Member-Detail-Form-GURU.xls
Data-Structure.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mr.mlcc I am new in cr. please give me a example or any tutorial for my reference.
ASKER
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is there a way to determine the spouse?
Is it always the 02 dependent?
mlmcc
Is it always the 02 dependent?
mlmcc
ASKER
yes. 02 is fixed for spouse 01 for member.
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