amit.nanote Posted May 22, 2015 Share Posted May 22, 2015 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 thousandsparam2 - report start dateparam 3 - report end dateparam 4 - Some selection valueparam 5 - some flagparam 5 - {list of ids} or {Filename}....Param 25 (CurrentTimestamp)I am seeking solution using design view.Thanks in anticipation. RegardsAmit Nanote Link to comment Share on other sites More sharing options...
hozawa Posted May 23, 2015 Share Posted May 23, 2015 Have you tried using Scriplet to read you property file and set JasperReports variables? Link to comment Share on other sites More sharing options...
amit.nanote Posted May 25, 2015 Author Share Posted May 25, 2015 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. RegardsAmit Link to comment Share on other sites More sharing options...
amit.nanote Posted May 26, 2015 Author Share Posted May 26, 2015 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?RegardsAmit Link to comment Share on other sites More sharing options...
calculate.machine Posted June 19, 2015 Share Posted June 19, 2015 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 . Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now