qinyan
asked on
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.
ASKER
Thanks for the reply! but when I did this I got a message saying a number is needed here (instead of ?Parameterfield).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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}