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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports Ignoring Records from VB

Status
Not open for further replies.

rgh

Programmer
Feb 2, 2000
33
GB
Hi,

I am using the Crystal Reports Control 7 (crystal32.ocx) to view a crystal report within VB. I am dumping the data for the report out to an access database and then calling the crystal report to show the data. The first time I run the program all the 5 records are displayed. If I then run the report again, without exiting the form or changing the query, one of the records is missing, yet the record is in the data that is output. Below is the code that I use to call the report. If I put a msgbox in the routine code below just beofre the .reset then the report works fine.

Any ideas?

Richard.

rptCompBusBreakdown.Reset
rptCompBusBreakdown.ReportFileName = c:\reports\CompanyBusinessBreakdown.rpt"
rptCompBusBreakdown.DataFiles(0) = "c:\reporst\user.mdb"
rptCompBusBreakdown.PrinterDriver = Printer.DeviceName
rptCompBusBreakdown.Destination = 0

rptCompBusBreakdown.Action = 1
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top