SQL Server Stored Procs - perhaps I am slow

[dogfuel]

Hello - Using Sql Server stored procs as data provider, the below works:
 dbo.usp_RptComprehensiveLoadReport;1, '2009-Sep-20', '2009-Sep-24'

When I try to pass in Jasper parameters for the date strings (as below), I cannot even retreive field in the query window dbo.usp_RptComprehensiveLoadReport;1, $P{string_BegDate}, $P{string_EndDate} does not work (defaults are valid).nor does:
dbo.usp_RptComprehensiveLoadReport;1, '$P{string_BegDate}', '$P{string_EndDate}'

Am I missing the obvious? Error is Token Parsing Error: Lexical Error at Line 1 Column 3. Encountered "0"(48), after :"\'2" Thanks!

Post Edited by dogfuel at 09/27/2009 15:28

[dogfuel]

bump for corrections ...please help!

 

Thanks

[mdahlman]

Try this:

 

dbo.usp_RptComprehensiveLoadReport;1, '$P!{string_BegDate}', '$P!{string_EndDate}'

 

Regards,
Matt