subreport (urgent)

[damini_dd]

Hello Friends,

I've two probs in crystal report

First is regarding sub report. See I got Invoice and next payment schedule for student. When I print Invoice I want to display data if payment schedule which shows next payment schedules. this data is stored in one different table (tblPaymentSchedule) and Invoice is stored in (tblInvoice). Now when I select a student's name , it should display invoice as well as next payment schedule. I've created two reports.
1. Invoice
2. payment schedule

So In short, I want to link subreport with main report using parameter. And I don't know how to do link.


I am using payment schedule as subreport in invoice report and page footer section. when i tried to print it prints all the data from payment schedule but not of selected student whose invoice i am print. plz help me

With crInvoice
        .Connect = strConn
        .ReportFileName = App.Path & "\Reports\Invoice.rpt"
        .SelectionFormula = "{tblPayment.Receiptno}='" & sInvNo & "'"
        .WindowTitle = "Invoice"
        .WindowState = crptMaximized
        .Destination = crptToWindow
        .Action = 1
    End With

Second, I am storing all these report files in one folder and displaying using connect and reportfilename property. But i don't want to change layout of the report to my client if they've crystal report installed in their machine. so plz tell me how to do that.


thx