Rather than maintaining multiple reports which display the same data but are grouped by different criteria, you can allow users to select their own groupings for a single report. To allow a user to select the Sort or Group order for a report, follow the below steps:
1. Create a numeric Parameter with the available grouping choices for the report. It is recommended to use numeric values for the code.
2. Create a formula field with a "Select-Case" statement which returns the desired field based on the value selected by the user. Verify the "Case" statement always returns the same value type for all choices. Strings work best as the lowest common denominator.
3. Set the Group or Sort field to the formula field.
Parameter Example
Formula Example
Comments
1 comment
Hey Rob,
I presume you are referring to Crystal here? I think you might need to mention that and also provide a simple example.
0 upvotes
Please sign in to leave a comment.