Skip to Content

Grouping a Report by Order of Parameter Input

You have a report that is grouped…let’s use a group on customer name as an example. The end user has a parameter / prompt where they enter customer names. The report is also filtered on the customers entered.


The available options for a group are Ascending, Descending, Original Order, Specified Order, or by using a formula. The original order however does not give you the results you want as this done by original order from the database query.


This blog post will show you how to order the groups based on the order of values entered by the end user.




1) create a new formula named GroupingFormula with syntax similar to below.


dim i as number
i = i + 1
loop until {Customer.Customer Name} = {?Group}(i)
formula = i


2) change the formula syntax type to Basic Syntax.


3) replace the “customer name” field with the field that you want to use for your group.


4) replace the “group” parameter with the parameter that you want to use for the filter and grouping order.


5) save the formula and then go to the Change Group dialogue for the group on your report.


6) change your existing group to the new GroupingFormula you created.


7) go to the Options tab and select Customize Group Name Field. select the field that your report was previously grouped on.


8) press the OK button and your report will not be grouped in order of the values entered by the end user.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.