|
-
Sep 15th, 2005, 03:24 AM
#1
Thread Starter
Hyperactive Member
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
-
Sep 15th, 2005, 05:23 AM
#2
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?
-
Sep 17th, 2005, 02:30 AM
#3
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.
Pete
No trees were harmed in the making of this post, however a large number of electrons were greatly inconvenienced.
-
Oct 2nd, 2005, 01:04 AM
#4
Junior Member
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 ;=]
-
Oct 4th, 2005, 12:07 AM
#5
Thread Starter
Hyperactive Member
(RESOLVED) Re: How to Refresh Crystal report
-
Oct 4th, 2005, 02:23 AM
#6
Junior Member
Re: How to Refresh Crystal report
-
Oct 4th, 2005, 03:27 AM
#7
Hyperactive Member
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|