Launching Crystal Report from Excel Form 'Kind of works'?

[Apollo6]

I have built a form with buttons that run specific Crystal reports when clicked. What is happening is that the report window comes up, processes the report, and then closes down the report window. How can keep the report from shutting down? My code is below, what's missing?


Private Sub cmdPsychology_Click()

Dim CrystalReport As Object

Set CrystalReport = CreateObject("Crystal.CrystalReport&quot
CrystalReport.ReportFileName = "d:\quarterly_reports\crystal_reports\psychology_visits.rpt"
CrystalReport.Action = 1

End Sub


Any suggestions are appreciated!

 

[Paco75]

Here is a tutorial on using crystal reports components... maybe it could help you!

http://support.crystaldecisions.com/communityCS/TechnicalPapers/rdc_tutorial.pdf

good luck

 

[Apollo6]

I'll check it out. Thanks