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
Way to pass parameter to report query
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I have done the following,</p>
<p> </p>
<p>1. Created a rptdesign file and configured Data source and data set.</p>
<p>2. The Data set query contains where condition, there I'm passing start date and end date.</p>
<p>EX: SELECT COUNT(*) AS NUMBER_OF_REQUESTS, DATEPART(MONTH, STARTTIME) AS MON FROM SRCH_LOG </p>
<div>WHERE START_DATE = <strong>?</strong> AND END_DATE = <strong>?</strong> GROUP BY DATEPART(MONTH, STARTTIME)</div>
<p> </p>
<p>What are the ways to pass these Start date and End date from java/jsp to report design which i configured for generating report and how?</p>
<p> </p>
<p>It'll be very helpful if you reply fast.</p>
<p> </p>
<p>Thanks,</p>
<p>Ashok</p>
<p> </p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet