KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

PivotSQL and serverPaging -> expanding issue #3311

Open Marloes opened this topic on on Jun 21 - 3 comments

Marloes commented on Jun 21

Hi there!

I have got a question. When using PivotSQL with serverPaging=true then my expanding (if present on rows and columns) won't work. In the POST (koolPivotConfig) I don't see the "name" or "row" parameters being requested and also PHP gives an error that these parameters (array keys) are missing.

When I do an uncommenting on "// if (this.serverPaging) this.config.expandTrees = {};" in the PivotMatrix.js it all seems to work again. But is that the right solution?

With kind regards, Marloes

Sebastian Morales commented on Jun 27

Thank you for your feedback. Would you pls clarify whether you commented or uncommented this line to fix the issue:

    if (this.serverPaging) this.config.expandTrees = {};
Marloes commented on Jun 27

Hi Sebastian,

Sorry, what I meant is the following.

The original line in the PivotMatrix.js is: if (this.serverPaging) this.config.expandTrees = {};

and I commented it out like this: // if (this.serverPaging) this.config.expandTrees = {};

But is that the right solution?

With kind regards, Marloes

Sebastian Morales commented on Jun 27

Thank you. We will investigate the issue and let you know the result. For now, just use your solution if it works. Rgds,

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
bug

Pivot