Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use StoredProcParam

Status
Not open for further replies.

Wexus6

Programmer
Jul 18, 2000
6
US
I'm trying to use CR to generate PDF's on the fly to download from a website. I am trying to get CR to export PDF's using some COM objects that will be called from coldfusion.
I want to set the parameters for the stored procedure I'm calling but don't understand how to referance the StoredProcParam.
I'm not sure which library it belongs too. I've refenced every CR lobrary on my computer but none of the seem to be able to reference StoredProcParam.
I've tried something like:
Dim crxApplication As New CRAXDRT.Application
Public Report As CRAXDRT.Report

report.StoredProcParam

But I guess that CRAXDT is not the right library or there is something I'm just not getting.
Thanks in Advance...
Wes

 
Set CrystalReport = CreateObject("Crystal.CrystalReport")

CrystalReport.ReportFileName = "C:\Report\RPT\188.RPT"

CrystalReport.Connect = "DSN=NorthWind;UID=sa;PWD=hokawa"

RepOutFileName = "C:\Report\OUT\188.HTM"

CrystalReport.PrintFileName = RepOutFileName

CrystalReport.PrintFileType = 21

CrystalReport.Destination = 2

SPParameterCount = CrystalReport.RetrieveStoredProcParams

CrystalReport.StoredProcParam(0) = "1900-01-01 00:00:00.000"
CrystalReport.StoredProcParam(1) = "2002-01-01 00:00:00.000"

MsgBox CrystalReport.PrintReport

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top