Cross Tab Using Tabular Components

Posted on by By admin, in Business Intelligence, Helical Insight | 0

In some cases, there might be a scenario that we want to display the aggregated data using tabular component but look and feel wise it should look like cross-tab.

Normal Table Components












Means value of field should be printed only once for a particular bucket of data.

So in such cases, there is check-box (Print Repeated values) in Jasper Studio under appearance properties tab of text field which restricts the printing duplicate values for a field. If this check-box is unchecked only unique values will be printed for that text field.

Check box settings







In my case, I have used sample food mart database and report is showing country-wise and state-wise sales. I have created a grouping on fields country and state.

Cross tab using tabular component













Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework

In case if you have any queries please get us at


Prasad Kshirsagar

Helical IT Solutions Pvt Ltd

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments