Passing multiple values to a report parameter from Java

Hi,

I am trying to send multiple values to a report parameter. The report parameter is of input type String and display type 'list box'. When i preview ,it works fine.But i am not able to pass the values from my java code.Does anyone know how to do this?

Find more posts tagged with

Comments

arunkumarb

Hi,

Let me clarify one doubt.

Are you constructing Report URL in your Java Class?
If so, when you are crating list box parameter there is one check box for allow multiple values so plz click on that and do not use parameter just use filter condition for that report. So that you can pass multiple values. If it is clear ok if not let me know and i will create one report with sample database.

Regards,
Arun

johnw

It needs to be passed in as a comma-seperated string. I don't remember if each value needs quotes or not...

johnw

Sorry, I had that backwards. 
 
The following will work: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
String designFIle = "C:\\Users\\jwward\\workspace\\Examples\\MultiValue.rptdesign";
EngineConfig config = new EngineConfig();
Platform.startup();
ReportEngine engine = new ReportEngine(config);

IReportRunnable reportDesign = engine.openReportDesign(designFIle);
IRunAndRenderTask runTask = engine.createRunAndRenderTask(reportDesign);

String[] values = {"V1", "V2", "V3"};
runTask.setParameterValue("ListParam", values);

PDFRenderOption renderOption = new PDFRenderOption();

renderOption.setOutputFileName("C:/TEMP/output.pdf");
renderOption.setOutputFormat("PDF");
runTask.setRenderOption(renderOption);

runTask.run();

runTask.close();

engine.destroy();
</pre>

priyanka.k

Thank you all for fast replies..

I used a filter and sent the multiple values as a comma separated string.It worked fine.Thanks.

Sahana

Hi,
I need to pass a comma-separated string as a parameter to my query. My quey looks like this
Select column1 from table1 where table1.ID in (?);
 
I need to replace this '?' with comma separated values (for ex : 2,3,5,4 like this).
 
How can I do this in birt. Please suggest me on this, a sample report would help me.
 
 
Thanks,
Shridevi