Check a query in the CALL command

[alinnifranca91]

I'm adjusting a custom report and when editing the command instead of a select is this function:

CALL CRSP_GLAccountStatement_BR_enUS({?FromDate}, {?ToDate})

I've never seen a query like this, could anyone help me?

[DellSC · Accepted solution]

This is calling a stored procedure from the command instead of using a Select statement.

-Dell

[alinnifranca91 · Accepted solution]

Would I be able to tweak this stored procedure? Or would it not be recommended?

[DellSC · Accepted solution]

The stored proc is not part of Crystal itself, so you should be able to tweak it. The only issue you'll run into is if you make changes to the dataset it returns - add or remove fields or change field types. If that happens, you'll need to go to Set Location in the report and set the location to the stored proc again so that Crystal will pick up the changes.

-Dell

[alinnifranca91 · Accepted solution]

Right, thank you very much