crosstab report with multiple 'row' columns

[emrizwan]

Hi,

I want to create a cross tab report with multiple row columns as below

Student Details			Month
Student id	Student Name	class	Jan	Feb	March
1	abc	class 1	25	25	25
2	xyz	class2	25	0	0

the report is to get details of student fees which have been received every month. real report will have details of all 12 months.

I can create simple report with Student Id, Month and Amount columns but I also want other details such as student name, Class Name etc.

any ideas?

thanks

[vitaace]

Hi, maybe you can do like below. Just suggestion as i'm also new on this

1. Suppose your query should return data as below

student_id	student_name	class	month	fees
1	abc	class 1	Jan	25
1	abc	class 1	Feb	25
1	abc	class 1	March	25
2	xyz	class 2	Jan	25
2	xyz	class 2	Feb	0
2	xyz	class 2	March	0

2. In report wizard, select all fields on Fields page, then select student_id, month and fees on Group page and finish the wizard

3. Then you start creating Crosstab. Choose month for Columns. Choose student_id, student_name and class for Rows (set None for Total Position for all fields). Lastly choose fees for Measures (set Sum for calculation). 

4. Adjust the crosstab if need and you should have something like below

			Jan	Feb	March	Total
1	abc	class 1	25	25	25	75
2	xyz	class 2	25	0	0	25

 

5.  For Student Details, Student Id, Student Name, Student Class and Month column you can add static text to the report. Not sure if can add it dynamically, maybe someone here can advice.

 

Thanks ;)

 

 

[emrizwan]

Hi Vitaace,

you have mentioned to add student_id, student_name and class in the Row Group

"Choose student_id, student_name and class for Rows (set None for Total Position for all fields)."

I am using ireport version  - "Product Version: Jaspersoft iReport Designer 4.0." which only allows to choose 1 column (as shown) in the Row Group

 

 

is there any other version of ireports which allows to add more than one columns in a Row Group?

 

thanks