parameter value in select expert

[BHAT100]

crystal 9.0
database : Great plains

I have set up parameter (?location). is it posible to assign value to parameter in select expert.
as below.

(?location) in [{locncode.iv40700),{locncode.iv30300)

and group by (?location)

or any idea how the inter site transfer can be handled in crystal report using great plains database

thanks

-bhat

 

[lbass]

I believe the solution was given to you in a previous thread. Use:

{?location} = {locncode.iv40700} or
{?location} = {locncode.iv30300}

You can't group on a parameter, but you could create a formula like the following:

if {?location} = {locncode.iv40700} then
{locncode.iv40700} else
if {?location} = {locncode.iv30300} then
{locncode.iv30300}

You can then insert a group on this formula. But please note that if a specific record meets the criteria for both, it will be found in the group associated with the first clause of the formula, not in both.

-LB

 

[BHAT100]

Thanks for your reply.

Sorry I am totally confused.
where this formula to be placed.

is this formula to be typed in select expert through formula editor.

{?location} = {locncode.iv40700} or
{?location} = {locncode.iv30300}

I have parameter default value set up for {?location} as locncode.iv40700.
or this default value needs to be removed


Thanks

-b

 

[lbass]

Go to report->edit selection formula->Record and enter the formula there. In 9.0 it might be report->selection formula->record.

You could populate the parameter selection list with both values. What you choose for a default depends on what you want to happen if the user doesn't actively choose either value--so what would you like to happen? Do you want all records displayed?

Also, I assumed you were allowing multiple values, since you seemed to want to group by values from more than one field.

-LB