Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual Basic 4 Calling Crystal Reports Version 4.6

Status
Not open for further replies.

kathymac

Programmer
Nov 25, 2009
7
CA

Hello,

I need to edit a Visual Basic 4 program that uses a Crystal Reports control v 4.6.

The VB4 program prompts the user to enter a Start Date and an End Date for their report. The query is
based on a start date and an end date.

How can I pass the Start Date and End Date to my crystal reports?

F.CrystalReport.DataFiles(0) = (sFILE_PATH + MAIN_DBNAME)
F.CrystalReport.SelectionFormula = sSQL
F.CrystalReport.SortFields(0) = sSort

F.CrystalReport.ReportFileName = (sAPP_PATH + sReportName)
F.CrystalReport.Destination = 0

lResult = F.CrystalReport.PrintReport
If (lResult <> 0) Then MsgBox F.CrystalReport.LastErrorString
__.____._
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top