Win a copy of Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2 this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Bear Bibeault
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh

Jasper Reports

 
Ranch Hand
Posts: 244
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Rancher
Posts: 43024
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moved to the "Other Open Source Projects" forum, where JasperReports is discussed.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic