Jump to content
Changes to the Jaspersoft community edition download ×

Report query datasubsets crosstabs temporary table


Recommended Posts

We're converting an existing report that uses SQL to create a grouped "pivot" table which is then quickly manipulated using a single grouped report in iReport/Jasperreports.

 

(i.e. The SQL generates a temporary table with each row has the following columns:

GroupTitle|GroupLine|Month1Revenue|Month2Revenue ... |TotalRevenue)

 

to produce the follwing report:

 

Month|Month|Month| ...|Total

Group by Customer

Customer1

Customer2

Customer3

 

Group by Category

Category1

Category2

Category3

 

Group by Type

Type1

Type2

 

Group by CostCentre

CostCentre1

CostCentre2

CostCentre3

 

---

We want to migrate to crosstabs using basic underlying transaction data in a temporary table which is created from a join of six tables in a single report query.

 

Month|Customer|Category|Type|Revenue|CostCentre

 

---

Can we use report subdatasets to re-use the main query?

 

How can we cache the results from the temporary table; and re-use for each crosstab?

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

We have attempted to create crosstabs using iReport wizard... and get the following error:

 

ErrorÂfillingÂprint...ÂErrorÂincrementingÂcrosstabÂdataset

net.sf.jasperreports.engine.JRRuntimeException:ÂErrorÂincrementingÂcrosstabÂdataset ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:654)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...