KoolReport's Forum

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

SQL Pivot Made Easy

Tagged topics

Trouble with building SQL statement to construct an Excel-like Pivot Table?

Making a pivot by using SQL alone is hard, we have tried before so we know how hard it is. Pivot package of KoolReport could be your solution, saving you a ton of time to construct a pivot. All you need to do is to provide a SQL query to get all your raw data and let KoolReport know which columns will be your dimension and which columns you want to aggregate. That's all. KoolReport Pivot will do the hard part to get you the right pivot table instantly.

Searching no more, you have found the best solution to create pivot table! Here are some cool pivot table examples.

Please download KoolReport and get Pivot package!

2
#1861 opened on Jan 23, 2021 by Venom with last post of Venom
1
#1859 opened on Jan 22, 2021 by Venom with last post of Venom
33
#1382 opened on Apr 10, 2020 by ankit with last post of ankit
4
#1365 opened on Mar 31, 2020 by Carl Steenkamp with last post of Carl Steenkamp
2
#1339 opened on Mar 9, 2020 by iRiyada with last post of iRiyada
10
#1267 opened on Jan 22, 2020 by prana_chak with last post of prana_chak
2
Questions about Pivot help needed solved
#1206 opened on Dec 5, 2019 by Claudionor Silveira with last post of Claudionor Silveira
5
#1063 opened on Aug 28, 2019 by Alessandro with last post of Alessandro
8
PivotTable value formatting. bug help needed solved
#905 opened on Jun 5, 2019 by Daan Schoofs with last post of Daan Schoofs
10
#727 opened on Mar 6, 2019 by Eugene with last post of Eugene
6
#345 opened on Jul 2, 2018 by shanaka perera with last post of David Winterburn
1
PivotMatrix not displayed help needed solved
#346 opened on Jul 3, 2018 by Jure Zakrajsek with last post of David Winterburn
4
#314 opened on Jun 11, 2018 by V Vijaykumarr with last post of V Vijaykumarr
2
#310 opened on Jun 11, 2018 by V Vijaykumarr with last post of V Vijaykumarr
9
#194 opened on Jan 16, 2018 by Paulo Morais with last post of KoolReport
2
#115 opened on Sep 19, 2017 by bysystem with last post of bysystem
12
#105 opened on Sep 7, 2017 by bysystem with last post of bysystem
16
#86 opened on Aug 22, 2017 by bysystem with last post of David Winterburn