How to apply parameters to CSV data source

Issue [toc on_off::hide=1]

A CSV data source is not query language, so parameters cannot be used for filtering the same way they are used in an SQL query.

Solution

You can make use of <filterExpression> for data filtering. The expression should be based on fields and variables corresponding to data columns in CSV file.

For example if you have two columns in a simple CSV datasource file, Name and Value, the following would create a filter based on the Value: 

$F{Value} > 100

In TIBCO Jaspersoft^® Studio the expression can be added in the Filter Expression tab of Dataset and Query Dialog. 

More details on this can be found in section DATA FILTERS on page 104 of TIBCO JasperReports^® Ultimate Guide. The Guide is avaiable in the documentation section.