I would like to pass multiple parameters from a VB.NET application to an
existing Access 2003 application's reports (essentially using Access as a
report writer where the reports already exist).
The reports' datasource is a stored procedure with multiple @parameters.
This code works where the report requires no parameter:
Dim strAccessDBPath As String
Dim booReturn As Boolean = False
strReportName = "rptCMOTeam 1"
strAccessDBPath = "W:\Clinica l Services Database\Clinic al
Services.ade"
booReturn = OLEPreviewRepor t(strDB, strReportName)
A Microsoft example shows using a single parameter:
booReturn = OLEPreviewRepor t(strDB, strReportName),
strWhere:="Orde rId = 10251")
Would "OrderId" feed into a @OrderID parameter in a stored procedure, or is
there another way to replace the strWhere clause to feed the @parameters in
the stored procedure?
Thanks,
Dean Slindee