Multiple reports in a single query in jasper

[Amol More]

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

Example:
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