Refreshing Crystal Rpt

Printable View

Aug 26th, 2003, 11:00 AM
Jefftopia

Refreshing Crystal Rpt
I use Crystal Rpt 8.0 via the Report Design Component in Visual Basic 6.

I am using the following method for calling up my reports:
VB Code:
```
With frmRptView
        .Show
        .CRViewer1.ReportSource = rptPrimDls3
        .CRViewer1.ViewReport
    End With
```
frmRptView is a form I use to call up all of my reports. The only thing on it is the CRViewer1 control.

My problem is that the report is not refreshing accordingly. If the user makes a change to the underlying table, which the report is based on, and then goes into view the report the change will not be reflected. It is only after the user exits the application and returns that the change will appear in the report.

Note: Doesn't seem to matter if I have the report set to 'Verify on Every Print' or not.

Thnx
Aug 27th, 2003, 11:56 AM
ARPRINCE
Have you tried adding....
VB Code:
```
crviewer1.refresh
```
if that does not work, try modifying the method you use to call your report. Usually, in all reports that "I" have encountered so far, you have this part (see 2 lines below) inside the form - frmRptView (Form_LOAD) itself. If you have it already, then try removing the 2 lines in your code.
VB Code:
```
.CRViewer1.ReportSource = rptPrimDls3
.CRViewer1.ViewReport
```
In my case, I usually just call the form and the report comes up.
VB Code:
```
frmRptView.Show 'YOU WILL BE LOADING THE FORM TO BE VIEWED ON THE SCREEN. ALL 
'CRYSTAL RELATED EVENTS SHOULD BE PLACED 
'OR INITIALIZED WITHIN THE FORM ITSELF.
```
Aug 27th, 2003, 04:42 PM
Jefftopia

Refresh Method

I tried adding CRViewer1.Refresh as suggested and received a Run-time error: Method 'Refresh' of object 'ICrystalReportViewer3' failed.

Until I can figure something else out, I set EnableRefresh button property to True. Now my users will have to use this button to update their report. Why can't I do what this button in Crystal Reports is doing in vb?
Aug 27th, 2003, 05:55 PM
VB4fun

not quite sure here...

is this a typo ?

Quote:

object 'ICrystalReportViewer3'

do you somehow have more than one object on the page? Because everywhere else I am seeing CrystalReportViewer1...
Aug 27th, 2003, 11:23 PM
brucevde

ICrystalReportViewer3 is a Crystal COM object.

These types of errors are usually caused by an invalid installation or corrupt registry. One or more of the crystal dlls may not have registered properly or could be the wrong version.

I am suprised the Refresh button on the Viewer control works.
Oct 14th, 2004, 06:35 PM
Avatarp

...

I get the same error when I try to refresh my Viewer programmatically

Code:

CRViewer1.Refresh

so where is the solution for this issue?
Oct 14th, 2004, 08:14 PM
RobDog888

See this other thread that I answered.

CR Refresh
Dec 1st, 2005, 01:48 AM
tommygrayson

Re: Refreshing Crystal Rpt
Quote:
Originally Posted by Jefftopia

I use Crystal Rpt 8.0 via the Report Design Component in Visual Basic 6.

I am using the following method for calling up my reports:

VB Code:

With frmRptView
.Show
.CRViewer1.ReportSource = rptPrimDls3
.CRViewer1.ViewReport
End With

frmRptView is a form I use to call up all of my reports. The only thing on it is the CRViewer1 control.

My problem is that the report is not refreshing accordingly. If the user makes a change to the underlying table, which the report is based on, and then goes into view the report the change will not be reflected. It is only after the user exits the application and returns that the change will appear in the report.

Note: Doesn't seem to matter if I have the report set to 'Verify on Every Print' or not.

Thnx
:wave: :wave: :wave:

Try using CRViewer1.RecordSelectionFormula on your parameter so that every time a user presses the refresh button the report will look to the valu in the recordselectionformula.
Dec 10th, 2005, 03:16 AM
fabehamobile

Re: Refreshing Crystal Rpt
you can refresh your report by closing the odbc connection before calling this code.
Quote:
Originally Posted by Jefftopia

I use Crystal Rpt 8.0 via the Report Design Component in Visual Basic 6.

I am using the following method for calling up my reports:

VB Code:

With frmRptView
.Show
.CRViewer1.ReportSource = rptPrimDls3
.CRViewer1.ViewReport
End With

frmRptView is a form I use to call up all of my reports. The only thing on it is the CRViewer1 control.

My problem is that the report is not refreshing accordingly. If the user makes a change to the underlying table, which the report is based on, and then goes into view the report the change will not be reflected. It is only after the user exits the application and returns that the change will appear in the report.

Note: Doesn't seem to matter if I have the report set to 'Verify on Every Print' or not.

Thnx