How to Refresh Crystal report
Hi
I am calling crystal report in VB6 but unable to refresh the report
If I change the table data report will not show...
Private Sub CmdPreview_Click()
Dim strRepName As String
strRepName = "Group_details.rpt"
Me.CrystalReport1.ReportFileName = App.Path & "\" & strRepName
Me.CrystalReport1.Action = 1
End Sub
Thanks
Re: How to Refresh Crystal report
How is the data being gathered for the report?
Is the report bound to a query? To a table?
Re: How to Refresh Crystal report
Make sure you're not saving your data with the report. Open the report in Crystal and go to the File menu, make sure that Save Data with Report is not checked.
Re: How to Refresh Crystal report
I'm using Crystal Report 8 and I'm not yet familiar with 9 never use it hehe, btw in 8 it got a property called "Connect" you will supply it with a connection string :
("DSN=[Server of db]";UID=[username to server];PWD=[password to server];DSQ=[database name])
with that, you're report will reflect any changes into your database..hope this help, oh and if this help holla man, because this the first time I'm helpin in this community and I just register yesterday ;=]
(RESOLVED) Re: How to Refresh Crystal report
Re: How to Refresh Crystal report
Re: How to Refresh Crystal report
I had some similar problems with Crystal Reports 10. I`ve been using the RDC component and have integrated my reports into my application. The recordsets are being fed to the report via an ADODB.Recordset object. The problem is that I haven`t found a way to refresh my data. When I refresh the Recordset object the report does not reflect the recordset changes, even when I call the refresh method of the Report.
I haven`t unchecked that Save Data with Report though. Maybe that was my mistake. So what I was doing all this time was to open all Reports in a modal form and then completely close it. Unfortunately, I`m too commited with this approach now!