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:
                |  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

  • edited 12:16PM
    Cross-tab object cannot show labels, you should use separate legend.
  • edited 12:16PM
    AlexTZ wrote:
    Cross-tab object cannot show labels, you should use separate legend.

    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)
  • edited 12:16PM
    Labelling will be added later, it requires much recoding. Different formatting will be in 3.10.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.