How do I group by grouping by more than one field?

Question

How do I group by grouping by more than one field?

Navigation

#1 by (0 votes)

1

I'm making a report in FastReport that returns it demonstrates the following fields:

codigo cliente  
nome cliente  
data do atendimento  
codigo atendente  
nome Atendente  
codigo atendimento  
motivo do atendimento

And it was necessary to group the calls by the client / date / attendant showing the several calls of the same day client performed by a particular clerk grouped.

However in groupheader of fastreport it only allows you to select a single field (at least the way I know it). How do I group by more than one field simultaneously?

delphi fast-reports

asked by anonymous 28.11.2014 / 11:57

1 answer

Error editing user registry with nested_form Ng-repeat and AngularJs beginner error

score 0 · Accepted Answer

A simple alternative is to create a Field that is the concatenation of the information that you need to group. For example:

cast(Cliente || Data || Atendente as varchar(100)) as agrupa

Then in the groupheader you group by field agrupa .