Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 6900

Aug 28th, 2008

How to load crystal Report in my Visual Basic Apllication ?

Expand Post »

Hello

I wish to call crystal report in my VB6 Application.

For showing data report i used following code ;

Example

Date report name : datareport1
Code for showing report

Load datareport1
Datreport1.show

I have crystal report named "studentregister". please explain me how can show the crystal report in my vb6 application ?

A.Senthil

imagetvr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2008

Permalink

Aug 28th, 2008

Re: How to load crystal Report in my Visual Basic Apllication ?

If crystal report is installed, then u can find the Crystal Report Viewer OCX control in VB IDE in the components. Add the crystal report control to your form and configure it to show the required report.

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
'use whatever is the path of your report
'i have assumes that the rpt file is
'in the application path itself
CrystalReport1.ReportFileName = App.Path & "\studentregister.rpt"
CrystalReport1.Action = 1
'use whatever is the path of your report
'i have assumes that the rpt file is
'in the application path itself
CrystalReport1.ReportFileName = App.Path & "\studentregister.rpt"
CrystalReport1.Action = 1

Many other properties are also available for the control like to enable print button, to export the report, navigation of pages etc.

Hope this solves ur problem

Regards
Shaik Akthar

aktharshaik

Reputation Points: 26

Solved Threads: 40

Posting Whiz

Offline

316 posts
since Aug 2008

Permalink

Aug 28th, 2008

Re: How to load crystal Report in my Visual Basic Apllication ?

Thanks Mr. Shaik Akthar

I added Crystal Report Viewer in components

I used your code to view report i got following error message.

Please help to solve

compile error
Method or Data Member not found

Thanks
senthil kumar.A

imagetvr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2008

Permalink

Aug 28th, 2008

Re: How to load crystal Report in my Visual Basic Apllication ?

use crystal report activex control not CRViewer.

Regards
Shaik Akthar

aktharshaik

Reputation Points: 26

Solved Threads: 40

Posting Whiz

Offline

316 posts
since Aug 2008

Permalink

Aug 28th, 2008

Re: How to load crystal Report in my Visual Basic Apllication ?

CRViewer can also be used, but the coding will be slightly different

Add the Crystal App references and CrViewer component in References and Components respectively.

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
'Declare these variable globally in the form module
Dim crxApp As New CRAXDDRT.Application
Dim crxReport As New CRAXDDRT.Report
'-------------------------------------------------------------------------------------
 
Private Sub cmdShowReport_Click()
 
 'Set the report object
 Set crxReport = crApp.OpenReport (App.path & "\studentregister.rpt")
 
 'Enables the Viewer's Navigation Controls
 CRViewer.EnableNavigationControls = True
 
 'Disable Group Tree
 CRViewer.DisplayGroupTree = False
 
 'Enable export button
 CRViewer.EnableExportButton = True
 
 'Disables the CRViewer's Search control
 CRViewer.EnableSearchControl = True
 
 'Set the report source
 CRViewer.ReportSource = crxReport
 
 'View the report
 CRViewer.ViewReport
 
End Sub
'Declare these variable globally in the form module
Dim crxApp As New CRAXDDRT.Application
Dim crxReport As New CRAXDDRT.Report
'-------------------------------------------------------------------------------------

Private Sub cmdShowReport_Click()

 'Set the report object
 Set crxReport = crApp.OpenReport (App.path & "\studentregister.rpt")

 'Enables the Viewer's Navigation Controls
 CRViewer.EnableNavigationControls = True

 'Disable Group Tree
 CRViewer.DisplayGroupTree = False

 'Enable export button
 CRViewer.EnableExportButton = True

 'Disables the CRViewer's Search control
 CRViewer.EnableSearchControl = True

 'Set the report source
 CRViewer.ReportSource = crxReport

 'View the report
 CRViewer.ViewReport

End Sub

Hope this helps u.

Regards
Shaik Akthar

aktharshaik

Reputation Points: 26

Solved Threads: 40

Posting Whiz

Offline

316 posts
since Aug 2008

Permalink

Aug 29th, 2008

Re: How to load crystal Report in my Visual Basic Apllication ?

Thanks a lot Mr. Shaik Akthar

Again i disturb you . I added your code but i got error message

Dim crxApp As New CRAXDDRT.Application
Dim crxReport As New CRAXDDRT.Application

Set crxReport = crApp.OpenReport(App.Path & "\studentregister1.rpt")
( here i got error message " Variable not defined ) ( crapp )

CRViewer.EnableNavigationControls = True
CRViewer.DisplayGroupTree = False
CRViewer.EnableExportButton = True
CRViewer.EnableSearchControl = True
CRViewer.ReportSource = crxReport
CRViewer.ViewReport

imagetvr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2008

Permalink

Aug 29th, 2008

Re: How to load crystal Report in my Visual Basic Apllication ?

Hi!
Just change the variable name please, i typed it wrong as crApp instead of crxApp.

(Toggle Plain Text)

Dim crxApp As New CRAXDDRT.Application
Dim crxReport As New CRAXDDRT.Application

Set crxReport = crxApp.OpenReport(App.Path & "\studentregister1.rpt")
( here i got error message " Variable not defined ) ( crapp )

CRViewer.EnableNavigationControls = True
CRViewer.DisplayGroupTree = False
CRViewer.EnableExportButton = True
CRViewer.EnableSearchControl = True
CRViewer.ReportSource = crxReport
CRViewer.ViewReport

Regards
Shaik Akthar

aktharshaik

Reputation Points: 26

Solved Threads: 40

Posting Whiz