Crystal Reports Paramteres

Question

My report is working in Crystal Reports designer, but when I am adding it into the Sage Sales logix it doesnt sends the parameter values to database and errors out.

I am using a command like this in the report

exec('select * from testingmyreportfunction({?Param1},{?Param2})')

craig · Answer 1 · 2013-12-27T19:24:28.993

0

Assuming that you created the parameters in command window use this query:

// Oracle
SELECT  testingmyreportfunction({?Param1}, {?Param2}) 
FROM    dual

// SQL Server
SELECT  testingmyreportfunction({?Param1}, {?Param2})

edited Dec 27 '13 at 19:24

answered Dec 27 '13 at 15:01

craig

25,664
27
119
205

No I am using SQL SERVER 2012 – RHM Dec 27 '13 at 16:31

Crystal Reports Paramteres

1 Answers1