posted 17 years ago
Hi Everyone,
I am new to Jasper reports. I am looking forward to create a Complex jasper report for my project. I have installed the Jasper Assistant for the same in my Eclipse 3.1.
Now i have the following report which needs to be generated:
REPORT as on 30-05-2006
---------------------------------------------------------------------------
| AIR Summary | DE | FR | IT | UK | TOTAL |
----------------------------------------------------------------------------
| Air Booking(s) Submitted | 1657 | 1337 | 123 | 1118 | 4235 |
----------------------------------------------------------------------------
| Air Booking(s) Settled | 1593 | 1252 | 104 | 965 | 3914 |
----------------------------------------------------------------------------
| Time Out | 0 | 1 | 0 | 8 | 9 |
----------------------------------------------------------------------------
| Price Mismatch Error | 16 | 26 | 5 | 9 | 56 |
----------------------------------------------------------------------------
This needs to be in table. I am not sure of the following things:
1. How to create table using Jasper Assistant?
2. As seen in above report each record is fetched by using different SQL query? So how can i use different SQLs in my Jasper report? How can we specify it using Jasper Assitant?
Please help me. It will be of great help.
Thanks in advance,
Saurabh
Success is not doing extraordinary things but doing ordinary things extraordinarily well.