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

VB Code:
  1. With crInvoice

  2.         .Connect = strConn

  3.         .ReportFileName = App.Path & "\Reports\Invoice.rpt"

  4.         .SelectionFormula = "{tblPayment.Receiptno}='" & sInvNo & "'"

  5.         .WindowTitle = "Invoice"

  6.         .WindowState = crptMaximized

  7.         .Destination = crptToWindow

  8.         .Action = 1

  9.     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