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