Crystal Reports

[ritaab]

Hi,

I have this code to show a report after inserting and deleting some records in the database, but the report is not updated when I show it for the first time.

Could anyone tell me why? Or another way to show the report?

Private Sub lga_Click()
Dim Data As String

Prepara_Lista_Geral Data ‘This is the procedure that runs a Sql statment and writes in a table in Access

CrystalReport1.ReportFileName = App.Path & "\lista de accionistas1.rpt"
CrystalReport1.WindowState = crptMaximized
CrystalReport1.DiscardSavedData = True
CrystalReport1.Action = 1
End Sub

[pprabhakar]

in the crystal reports in the first menu there is an option to save records with report may be checked on..unclick it and run the show...

[E-Link]

hi there ,
try this :

CrystalReport1.ReportFileName = App.Path & "\lista de accionistas1.rpt"
CrystalReport1.RetrieveDataFiles
CrystalReport1.Destination = crptToWindow
CrystalReport1.WindowState = crptMaximized
CrystalReport1.PrintReport

[pari]

Hey!!
use
reportname.refresh property to update the contains of the report
Pari

[E-Link]

Originally posted by pari
Hey!!
use
reportname.refresh property to update the contains of the report
Pari

do u mean refresh button ?

[ritaab]

Could you give an example, please.

I don't know the reportname.refresh, but it is exactly what I want to do.