Report Parameters 1

[mondi]

Does anybody know any site that tells about the report parameters?
It would be a great help for me.
Thanx in advance.

 

[dgillz]

This site will do that. What do you want to know about parameter fields?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mondi]

yes but I can't find anything in there

 

[dgillz]

What do you want to know about parameter fields?

You ask, we answer. We do not read minds.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mondi]

Actually I want to know the basics for the parameters. Where can they be used and stuff like that.
Sorry for not being clear.

 

[dgillz]

Well, you create a parameter field by clicking on insert, field object, right click on parameter fields, then select new.

Typically they are used in record or group selection formulas to restrict the data set of your report. For instance, imagine a customer type paramter field, and the following record selection formula:

{ARCUSFIL_SQL.Cust_Type) = {?CustType}

The first field above is the database field while the second is the parameter field that you create.

I hope this helps. If you have a specific question, let me know.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mondi]

Thank you however.

 

[mbfloyd]

Hello there, I am trying to create a custom input parameter. Where I would like to be prompted for last name and all those specific last names appear on the report.

sounds simple but I'm stuck on stupid right now.

thanks in advance

 

[dgillz]

This is a 2 step process. Step 1 is to create the parameter field. Insert, field object, parameter field. Make sure the data type is text.

Stepp 2 is the record selection formula to restrict your report to only those records with a matching last name. Click on report, edit selection formula, record and enter a formula:

{LastNameField} = {?ParameterField}

Substitute your actual field names for the above 2 fields.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com