File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes Crosstab problem details Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Crosstab problem details" Watch "Crosstab problem details" New topic

Crosstab problem details

Mainur Rahman

Joined: Aug 23, 2006
Posts: 6
I m using iReport 1.2.1 version
I want to create a simple crosstab� as like the follows

My table is as like

Date warehouse (WH) Delivery No
7/7/2006 10 10-1
7/7/2006 20 20-1
7/7/2006 20 20-2
7/7/2006 30 30-1
8/7/2006 10 10-2
8/7/2006 10 10-3
11/7/2006 30 30-2
11/7/2006 20 20-3

I want to make a report using crosstab in iReport�..

I want report will be as like

Date WH10 WH20 WH30 total delivery
7/7/2006 1 2 1 4
8/7/2006 2 0 0 2
11/7/2006 0 1 1 2

my questions are:

01. what should I do???
02. Can I use sub report in the details field of the crosstab?
03. How I count/sum the wh in the crosstab? (cause the WH is arrange as row in my database table )

I want step by step instructions
I have not clear concepts about crosstab, but I know crosstab will give the solution of this problem

Please help��

Mainur rahman
Consider Paul's rocket mass heater.
subject: Crosstab problem details
Similar Threads
Search pages shows only limited no. of rows
Breaking objects (logic puzzle, no OOP)
Crosstab in IReports
Query problem with MySQL 5
crosstab problem pls help me