postateo

I C-Box and Teaodor, Tanks for your suggestion. The Teodor way is my first idea, but seems very hard to implement. A small code example is my only hope. Thanks anyway for your time. Matteo

Many thanks for your reply I.ll try your solution. For my problem would be fine also obtain a resulset with data. Like a datatable. I need the sql for this reason. Any other suggestions ? Matteo from italy.

Hi, i need to take the resulset from report with parameters. with getquery() i get the sql text but the parameters are not compiled with data. this is my code: JasperDesign jasperDesign = JRXmlLoader.load(reportFile); JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); System.out.println(jasperReport.getQuery().getText() ); for example if my parameter is "RAGIONE_SOCIALE" and i input "MATTEO" now return: SELECT.... WHERE (RagSoc LIKE '%' + $P{RAGIONE_SOCIALE} + '%' OR $P{RAGIONE_SOCIALE} IS NULL) i want: SELECT.... WHERE (RagSoc LIKE '%MATTEO%' OR $P{RAGIONE_SOCIALE} IS NULL) Tanks in advance.