How can i pass a .txt file as parameter to Jasperreport at Eclipse

[amit.nanote]

Hi, 

I am using eclipse integrated JasperStudio. 

My requirement is to provide a file or say list of parameters to jasperreport in which one parameter can have multiple values or file location holding those values e.g. 

param1 - {list of ids} or {Filename with its respective location} --> file having list of ids in thousands

param2 - report start date

param 3 - report end date

param 4 - Some selection value

param 5 - some flag

param 5 - {list of ids} or {Filename}

....

Param 25 (CurrentTimestamp)

I am seeking solution using design view.

Thanks in anticipation. 

 

Regards

Amit Nanote

 

 

[hozawa]

Have you tried using Scriplet to read you property file and set JasperReports variables?

[amit.nanote]

Thanks Hozawa.  

Is there any other way to pass the parameter file, with Jaspersoft Design view. I donot want to go with scripting kind of thing, if possible. 

Regards

Amit

[amit.nanote]

Hi All, 

 

Can we treat that parameter file as datasource and use a data connection to call that datasource in our current to report. for eample - there is a data souce params which have the paramters in a xls or csv file. 

 

Our report "samplereport.jrxml" have to use that data adpater to use above mentioned data source to use all the listed parameters in current report. Say params.xls file having list of ids, start date, end date etc. can we access these parameters as params.record1 or params.recordx to use them in current report. 

If yes. How?

Regards

Amit 

[calculate.machine]

The source data has two parts: the databases and the files. Here the requirement is to parse data dynamically and then perform database query by referencing file names through a parameter. I suggest using esProc to assist the coding work. You can find details from http://blog.raqsoft.com/?p=4243 .