PDA

Click to See Complete Forum and Search --> : How to Refresh Crystal report


asm
Sep 15th, 2005, 03:24 AM
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

Hack
Sep 15th, 2005, 05:23 AM
How is the data being gathered for the report?

Is the report bound to a query? To a table?

pnish
Sep 17th, 2005, 02:30 AM
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.

Dodie
Oct 2nd, 2005, 01:04 AM
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 ;=]

asm
Oct 4th, 2005, 12:07 AM
Thanks For Helping
Asm

Dodie
Oct 4th, 2005, 02:23 AM
No problem man!

divined
Oct 4th, 2005, 03:27 AM
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!