Labelling multiple sums in a crosstab
I know, I know. I should have been posting these as I found them rather than saving them up. Anyway here I am again...
In a particular dbcrosstab I have one field for the row and one for the column, but I want 4 sums in the detail (ie. 4 different sums for each row). Fine that works. But I cannot find any way to label these details, so far I have had to resort to typing a legend in at the top of the crosstab explaining what the four entries for each row are, I would prefer to be able to provide a label for each entry in the crosstab.
Example:
It is the "LabelA", "LabelB", "LabelC" things that I want.
And while we are here. The crosstab formatting seems to assume that all the totals for the cross will be using the same format (eg: all dollars or whatever). I have a crosstab where I wanted to total counts in one entry and dollars in another - but I can only apply one type of format to the Total entries. This needs to be fixed, for example the formatting for the totals could come from the sum definition entries rather than be independent.
I hope this all makes sense. If not let me know and I will try to explain further.
In a particular dbcrosstab I have one field for the row and one for the column, but I want 4 sums in the detail (ie. 4 different sums for each row). Fine that works. But I cannot find any way to label these details, so far I have had to resort to typing a legend in at the top of the crosstab explaining what the four entries for each row are, I would prefer to be able to provide a label for each entry in the crosstab.
Example:
        |  COL1  |  COL2  | Total
--------------------------------------------
   | LabelA |  0.0  |  20.1  |  20.1
ROW1 Â | LabelB | Â 10.5 Â | Â 21.1 Â | Â 31.6
   | LabelC |   15  |   50  |   65
--------------------------------------------
   | LabelA |  0.0  |  0.1  |  0.1
ROW2 Â | LabelB | Â 0.5 Â | Â 1.1 Â | Â 1.6
   | LabelC |   10  |   0  |   10
--------------------------------------------
   | LabelA |  0.0  |  20.2  |  20.2
TOTAL | LabelB | Â 11.0 Â | Â 22.2 Â | Â 33.2
   | LabelC |   25  |   50  |   75
It is the "LabelA", "LabelB", "LabelC" things that I want.
And while we are here. The crosstab formatting seems to assume that all the totals for the cross will be using the same format (eg: all dollars or whatever). I have a crosstab where I wanted to total counts in one entry and dollars in another - but I can only apply one type of format to the Total entries. This needs to be fixed, for example the formatting for the totals could come from the sum definition entries rather than be independent.
I hope this all makes sense. If not let me know and I will try to explain further.
Comments
At least I now know that I have not missed anything obvious.
A certain other report writer does support this feature - its the one I am converting over from. Not that I am regretting the move (even though rewriting so many reports has proven to be very time consuming), FastReport is really living up to its name, it is many times faster on some very large and complicated reports and the designer is very nice!
If the FR coders are watching please note the requests implicit in this posting:
* The ability to label the aggregate values in a crosstab
* The ability to have different formatting applied to each aggregate value (if there is more than one)