CODEWITHSUNDEEP
crystal-reportscrystal-reports-2008crosstabcrystal-reports-2010
wben
wben

Reputation: 247

How to group by two fields in crystal reports

Currently I can group just by one field not by two fields in a cross-tab

Upvotes: 1

Views: 14244

Answers (2)

Fausto Galati
Fausto Galati

Reputation: 17

You should create a formula field that concatenates the text of these two fields, then use that formula as the field that you group on.

Upvotes: 2

LittleBobbyTables - Au Revoir
LittleBobbyTables - Au Revoir

Reputation: 32680

For reports, you just select Insert > Group and add a second group. For crosstabs, just add them to the Rows section.

If you want to have two physically separate statuses ("Temporary" and "Permanent") like in the picture, you'll want two physically separate crosstabs (the second of which will need to be in a subreport).

It would be easier to have one crosstab and just add the Status to the Row section.

Upvotes: 0

Related Questions