• Post Reply Bookmark Topic Watch Topic
  • New Topic

Multiple reports in a single query in jasper  RSS feed

Amol More
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys

i am working with jasper reports and i have requirement where i need to generate more than one report in a single select query

Table1: Car Brands (Mercedes,audi,...)

Table2: Car Model No

eg data in Table 2:

Brand ModelNo
Mercedes Merce123
Mercedes Merce468
Mercedes Merce351
Audi audi123
Audi audi864
Audi audi486

Now the query i would write in sql is

select t1.brand ,t2.modelno
from table1 t1,table2 t2
where t1.brand = t2.brand

now from this query i need to generate two reports one for mercedes and the other for audi

is there any i could try this in Jasper Reports

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!