show data vertically as well as horizontally

[rvijaysubs]

Hi,

I get the data from the SQL query in the following manner -

 

ORDER_ID	SCHEDULED_DATE	FREQUENCY_TIME	ADMINISTERED_BY
1	10/10/2009	12:00	P1
1	10/10/2009	1:00	P2
1	10/10/2009	2:00	P3
1	10/10/2009	3:00	P4
1	10/11/2009	12:00	P5
1	10/11/2009	1:00	P6
1	10/11/2009	2:00	P7
1	10/11/2009	3:00	P8
3	10/12/2009	2:00	P1
3	10/12/2009	4:00	P2
3	10/12/2009	6:00	P3
3	10/12/2009	8:00	P4

I want to show it in the following manner -

 

		10/10/2009	10/11/2009
1	12:00	P1	P5
	1:00	P2	P6
	2:00	P3	P7
	3:00	P4	P8
3	2:00	P1
	4:00	P2
	6:00	P3
	8:00	P4

I have made 1 report and 1 subreport. In the main report, i made the Column 1 and Column 2. Column 3, 4 and onwards depend upon the data. So, for them, I made a subreport. The problem I am facing is that the the data (P1, P2 and others) are not coming horizontally.

I have attached the jrxml files. If I am not clear with my question, could you provide with any suggestions on how I could get the desired table structure.

Thanks.

Vijay.

Post Edited by rvijay17 at 10/26/2009 13:32

Post Edited by rvijay17 at 10/26/2009 13:34

[rushit]

Why dont you try Crosstabs. You can have multiple grouping in rows and keep only date in the columns. display ADMINISTERED_BY as in your measure.