Using Info Desktop to call a Crystal Report that uses a stored proc.

[buckbuck]

I can create a Crystal Report from a SQL stored procedure that uses a parameter in the query. However, when I call this Crystal Report from Info Desktop, it appears that the parameter causes NO information to be passed to Info Desktop. If I remove the parameter from the query and hardcode the value, the report in Info Desktop works. Any ideas on how to make this work using the parameter in the stored procedure?

 

[dcm]

buckbuck: In future you might find it quicker to get a response if you post in the Crystal Decisions Info forum. Your problem may be due to a number of things so check the following:

1. The parameters in your reports are named and typed the same as you stored procedure parameters.
2. Once saved to the Info desktop, check you've refreshed the report and gone through the Prompts tab to ensure that the parameters are 'visible'
3. When scheduling make sure the responses are such that a response will be forthcoming

HTH David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner

 

[buckbuck]

Thanks for your reply. It's definately your second suggestion: the Prompts tab does not have my parameters 'visible'. The only parameter that shows up is the one that was incorporated from the crystal report.

If I create a SQL stored procedure without parameters, and use Crystal to build my query with a parameter, the values are passed onto Info Desktop. But when I use a parameter in SQL, the values are not passed over. In both instances, then values are set thru: Insert - Parameter Field - Edit Parameter Field - Set Default Values.

Unfortunately, the SQL stored procedure with the parameter is the only way that creates the information I need. By using Crystal for the parameter, the query doesn't work correctly. Thanks again for your help. John.