Stored procs?
I need a value in my report to populate from a stored proc call.
Kinda bummed out that you can only do tables and query object on the designer tool.
So anyways, I used this call in a query. My stored proc has 3 parameters... 2 to fill in, and one is a return value.
This does not return a dataset.
exec wostatus(:WONum,:Yard,:Return)
It "runs" .. but zero clue really on how to get the parameters that returned from the stored proc call to populate/work.
I'd need to read the 3rd parameter which was the return parameter.
Any ideas on this?
I don't design the database side of things of what im dealing with, so kinda working with what I got and it apparently
is fine for the Crystal Report guys.
Kinda bummed out that you can only do tables and query object on the designer tool.
So anyways, I used this call in a query. My stored proc has 3 parameters... 2 to fill in, and one is a return value.
This does not return a dataset.
exec wostatus(:WONum,:Yard,:Return)
It "runs" .. but zero clue really on how to get the parameters that returned from the stored proc call to populate/work.
I'd need to read the 3rd parameter which was the return parameter.
Any ideas on this?
I don't design the database side of things of what im dealing with, so kinda working with what I got and it apparently
is fine for the Crystal Report guys.