How to reterive the data in the Subreport , subrport may reterive Multiple Records.

[Samir Patel]

Hello,


I Need to help to pass data on sub report..

Actaully I have tour table , Customer table , Invoice table and payment table, I need to create the Invoice contain the payment table, and In My payment table everythign is based on Invoice id...

So now i need to generate the Multiple cusotmer invoice in the Report... This report is sales Invoice contain the one payment section also...

So currently i am getting invoice report for Multiple customer, but i cannot access the payment details in it.....Please help us to retrive the payment details..

Here is the UI scenario:

User, Select Tour, and Customer , based on this In my Rad Grid, Multiple Invoice are displayed, and then Click on Print ALL, this Print all open the telerik report contain all the Inovice as in the grid , but now i cannot Reterive the payment details in my payment section...becoz i donot know how to pass Invocie id in The payment sub report????

Invoice report is my main report, and with in this i am using Payment details as a sub report..

FYI : Whehn i generate the report for only single Invocie...its reterive the payment details...

Regards
samir