Dynamic Where Query

[saruzzu]

I follow on forum the other topic for this problem... but nothing

 

 

i use netbeans and WHERE_PARAM for the where variable.

 

on the .jrxml file i have insert this query and this work.

Code:

	<queryString><![CDATA[sELECT
     *
FROM
     `Table`]]></queryString>

 

 

if i insert the Where param dont work

 

Code:

[code] <queryString><![CDATA[sELECT * FROM `Table` WHERE Col1=$P{WHERE_PARAM}</queryString>

 

 

sorry for my english

[Pedja]

You have to define a parameter (right click somewhere in Document structure panel -> Add -> Parameter), and then you can use it in your query.

[saruzzu]

Now create a jasper file

 

the query is Empty

 

 

I have create a variable on Java Code

 

String WHERE_PARAM;

 

and assing this variable a table value

 

 

 

How to assign the WHERE_PARAM on .jrxml?

[saruzzu]

Query .jrxml

Code:

	<parameter name="WHERE_PARAM" isForPrompting="false" class="java.lang.String"/>
	<queryString><![CDATA[sELECT
     *
FROM
   Table
WHERE
     id = $P{WHERE_PARAM}]]></queryString>

 

 

Assing Java Code

Code:

[code] String WHERE_PARAM = idName; JasperDesign jasperDesign = JRXmlLoader.load(JASPER_REPORT_FOLDER + JASPER_FILENAME + ".jrxml"«»); JasperCompileManager.compileReportToFile(jasperDesign, JASPER_REPORT_FOLDER + JASPER_FILENAME + ".jasper"«»); Class.forName(DRIVER); Connection conn = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD); JasperPrint jp = JasperFillManager.fillReport(JASPER_REPORT_FOLDER + JASPER_FILENAME + ".jasper", null, conn); JasperExportManager.exportReportToPdfFile(jp, JASPER_REPORT_FOLDER + "report.pdf"«»);

[Pedja]

Put this before you call JasperFillManager.fillReport()

 

Code:

HashMap paramMap = new HashMap();
paramMap.put("WHERE_PARAM", idName);

 

and put the paramMap in fillReport() method

 

Code:

[code] JasperPrint jp = JasperFillManager.fillReport(JASPER_REPORT_FOLDER + JASPER_FILENAME + ".jasper", paramMap, conn);

[saruzzu]

Great

 

Thx