Data Source for GROUP BY Queries

[2006 IR Open Dicussion]

By: Muthu - muthukkumari

Data Source for GROUP BY Queries

2006-06-21 22:02

Dear All,

 

For creating groups in reports <group> tags can be used and the <querystring> containing GROUP BY can be specified in the .jrxml file and connection object can be passed to fill the report using

 

JasperFillManager.fillReport(jasperReport,parameters,con) method.

 

But if i want to give the datasource as a text file containing the data ( say CSV file,comma separated Text File).How should I provide the data in the Text file.?

 

Also if i use JOINS in my SQL and fetch the data.How should I provide the data as Text File. How do I indicate the Table name and column name in that file?