Parameters

[Guest_imported]

Hi, is it possible to create a set of parameters in a parameter. Like let's say the sales division is coded by territory 21 through 50, another division is spordicatic, 57, 85, 98,, 102, 103, etc. and another is the same.
Can I create parameters so the user can select there specific group instead of making 3 different reports?

Make sense?

Thank you.

Lori

 

[Nimrauko]

Hi. Yes, but you need do this from VB. The report have a method GroupSelection, where you can determine the records you want select.

Report.GroupSelection = 'field1 IN (1,3,4)'

Report.GroupSelection = 'field1 BETWEEN 21 and 50 and field2 > 34'

I think almost exist the method RecordSelection, but i'm not sure.

 

[Guest_imported]

Just in VB?

Any other comments would be well received.

Thanks.

Lori

 

[HowardHammerman]

Is the division number one field, or is there one field for the Sales divsion and another field for other divisions?

In anycase there is no need for VB. You can create the proper logic using a paramter field and then IF..THEN..ELSE logic within Crystal. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[dgillz]

Just create a multi-value parameter field, and the user can enter as many territories as he/she likes. Then in the record selection formula, enter the following:
{territory} in {?MVparameter}

In term of "parameters within parameters" I think you are talking about default value lists. You can create a drop down list of default values to your parameter, and it works very well. However I have not tried this with Multiple value parameter fields. If you go this route and get something workable please post back.

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office