sonnyh Posted February 15, 2007 Share Posted February 15, 2007 Hello everyone I'm new to Jasperreports and ireports. this is my problem: How do I group by more than one field (like in the report wizard)? For example, i would like to find all orders by customer, but where i have a pre-defined number of products. the products should be the columns next to the order number in the header (i know this doesn't make sense in this particular context). thanksPost edited by: sonnyh, at: 2007/02/15 00:30 Link to comment Share on other sites More sharing options...
sonnyh Posted February 16, 2007 Author Share Posted February 16, 2007 anyone? I need the outter group to be assoicated with a list of products. so when the order# changes so should the list of products. Link to comment Share on other sites More sharing options...
contentengineer Posted February 16, 2007 Share Posted February 16, 2007 If I understand your dilemma, I would suggest you use sub-report functionality to populate; else you can create multiple groups. View -> Report Groups - click on New and you can change the ordering around. It is important to ensure that your SQL returns an appropriately grouped list of results... 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