pivotmatrix subreport

R

Ralf Föhring commented on Sep 19, 2019

Hello,

is there any way I can click on an agregated value in a pivot matrix/table and use that data to run a subreport? I suppose there should be some events that are triggered, the same as in drilldown charts. Or at least a way to wrap each agregated value inside an html element and store there the parameters for subreport.

R

Ralf Föhring commented on Sep 23, 2019

Are there really no solutions to the problem described above?

D

David Winterburn commented on Sep 23, 2019

Hi Ralf,

At the moment we haven't implemented click/select events for PivotMatrix yet. In the meantime you could check our map property to get all information for each aggregated cell:

https://www.koolreport.com/docs/pivot/pivottable_and_pivotmatrix/#properties-map-(version-%3E=-5.0.0)

An example value for a $cellInfor is:

{
    "row": {
        "customerName": {
            "childOrder": "3",
            "value": "Auto Canal+ Petit",
            "numChildren": 1,
            "numLeaf": 1
        },
        "productLine": {
            "value": "{{all}}",
            "total": true,
            "numChildren": 1,
            "numLeaf": 1,
            "level": 2,
            "childOrder": 1
        },
        "productName": {
            "value": "{{all}}",
            "total": true
        },
        "hasTotal": true,
        "fieldOrder": 0
    },
    "column": {
        "orderYear": {
            "numChildren": 2,
            "numLeaf": 2,
            "childOrder": "1",
            "value": 2004
        },
        "orderMonth": {
            "childOrder": "1.1",
            "value": "{{all}}",
            "total": true,
            "numChildren": 2,
            "numLeaf": 2,
            "level": 1
        },
        "hasTotal": true,
        "fieldOrder": 0
    },
}

Let us know if it could help your case. Thanks!

KoolReport's Forum

Pivotmatrix subreport #1093

Build Your Excellent Data Report