Jasper Reports with dynamic data source

[muthuvadugan]

Hi Everyone,

This is what I have done so far.

1. Created a jasper report (without specifying the dataset/sql)

2. Executed a sql query (through jdbc) and passed the result set to a JRResultSetDataSource class and supplied the data set at runtime.

3. Successfully compiled and viewed the report.

But now I want to use some query filters which require User Inputs to be used in the filter. (Something like username = 'abc' in the where clause of the sql)

How can I make use of the report parameters before executing the sql?

 

Thanks in advance.

[Teodor Danciu]

Hi,

 

Why don't you let JR execute the query itself, but putting your query in the report template, as shown in the /demo/samples/query shipped with JR?

 

Thanks,
Teodor