I'm using product version 11.5
I've read thread after thread about how CR will not calculate a summary of a summary. But I'm still hopeful there is a solution to my problem be it a table, running total, sub report, or something else.
This is how the data appears on my report:
PR1949
The PR numbers are groups. So, group PR1949 has 3 records while the other two groups have 1 record each.
In the header of the report, I'd like to produce a summary of IN records that looks like this:
PRs with 1 IN: 2
PRs with 3 IN: 1
I've read thread after thread about how CR will not calculate a summary of a summary. But I'm still hopeful there is a solution to my problem be it a table, running total, sub report, or something else.
This is how the data appears on my report:
PR1949
IN19717
IN19638
IN20056
PR1950IN19687
PR1951IN19708
The PR numbers are groups. So, group PR1949 has 3 records while the other two groups have 1 record each.
In the header of the report, I'd like to produce a summary of IN records that looks like this:
PRs with 1 IN: 2
PRs with 3 IN: 1