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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

?Parameters from Formulas

Status
Not open for further replies.

miked123

Programmer
Nov 9, 2001
38
US
1. I need to pass a formula to CR.
2. Parse the formula so that 4 parameters are initalized from within the formula.

I can only pass multiple parameters in this manner or a table since I'm using a Tool that restricts passing multi parameters.

I need to know the syntax of assigning a value to a ?parameter object.

This does not work when assigned in a formula:
?parameter1=@status

I actually pass the parameters in a table that is linked by the userID.
Thanks
 
I've used Crystal for over six years and have never seen a way to do this. I've just tried the following but they fail.

1. Inserting the 'BeforeReadingRecords' clause to the formula assigning a value to the parameter field
2. Using 'WhileReadingRecords' (just in case)

The error messages seem to indicate that you simply cannot assign a value to a parameter field! Steve Phillips, Crystal Consultant
 
Steve,
I have it working passing one parameter and a formula that sets 3 other criteria in the report.

The draw back is you have to close and go back to the calling app to reinitalize the 3 formulas, the re-open the reports again.

I know this is a problem in our tool, but I'm looking for a quick fix/workaround.

Thanks for the effort.
MikeD
Mike Davis
MSsql, VB and Crystal Reports Developer
 
A parameter can't get it's input from a formula. It can ask you for input or you can pass the parameter value directly from the application.
Do you have to use a parameter?
What are you using the parameter to control in the report? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top