Results 1 to 7 of 7

Thread: How to Refresh Crystal report

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Location
    Kolkata, India
    Posts
    290

    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

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    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?

  3. #3
    Frenzied Member pnish's Avatar
    Join Date
    Aug 2002
    Location
    Tassie, Oz
    Posts
    1,918

    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.

  4. #4
    Junior Member
    Join Date
    Oct 2005
    Posts
    16

    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 ;=]

  5. #5

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Location
    Kolkata, India
    Posts
    290

    (RESOLVED) Re: How to Refresh Crystal report

    Thanks For Helping
    Asm

  6. #6
    Junior Member
    Join Date
    Oct 2005
    Posts
    16

    Re: How to Refresh Crystal report

    No problem man!

  7. #7
    Hyperactive Member divined's Avatar
    Join Date
    Aug 2004
    Location
    Thessaloniki, Greece
    Posts
    447

    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!
    SteadFast!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width