BIRT - accessing JSP birt:param in scripted datasource open method

muthuvel

<div>I am having a JSP page, which is calling BIRT report , this report is based on java-script based Scripted data-source.</div>
<div> </div>
<div>I am passing 2 birt:param to this report ,as shown below</div>
<div> </div>
<div><span style="margin:0px;color:rgb(125,39,39);"><birt:viewer</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(230,67,32);">id</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"birtViewer"</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(230,67,32);">reportDesign</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"test_report.rptdesign"</span><br><span style="margin:0px;color:rgb(230,67,32);">pattern</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"frameset"</span><br><span style="margin:0px;color:rgb(230,67,32);">height</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"500"</span><br><span style="margin:0px;color:rgb(230,67,32);">width</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"800"</span><br><span style="margin:0px;color:rgb(230,67,32);">scrolling</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"yes"</span><br><span style="margin:0px;color:rgb(230,67,32);">showParameterPage</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"false"</span><span style="margin:0px;color:rgb(125,39,39);">></span><br><br><span style="margin:0px;color:rgb(125,39,39);"><birt:param</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(230,67,32);">name</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"startdate"</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(230,67,32);">value</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"20/06/2016"</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(125,39,39);">></birt:param></span><br><span style="margin:0px;color:rgb(125,39,39);"><birt:param</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(230,67,32);">name</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"enddate"</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(230,67,32);">value</span><span style="margin:0px;color:rgb(48,51,54);">=</span><span style="margin:0px;color:rgb(15,116,189);">"20/06/2016"</span><span style="margin:0px;color:rgb(48,51,54);"> </span><span style="margin:0px;color:rgb(125,39,39);">></birt:param></span><br><br><span style="margin:0px;color:rgb(125,39,39);"></birt:viewer></span></div>
<div> </div>
<div> </div>
<div><span style="margin:0px;color:rgb(125,39,39);">I wanted to access birt:param startdate and enddate in open Method of my data-set, I tried to access it using params["startdate"] and params["enddate"] as shown below, but the report is not working and giving below exception</span></div>
<div> </div>
<div><span style="margin:0px;color:rgb(125,39,39);">org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</span></div>
<div> </div>
<div>
<div> </div>
</div>
<div>importPackage(Packages.com.test);</div>
<div> </div>
<div>var client = new JavaClient();</div>
<div> </div>
<div>var st = params["startdate"];</div>
<div>var ed = params["enddate"];</div>
<div> </div>
<div>var myData = client.executeBusiness(st,ed); </div>
<div> </div>
<div>
<div>if I give a hard coded value for executeBusiness without params["startdate"] & params["enddate"] , it is working and giving result.</div>
<div> </div>
<div>I tried to add startdate and enddate as Input param in the dataset, But no luck.</div>
<div> </div>
<div>Also tried to access startdate and enddate as inputParams as shown below , But still getting error while generating report.</div>
<div> </div>
<div>
<div>var st = inputParams["startdate"];</div>
<div>var ed = inputParams["enddate"];</div>
<div>var myData = client.executeBusiness(st,ed);</div>
<div> </div>
<div>can somebody suggest a solution for, how to access birt:param values in scripted datasource open method.</div>
<div> </div>
</div>
</div>
<p> </p>

Clement Wong

<p>Did you try <span style="font-family:'courier new', courier, monospace;"><strong>params["yourParameterName"].value</strong></span>?</p>
<p> </p>
<p><u><strong>TIP:</strong></u><strong>  </strong><em>When you are writing event code in the Eclipse script panel, you can click on the "Palette" tab default is upper left next to Data Explorer, and Resources.  Then Expand "Report Parameters" to see your list of parameters.  You can drag that parameter over from the Palette pane to your code and it will create the correct reference for you.</em></p>
<p> </p>
<p><em>You can see that you have quick access to see the Native JavaScript Functions and BIRT Functions, etc...</em></p>
<p> </p>
<p> </p>
<p>Also, what data type is your parameter (date, datetime, string)?  You should debug the output the parameter values to validate that it is in the correct format that your code is expecting.</p>