guillaumeharvey8 Posted August 18, 2017 Share Posted August 18, 2017 Hi, I just started using jaspersoft Studio and I'm unable to achieve the structure I need for my report. The Datasource I use contains an ArrayList of HouseholdInfo, which contains 8 strings (HouseholdId, householdAddress, name, address, city, province, postalcode and phone number)I need the data to be organise in a table in that maner:Household #1 | HHAddress Name | Address | City | Province | Postal Code | Phone Number Name | Address | City | Province | Postal Code | Phone Number Name | Address | City | Province | Postal Code | Phone Number-----------------------------------------------Empty Line-----------------------------------------------Household #2 | HHAdsress Name | Address | City | Province | Postal Code | Phone Number Name | Address | City | Province | Postal Code | Phone Number...........................................................................................................I tried multiple ways to do it in Jaspersoft Studio but I always end up printing only the household, just the customers or every customer under one household.Thanks in advance for your help. Link to comment Share on other sites More sharing options...
darth_fader Posted August 20, 2017 Share Posted August 20, 2017 you may be able to do this purely with tables:http://www.helicaltech.com/create-a-row-grouping-in-table-component-jasper-report/#.WZkaZVGGPIUBut a simpler method would be to just create a group in your report, where a group consists of the household name and address, and put your table in the detail band that displays name | address | city etc etc etc. of the people you're displaying for each household. Japser has a wizard built in when you create a new report where you can define both the query and the groups, and it will generate the code to reflect that structure Link to comment Share on other sites More sharing options...
guillaumeharvey8 Posted August 22, 2017 Author Share Posted August 22, 2017 Thanks, your answer was really helpfull :) 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