jugsvn Posted May 28, 2007 Share Posted May 28, 2007 Hi All, I would like to create a jrxml using iReports where I have to show the contents like below. Agent Details Agent name: xxxxAddress: yyyyEmail: zzzz Credit Limit Limit: xxxxDate Authorized: yyyy Credit Limit History Limit | Authorized By | Date Authorized xxxx | yyyyy | zzzzzaaaa | bbbbb | ccccc Commission Amount | Calculation | Rate xxxx | PERCENTAGE | yyyyyyy | FLAT | xxx Service Charge Amount | Charge xxxx | yyyyyyy | 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. ThanksJugs Link to comment Share on other sites More sharing options...
arunvishvin Posted May 31, 2007 Share Posted May 31, 2007 Hi,Use subreports which will be very useful and ideal in your case.There are huge number of functions using the subreports and you can design it very easily and without any fuss. Report 1(Main Report)Agent DetailsAgent name: xxxxAddress: yyyyEmail: zzzz Credit LimitLimit: xxxxDate Authorized: yyyy Include the three subreports in the detail band of the Main Report. Subreport 1Credit Limit HistoryLimit | Authorized By | Date Authorizedxxxx | yyyyy | zzzzzaaaa | bbbbb | ccccc Subreport 2CommissionAmount | Calculation | Ratexxxx | PERCENTAGE | yyyyyyy | FLAT | xxx Subreport 3Service ChargeAmount | Chargexxxx | yyyyyyy | xxx Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now