We have a CR11 report that prints its details in a numerical order, grouped by a string value.
At the end of each group, we need to create a page number index but the index itself is grouped differently.
So the data looks like:
{Group Header:}
Committee A
Bill 1 A Cow bill
Bill 2 Another Cow bill
Bill 3 A Dog bill
------ page 1 ------
Bill 4 Yet Another Cow bill
Bill 5 Another Dog Bill
Bill 6 A Cat Bill
Bill 7 Still Another Dog bill
------ page 2 -----
{End of Group}
{Group Footer:}
All Cat Bills
Bill 6 .................... Page 2
All Cow Bills
Bill 1 .................... Page 1
Bill 2 .................... Page 1
Bill 4 .................... Page 2
All Dog Bills
Bill 3 .................... Page 1
Bill 5 .................... Page 2
Bill 7 .................... Page 2
{Group Header:}
Committee B
...
Both group values exist in data.
We've put a subreport in the group footer, filled an array with page numbers but then how to get the data out of the array in the right order. Is there such a thing as a two dimensional array in CR11? Or are we barking up the wrong tree??
At the end of each group, we need to create a page number index but the index itself is grouped differently.
So the data looks like:
{Group Header:}
Committee A
Bill 1 A Cow bill
Bill 2 Another Cow bill
Bill 3 A Dog bill
------ page 1 ------
Bill 4 Yet Another Cow bill
Bill 5 Another Dog Bill
Bill 6 A Cat Bill
Bill 7 Still Another Dog bill
------ page 2 -----
{End of Group}
{Group Footer:}
All Cat Bills
Bill 6 .................... Page 2
All Cow Bills
Bill 1 .................... Page 1
Bill 2 .................... Page 1
Bill 4 .................... Page 2
All Dog Bills
Bill 3 .................... Page 1
Bill 5 .................... Page 2
Bill 7 .................... Page 2
{Group Header:}
Committee B
...
Both group values exist in data.
We've put a subreport in the group footer, filled an array with page numbers but then how to get the data out of the array in the right order. Is there such a thing as a two dimensional array in CR11? Or are we barking up the wrong tree??