Crosstab rows label

[StudioUser_100]

I have a table in my db with three columns country, weight and cost. I cannot edit my table neither add another table. I add my data in jasper studio and i set the following as a data query:

SELECT COUNTRY, SUM(WEIGHT) AS WEIGHT, SUM(COST) AS COST FROM MY_TABLE, GROUP BY COUNTRY;

I want to create a crosstab with the countries as column header and weight, cost as rows. How can i achieve this? 

	Country 1	Country 2
Weight	100123.22	12123.2
Costs	111.213	123123.1

 

[vitaace]

Hi, 

you can refer my suggestions on below page. Thanks ;)

 

http://community.jaspersoft.com/questions/847911/crosstab-report-multiple-row-columns