KoolReport
Get Started
Examples
Documentation
Packages
KoolReport
KoolReport Pro
Home
Quick Links
Get Started
Documentation
Packages
KoolReport Pro
EXAMPLES
Introduction
Sales By Country
Sales By Customer
DataSources
Variables_based
Array
Report
Files
CSV
Excel
Big_CSV
Big_Excel
PDO
MySQL
PostgreSQL
SQLServer
Oracle
Native_databases
MySQL
PostgreSQL
SQLServer
Oracle
MongoDB
Processes
ColumnMeta
String
Number
DateTime
CalculatedColumn
Basic_Function
Meta
RowNum
Filter
Basic
"or" operators
Brackets
Function
Map
Value
Meta
Added rows
Stateful
Transpose
Basic
Columns transpose
Columns related
CopyColumn
AccumulativeColumn
AggregatedColumn
ColumnRename
ColumnsSort
DifferenceColumn
OnlyColumn
RemoveColumn
RowNumColumn
Rows related
Sort basic
Sort function
AppendRow
Limit
Shuffle
Bucket values
TimeBucket
NumberBucket
NumberRange
Values changes
DateTimeFormat
JsonSpread
StringCase
StringTrim
TypeAssure
Others
Custom
Group
Join
DataStores
Aggregated Methods
Filter Methods
Join Method
Card
Card
Table
Minimum Settings
Column Align
Footer
Header
Format Value
CSS Class
Paging
Remove Duplicate
Row Group
Google Charts
Collection
Column Chart
Bar Chart
Pie Chart
Donut Chart
Area Chart
Stepped Area Chart
Line Chart
Geo Chart
Gauge Chart
Histogram Chart
Timeline Chart
Combo Chart
Pareto Chart
Sankey
Scatter Chart
TreeMap
Color Scheme
Multi Annotation
EXTENDED PACKAGES
Amazing Theme
Introduction
Simple Card
Gauge Card
Chart Card
DualChart Card
Progress Card
ApexCharts
Chart Types
Line
Collection
Basic
Data Labels
Time Series
Annotations
Synchronized Charts
Brush Charts
Step Line
Gradient Line
Dashed Line
Missing/Null Values
Area
Collection
Basic
Spline Area
Datetime X-Axis
Negative
Github Style
Stacked Area
Irregular Timeseries
Missing/Null Values
Column
Collection
Basic
Data Labels
Stacked Column
Stacked Column 100%
Grouped Stacked
Dumbbell Chart
Markers
Group Label
Rotated Axis labels
Rotated Data Labels
Negative Values
Dynamic Loaded
Distributed Columns
Bar
Collection
Basic
Grouped
Stacked
Stacked Bars 100%
Grouped Stacked Bars
Negative Values
Markers
Reversed Bars
Custom Datalabels
Patterned
Bar With Images
Mixed/Combo
Collection
Line - Column
Multiple Y-Axis
Line - Area
Line - Column - Area
Line - Scatter
Range Area
Collection
Basic
Combo
Timeline
Collection
Basic
Custom Colors
Multi Series
Multiple Ranges
Group Rows
Group Rows - data rows to columns
Dumbbel Horizontal
Funnel
Collection
Funnel
Pyramid
CandleStick
Collection
Basic
Combo
Category X-Axis
Candlestick with Line
Box & Whisker
Collection
Basic
Boxplot - Scatter
Horizontal Boxplot
Pie/Donut
Collection
Simple Pie
Simple Donut
Donut Update
Monochrome Pie
Gradient Donut
Semi Donut
Donut with Pattern
Pie with Image
Radar
Collection
Basic
Multiple Series
Polygon-filled
Polar Area
Collection
Basic
Monochrome
RadialBars/Cirle/Gauge
Collection
Basic
Multiple
Custom Angle
Gradient
RadialBars with Image
Stroked Gauge
Semi Cirle Gauge
Bubble
Collection
Simple
3D Bubble
Scatter
Collection
Basic
Datetime
Images
HeatMap
Collection
Basic
Basic - data rows to columns
Basic - transpose
Multi-Color
Multi-Color Flipped
Color Range
Range without Shades
TreeMap
Collection
Basic
Multiple Series
Color Range
Distributed
SparkLine
Basic
Cube
Product row - Quarter column
Product row
Quarter column
Simple
Year parameter
Customers - Categories
Years - Months
SuperCube
Multi fields rows columns
Multi fields rows
Multi fields columns
Multi aggregates
Barcode
Products with Barcode
Type of Barcodes
QRCode
Cache
File Cache
Apc Cache
Mem Cache
ChartJs
Collection
Types
Column
Bar
Area
Line
Pie
Donut
Polar
Radar
Scatter
Bubble
Combo
Multi-axis
Timeline
Overlap Bar
Color Scheme
Bar
Vertical
Horizontal
Multi axis
Stacked
Stacked groups
Line
Basic
Mutli axis
Stepped
Interpolation
Line styles
Point styles
Point sizes
Area
Boundaries
Datasets
Stacked
Radar
Others
Scatter
Scatter - Multi axis
Doughnut
Pie
Polar area
Radar
Combo bar/line
Linear Scale
Step size
Min & max
Min & max (suggested)
Logarithmic Scale
Line
Scatter
Time Scale
Line
Line (point data)
Time Series
Combo
Scale Options
Grid lines display
Grid lines style
Multiline labels
Filtering Labels
Non numeric Y Axis
Toggle Scale Type
Legend
Positioning
Point style
Callbacks
Tooltip
Positioning
Interactions
Callbacks
Border
HTML tooltips (line)
HTML tooltips (pie)
HTML tooltips (points)
Scriptable
Bar Chart
Bubble Chart
Pie Chart
Line Chart
Polar Area Chart
Radar Chart
Advanced
Progress bar
Content Security Policy
ChartTable
NEW
ChartTable
Cloud Export
Header Footer
Page Break
Dashboard
NEW
Demonstration
DataGrid
DataTables
Table Paging
Table Searching
Table Sorting
Column Reorder
Fixed Order Column
Custom Type Sorting
Server Processing
Server Side Footer
Client Side Footer
Plugins
Complex Headers
Rowgroup
Rowgroup Collapse
Rowgroup Count Distinct
Rowgroup Sort Aggregate
Row Span
Row Group with Span
Fast Render
Row Detail
Row Detail Expand
D3
Collection
Column Chart
Bar Chart
Line Chart
Spline Chart
Area Chart
Pie Chart
Donut Chart
Waterfall
Funnel Chart
Excel
CSV Exportable
CSV Footer
Excel Template
Big Spreadsheet
Chart
PivotTable
PivotMatrix
Table
Table Row Group
Table Rowspan
Table Complex Header
Table Row Detail
Table Chart Column
Table Image Hyperlink
Table Column Width Row Height
Text
Image
Hyperlink
Export
PDF Exporting
Header / Footer
Custom Header / Footer
Inputs
Controls
Order List
DrillDown
DrillDown
LegacyDrillDown
CustomDrillDown
MultiView
Morris Chart
Collection
Area Chart
Bar Chart
Line Chart
Donut Chart
Hover Template
QueryBuilder
Get Started
Join Query
Pivot
Customers vs Products
Years vs Months
Customers vs Times
Pivot Extract
Aggregates Compurations
Dimensional Computations
PivotMaxtrix
Server Paging
Bun Template
Widget Options
Widget Map
Widget Field Order
PivotSQL
Sparklines
Introduction
Sparklines in DataTables
VisualQuery
NEW
VisualQuery
ADVANCED EXAMPLES
Advanced
Input & Export
Multiple Data Filters
SubReport
Ajax Loading
Async Report Loading
Home
DataGrid
DataTables's fast rendering
DataTables
How to use client-side fast rendering for nearly 30 000 rows
customerName
productLine
productName
dollar_sales