Using Crystal Reports with VB 6

[JSUAlumni]

I've developed an application that uses VB 6, Crystal Reports 8, and SQL Server 7. In my application when I hit submit, the form sends the beginning and ending dates to my crystal report like so:

Dim selection As String
selection = "{Info.Date} >= #" & _
DTPicker1.Value & &quot;# AND {Info.Date} <= #&quot; & DTPicker2.Value & &quot;#&quot;
CrystalReport1.SelectionFormula = selection
CrystalReport1.ReportFileName = App.Path & &quot;\Report.rpt&quot;
CrystalReport1.Action = 1

The selection statement is getting sent fine cause the report only views the records with the appropriate dates. However, also in my application I add entries into the Info table. If I then try to view the report the entries I've added do not show up. It's as if the only records I can sort through are the ones that were in the database when I saved the crystal report and then compiled the VB project. Please help if you can. Thanks.

 

[jfrost10]

Hey man,

Check to make sure you didn't have Save Data With Report checked off (its under the File menu).

Jack

 

[JSUAlumni]

Yes, I tried that option but it still doesn't work.

 

[MarkSweetland]

Try adding this before the .Action

CrystalReport1.Database.Verify



Mark