can you make group selection formula function like a parameter?

I have group selection formula set up for a report (eg. show me only those groups with the value in the column '% achieved' less than 95% or greater than 105%) and the user wants to be able to change the criteria the way they want. I know I can do it in the "report - edit selection formula - group" area but the user wants to have the criteria shown on the report header section to show them what criteria they set and everytime the criteria changes what's shown on the report header should also change. I can't get this done b/c I can't make this a parameter for user to choose. If I make the "% achieved" a parameter then what's gonna change is the record value not the group value. When you talk about parameter it always affects the record right? So is there really a way to do this? Thanks very much for your help! I'm really stressed out with having to design 7 complicated crystal reports within two weeks including the part of writing stored procedures with many joins and temp tables and subqueries.
qinyanAsked:
Who is Participating?
 
frodomanCommented:
The datatypes must match so if the field in the database is numeric then the parameter field must be numeric also (which means that your users will have to enter "95" instead of "95%").  This error message sounds like the parameter field you're using is a string type.
0
 
frodomanCommented:
>>> When you talk about parameter it always affects the record right?

No, you can have a parameter that affects the group instead of the individual record (in fact you can have a parameter that doesn't affect record selection at all if you want to - to be used only in calculations perhaps, etc.)

Report -> Edit Selection Formula -> Group:  
{GroupByField} >= {?ParameterField1} AND {GroupByField} <= {?ParameterField2}
0
 
qinyanAuthor Commented:
Thanks for the reply! but when I did this I got a message saying a number is needed here (instead of ?Parameterfield).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.