Passing stored procedure parameter to formulas, subreport in Crystal 1

[LAWagner]

I have a Crystal Reports 6.0 report with a subreport. Both access the same stored procedure which requires a date parameter be passed to it. I would like to enter this date parameter only once, and be able to use it in formulas and then pass to the subreport for its stored procedure and formulas to use.

Any suggestions?

 

[dcm]

LAWagner: Create the same named and type parameter within your Crystal Report (in v8 they are auto created when you use an sp as a datasource) David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[dcm]

If you create your stored procedure before you create your report then you should find that in v8 for instance the stored procedure parameters are automatically created as Crystal parameters as well. For earlier versions using the Database - Stored Procedure Parameters should enable you to 'match' up the sp paramaeters with those you've created in Crystal - Crystal sees the 2 similarly named parameters (1 in sp 1 in CR) as different. In your example linking @run_date of type integer created in Crystal to @run_date of type Int created as an sp parameter should enable your users to send their requests directly through to the procedure.

Hope this helps

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

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner