Hi all,<br />
<br />
I am trying to add a set of date range parameters to a report but am not having much luck.<br />
<br />
I first tried using a drop down parameter, and setting the value as the relevant snippet of SQL, e.g <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>and sdate between trunc(sysdate) - 1 and trunc(sysdate) - 30</pre>
<br />
Then I would link the parameter in the report and use ? in the relevant place in the query.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
on ADSERVER.CHANNELINVENTORY.CHANNEL_ID = ADSERVER.CHANNEL.CHANNEL_ID
where CHANNEL.ACCOUNT_ID = ?
and ?
and CHANNELINVENTORY.COLO_ID = ?
order by ADSERVER.CHANNEL.CHANNEL_ID
</pre>
<br />
That gives me errors, and if I am honest I know that is probably not the best way to do it.<br />
<br />
I found this <a class='bbc_url' href='
http://www.birt-exchange.org/devshare/designing-birt-reports/857-birt-drop-down-date-range-custom-date-range-option-example-report/#description'>BIRT Drop Down Date Range / Custom Date Range Option Example Report - Designs & Code - BIRT Exchange</a>, but I cannot find the script the description refers to.<br />
<br />
In the script tab I have initialise, before/after factory/render but no beforeOpen.<br />
<br />
Thanks,<br />
<br />
D
