How to group by formula

[julave]

This is my problem: I created an invoice report for a building firm, which should either be grouped by delivery ticket number, by delivery address or by building site.

how can i do this? and which formula?

in my dataset i have a field (integer) called "invoicetype" which should be decisive for the grouping field. f.e. 1 for group by deliver ticket number etc.

 

[Madawc]

In Crystal 8.5, you need to create formula field that uses one or other of the values. This can be controlled by a parameter, or by whether one field has a suitable value.

Madawc Williams
East Anglia, Great Britain