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})')

Answer 1

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})