Using parameters with Excel worksheet

[jkeri]

I have an Excel worksheet that has a field called 'LOCATION' .   My Jasper report will read the Excel worksheet and report the contents. The report will have a paramater, P_LOCATION that the user enters a value and only those 'LOCATIONS will be reported.

 

My question is: 

 

Since there isnt any SQL query, how can I  report only the locations i need?

[szaharia]

You could use a filter expression in your dataset, like the following:

<filterExpression><![CDATA[$F{LOCATION}.equals($P{P_LOCATION})]]></filterExpression>