Hello,

I am trying to create a report where the user can set a parameter for a "team" and then the report will only pull orders created by that team. The team name is not in the database, so I need the report to create the grouping.

I am very new to crystal reports so I may be missing something obvious. I have tried using if then statements in formulas to translate the parameter choice, but it is in an array format and does not like to compare to the text of the person's name. I also created groups, but I can't find any way to apply those groupings to formulas or in the select expert.

I appreciate your help.

Melissa

If i understand you corerctly you may also consider making a static parameter where you can set the value to = your DB code and the description to = your user team names (basically just translate the code to a name)

Edited by DBlank - 13 Sep 2013 at 11:54am