How to call a Crystal Report from a VB6.0 Application

[Guest_imported]

I have a report created in CR 8.0 (COE.RPT). I would like to be able to call this with a command button on a form in my Visual Basic application. Can someone please advise me what the code would look like for this button. The report is going to be located in the same path as the application. Thanks in advance for helping this newbie out.

Austin

 

[balves]

Go to

http://support.crystaldecisions.net/

and type "Visual Basic Examples" to Ask Jeeves. There's a large number of example files on the site. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[Vandita]

Place the crystal report component on your form and name it as crystalreport1

write the code on click on command button as

CrystalReport1.Connect = ' Path for connecting

Dim strsql As String
strsql = "select * from table1 "

CrystalReport1.SQLQuery = strsql
CrystalReport1.ReportFileName = App.Path "\reports\reportname.rpt"
CrystalReport1.Destination = crptToWindow
CrystalReport1.WindowState = crptMaximized
CrystalReport1.Action = 1
I hope this will solve your purpose.