Want to display report by passing dynamic values

Pranav Jain

<p>I want to pass dynamic values in my URL so i can populate the result. In my report, I have return in beforeScript :</p><p> </p><div>var store_id;</div><div>var from_date;</div><div>var to_date;</div><div> </div><div>store_id = params["store_id"].value;</div><div>from_date = params["from_date"].value;</div><div>to_date = params["to_date"].value;</div><div> </div><div>this.queryText = this.queryText+" where STORE_ID ="+store_id+" AND TRANSFER_DATE BETWEEN "+from_date::timestamp+" AND "+to_date+"::timestamp ORDER BY TRANSFER_DATE ASC";</div><div> </div><div>And in URL, I am passing request as :</div><div> </div><div><a data-ipb='nomediaparse' href='http://localhost:8080/birt/run?__report=adminMasterTransferReport_new.rptdesign&store_id=1&from_date=2014-05-08&to_date=2014-05-22'>http://localhost:8080/birt/run?__report=adminMasterTransferReport_new.rptdesign&store_id=1&from_date=2014-05-08&to_date=2014-05-22</a></div><div> </div><div>But result is not correct. If anyone can help please.</div><div> </div><div> </div>

mwilliams

<p>Try:</p><p> </p><p>this.queryText = this.queryText + " where STORE_ID=" + store_id + "and TRANSFER_DATE between '" + from_date + "'::timestamp and '" + to_date + "'::timestamp ORDER BY TRANSFER_DATE ASC";</p><p> </p><p>It was probably just a typo, but on the from_date, you had the quote ending in the wrong place. Also, I added single tick quotes around the dates. Let me know.</p>