mike55 Posted July 20, 2007 Posted July 20, 2007 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. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
mike55 Posted July 20, 2007 Author Posted July 20, 2007 Solved my problem, I have had to use subreports. Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
pendragon Posted July 23, 2007 Posted July 23, 2007 Mike55 If I have read this correctly then you shouldn't need to use sub-reports. In crystal add a group for dstMembers.Member_ID then put the members detail in the header and the duesdata in the details. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.