Hi
I am passing a dataset to my crystal report which has two tables, "dstMembers" and "DuesData". Both tables are linked by a Member_ID with the dstMembers containing the primary key. I have created a dataset in my project and have added the Relation between both tables, and in Crystal reports when I view the "Links" tab in the Database expert dialog the link has already been set up.
When I go and produce my report and publish it to a .pdf format, my report firstly prints only one record from the "DuesData" at a time i.e. my members name is John Doe, and he has 3 records in the "DuesData" table. That means that The name John Doe is printed out 3 times. Also my report only displays data from the "dstMembers" table if it has records in the "DuesData" table.
Any suggestions?
Mike55.
I am passing a dataset to my crystal report which has two tables, "dstMembers" and "DuesData". Both tables are linked by a Member_ID with the dstMembers containing the primary key. I have created a dataset in my project and have added the Relation between both tables, and in Crystal reports when I view the "Links" tab in the Database expert dialog the link has already been set up.
When I go and produce my report and publish it to a .pdf format, my report firstly prints only one record from the "DuesData" at a time i.e. my members name is John Doe, and he has 3 records in the "DuesData" table. That means that The name John Doe is printed out 3 times. Also my report only displays data from the "dstMembers" table if it has records in the "DuesData" table.
Any suggestions?
Mike55.