Multiple Column Headers

[jugsvn]

Hi All,

 

I would like to create a jrxml using iReports where I have to show the contents like below.

 

Agent Details

 

Agent name: xxxx

Address: yyyy

Email: zzzz

 

Credit Limit

 

Limit: xxxx

Date Authorized: yyyy

 

Credit Limit History

 

Limit | Authorized By | Date Authorized

 

xxxx | yyyyy | zzzzz

aaaa | bbbbb | ccccc

 

Commission

 

Amount | Calculation | Rate

 

xxxx | PERCENTAGE | yyy

yyyy | FLAT | xxx

 

Service Charge

 

Amount | Charge

 

xxxx | yyy

yyyy | xxx

 

Here the problem is I need to show 3 tables of data separately and I can have only one detail band. I tried putting this all in the detail band I got everything repeated for the total number of records for all the 3 tables.

 

Can I use groups or sub-reports here?

 

I am a newbie and any help will be greatly appreciated.

 

Thanks

Jugs

[svenn]

I would use groups and subreports. Creating more then one group will open up slots for your subreports. Using separate subreports will allow you to create a subreport for each query. Sometimes when in this situation the query in my Main report will be what I call a driver query. It will contain only a few key elements. I will then use it to drive the rest of my report.