Skip to Content
0
Jul 28, 2023 at 08:17 PM

How to group by the value represented in the field, not the field itself in Crystal Reports

54 Views Last edit Jul 27, 2023 at 02:30 PM 2 rev

I have 10 fields in my table that represent year 1-year 10. I want to group a report by the year represented in the field, not by the field itself. For example, one result may look like this:

image.png

...and so on

The next result may be:

image.png

I want to group by the year, so that I can sum quarterly amounts for each year (i.e. 2023, 2024, etc.) This is a simple, one table report that needs to sum amounts for each quarter of each year for a couple hundred results.

I have tried creating a formula to parse out the year, but can't figure out how to group by the year value and not the field since there are 10 different year fields.

Attachments

image.png (11.1 kB)
image.png (8.9 kB)