In Crystal Reports XI, you want to group by concatenated database fields, and for performance reasons, you want to push the grouping to the server. You have selected the 'Perform Grouping on Server' check box in the 'Report Options' dialog box but the grouping is still done in Crystal Reports.
In order to group by concatenated fields on the server, concatenate the fields in an 'SQL Expression Field', instead of in a 'Formula Field'. In your 'SQL Expression Field' use the SQL syntax "GROUP BY" to accomplish the grouping.
If you are using Business Views, perform the concatenation by using a SQL Expression in the Data Foundation.
Using a formula to perform the concatenation forces the execution to take place on the client machine because all the necessary data must be retrieved from the database before the formula can execute. Therefore, the grouping will be performed on the client computer even though the 'Perform Grouping on Server' check box in the 'Report Options' dialog box is selected.
To access the 'Perform Grouping on Server' check box, click 'File' > 'Report Options'.
GROUP BY CONCATENATE PERFORM GROUPING ON SERVER Crystal Reports Perform grouping on server Server-side concatenation , c2018011 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To