Help Please: Working with Stored Procedure in Crystal Reports...

[CrystalVisualBOracle]

Has anyone ever used an Oracle stored procedure to create a Crystal Report? I'm trying to figure out if the parameters required for the procedure always have to be the same or if they can change each time a report is generated.

For example, I have a stored procedure "Get_Users" which takes the parameter "company_id" and returns all the user information for the users who belong to that "company_id". Currently, when I go to insert the stored procedure into my report, it prompts me to enter a number value for the "company_id." It doesn't seem to allow me to set a Crystal parameter for that value. I'd like to have the report user set that company id when they execute the report each time. That way they can generate a different report for company A than company B. Is that possible?

Does this make sense? Thanks in advance!

CrystalVisualBOracle

 

[olichap]

If your stored procedure is expecting a parameter then Crystal should always prompt you for one. What happens when you click on the Refresh button? Does it not ask whether you want to use the current values or add new? It also might be that you are saving the report with the last data run, which when loaded again will default the report's data to the old value (you just need to refresh again or NOT save it with data).