Error linking a report with a stored procedure

R

Ron

Hi,

I'm getting an error with my report but I just cannot find the matter with
it and I was wondering if someone can help me out.



The report is linked via a dialog form to a stored procedure in which the
Sdate is BETWEEN @StartDate AND @EndDate. Running the query on its own works
and so does the form. The report halts with the following error: Erroneous
parameter error '@StartDate'.



The Input parameter on the report is set to:



@StartDate datetime= Forms![frmDialog]![StartDate], @EndDate datetime=
Forms![frmDialog]![EndDate].



How can I troubleshoot the problem or catch the results so I can see why it's
failing?

TIA

Ron
 
Top