hi, It is possible to pass a parameter in to your template which will run the query accordingly and fill ur report. For example: <parameter name="Flag" class="java.lang.String"/> <queryString><![CDATA[select * from ...group by $P{Flag}]]></queryString>
I hope that this is what you were looking for. Thanks -Amar -----Original Message----- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 8:02 PM To: jasperreports-questions@lists.sourceforge.net Subject: [jasperreports-questions] Dynamic grouping We have a report that is currently implemented in a different reporting product. To satisfy our user requirements we have ended up with 3 different report templates to support the 3 different grouping that can be requested. For example: One template groups by city, another by state and the final by area code. Is it possible to pass a parameter into a Jasper Report template that would allow for one template and the 3 different groupings. We would like to be able to call the report and pass in the city flag or the state flag etc. Thanks for the assistance! Doug James Software Engineer Benefitfocus.com, Inc. **************************************************************************** ************ BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. Unauthorized review, use, disclosure, or dissemination of this communication or its contents in any way is prohibited and may be unlawful. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please notify the original sender immediately by e-mail or telephone, return the original message to the original sender or to [EMAIL PROTECTED], and destroy all copies or derivations of the original message. Thank you. (BFeComNote Rev. 08/01/2005) **************************************************************************** *********** ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions