SAP Knowledge Base Article - Public

1218940 - How to force server-side grouping on concatenated fields in Crystal Reports

Symptom

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.

Resolution

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.

 

====================

NOTE:

 

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'.

 

 

 

See Also

For more iniformation, please refer to Note 1216699 and Note 1213603.  

Keywords

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

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2