[RESOLVED] parameter to subreport from main report (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

[brucevde]

In Crystal.

Right-Click the SubReport object.
Select Change SubReport Links.
Choose the field from the Main report that you want to pass to the subreport.
In bottom right corner of dialog box, select the field in the subreport.

[damini_dd]

thx brucevde.