Read this, it shows how to pass SQL fragments through parameters: http://jasperreports.sourceforge.net/tutorial/index.html#parameters
HTH, Lucian John Dunn wrote: > Is it possible to pass part of, or an entire SQL query string as a > parameter? > > My problem is that the SQL where clause may vary from one call of the report > to another i.e.some AND clauses may or may not be required. > > Or is the case that only values can be passed as parameters? > > > John Dunn > Product Consultant > Direct Dial +44 (0) 117 373 6122 > Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. > Tel: +44(0) 117 373 6114 > Fax: +44 (0) 117 373 6115 > > www.sefas.com > > > > > > _______________________________________________ > jasperreports-questions mailing list > jasperreports-questions@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jasperreports-questions > _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
