Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Want to display report by passing dynamic values
Migrateduser
<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>
Find more posts tagged with
Comments
There are no comments yet