Crystal Report Question

[aldrean]

This post was originally at vb.net forum and apparently moved here as it was here it properly belongs.Anyway, this would be my first time to make a report(a receipt actually) using Crystal Report.I had two querries in my access database and want to use in this report.My question would be, is it possible to use this two querries at the same time, I mean, say Querry1 deals with all the information of a certain customer that needs to be displayed in the receipt and Querry2 pertains to the transaction of the said customer.All the two querries were linked by the transaction number.Thanks...

[King_George]

This post was originally at vb.net forum and apparently moved here as it was here it properly belongs.Anyway, this would be my first time to make a report(a receipt actually) using Crystal Report.I had two querries in my access database and want to use in this report.My question would be, is it possible to use this two querries at the same time, I mean, say Querry1 deals with all the information of a certain customer that needs to be displayed in the receipt and Querry2 pertains to the transaction of the said customer.All the two querries were linked by the transaction number.Thanks...

Short answer is yes you can. What you need is a master-detail report using the index between the two queries as a join. You can do this quickly with the report builder or get a tutorial from www.businessobjects.com

[aldrean]

Ok, now this would be my follow up question,I already make the join having transaction number as the index between the two querries and seems fine with me.Problem is when it comes to the transaction details, it only shows the first record of the transaction.Say in transaction number 1, these are these details: detail1,detail2..detailN.On my report it only display detail1 and not the others...What could be the possible problem here?