<p>[color=rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;]I want to pass the parameters in the URL of the BIRT Report. In my reports there are 3 parameters like StoreId, fromdate and todate. I have also tried to write the code of beforeOpen Script of my dataSet in the Birt. Its is as :[/color]</p><p> </p><p>var store_id;<br />
var from_date;<br />
var to_date;<br />
<br />
store_id = params["Store_id"].value;<br />
from_date = params["fromdate"].value;<br />
to_date = params["todate"].value;<br />
<br />
this.queryText = this.queryText+" where STORE_ID = "+store_id+" AND TRANSFER_DATE BETWEEN "+from_date+" AND "+to_date+ "ORDER BY TRANSFER_DATE ASC";</p><p> </p><p>[color=rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;]And i wrote my URL as :[/color]</p><p> </p><p>[font="Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;"]<a data-ipb='nomediaparse' href='
http://localhost:8080/birt/run?__report=adminMasterTransferReport_new.rptdesign&Store_id=1&fromdate=2014-04-26&todate=2014-06-06'>http://localhost:8080/birt/run?__report=adminMasterTransferReport_new.rptdesign&Store_id=1&fromdate=2014-04-26&todate=2014-06-06</a>[/font]</p><p> </p><p>[color=rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;]At the end of the report I am getting such error :[/color]</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">The following items have errors:</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">ReportDesign (id = 1):<br />
+ There are errors evaluating script "var store_id;<br />
var from_date;<br />
var to_date;<br />
<br />
store_id = params["Store_id"].value;<br />
from_date = params["fromdate"].value;<br />
to_date = params["todate"].value;<br />
<br />
this.queryText = this.queryText+" where STORE_ID = "+store_id+" AND TRANSFER_DATE BETWEEN "+from_date+" AND "+to_date+ "ORDER BY TRANSFER_DATE ASC";<br />
<br />
<br />
<br />
":<br />
Fail to execute script in function __bm_beforeOpen(). Source:<br />
<br />
" + var store_id;<br />
var from_date;<br />
var to_date;<br />
<br />
store_id = params["Store_id"].value;<br />
from_date = params["fromdate"].value;<br />
to_date = params["todate"].value;<br />
<br />
this.queryText = this.queryText+" where STORE_ID = "+store_id+" AND TRANSFER_DATE BETWEEN "+from_date+" AND "+to_date+ "ORDER BY TRANSFER_DATE ASC";<br />
<br />
<br />
<br />
+ "<br />
<br />
A BIRT exception occurred. See next exception for more information.<br />
Report parameter "Store_id" does not exist..</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">[color=rgb(68,68,68);font-size:13px;]Main problem is like, its not able to run the script don't know why. Is there any other steps I need to do in eclipse. I have not passed any of the parameters after my select statement and also not using any of the report parameters. Just wrote the above script and apended in the URL. Need help !!![/color]</p><p> </p>
