Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure Parameters.

Status
Not open for further replies.

rineen

Programmer
Aug 10, 2005
4
GB
I have a report created in CR10 based on an Oracle Stored Procedure which has several parameters. When the database location is changed the parameter prompting text is lost. From a previous post my understanding is that Crystal sees these stored procedure parameters as new when the location is changed and therefore has dropped the parameters and any text used at the previous location. I was wondering if its possible to create the parameters on a blank report before the stored procedure is linked in as the datasource, and thus when the datasource location is changed these are kept with their prompting text. I've tried to do this but so far only get duplicate parameters appearing.

Any suggestions
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top