KoolReport's Forum

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

Questions about Pivot #1206

mysql pivot mysql pivot table php pivot table php pivot table mysql pivot table sql sql pivot
Closed Claudionor Silveira opened this topic on on Dec 5, 2019 - 2 comments
Claudionor Silveira commented on Dec 5, 2019

Hi,

We are starting to use pivot tables and we have some questions. Consider the image below:

1) In the green area, is it possible to remove all content generated at this location? (a blank board would be displayed)

2) Is it possible to set the style for the generated pivot table? By default this is generated as "table-bordered"

Thank you in advance.

David Winterburn commented on Dec 6, 2019

Hi Claudionor,

Regarding your questions:

  1. To hide the field zone, just add the following css rule to your page:
    .pivot-data-field-zone {
        display: none;
    }
  1. Again, you could override PivotTable's style by inspecting any of its elements and add your own in-page style. For example:
 <style>
    .pivot-table td {
        border: 0 !important;
    }
</style>

Let us know if you have any question. Thanks!

Claudionor Silveira commented on Dec 6, 2019

Hi,

This worked. For pivot-data-field-zone, instead we used pivot-data-field-content. The field zone messed with the pivot table visualization.

Thanks!

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
help needed
solved
Pivot

Designed and built with by KoolPHP Inc.

Code licensed MIT.