List Box With dynamic Selection

tcskurra

I got a requirement from one of the customer to give Utilization Reports.

It should open a parameter windows which will ask for the month. The list box will prompt with last 6 months which user can select among them.

Now the next list box which will list all applications and also it has to have an option called ?All? which when selected will show the report of all applications for that particular month.


To achieve this the first parameter month I am getting it dynamically from a table. The second parameter application list box,I have selected as Static since I need ?All? as one of the list in the applications. So when defined static I took the static values from a table and also added a ?%? for the purpose of ?ALL?

But any new application adding up i am not able to show that in the report,unless i manually go and change the design again.

How do I make to more dynamic ?

Thanks in Advance.

Regards
Praveen

cypherdj

Praveen,<br />
<br />
I will assume that the list of applications is stored somewhere in your actual database.<br />
<br />
What you could simply do is to add your 'All' entry in the SQL query for your underlying data set:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
select appID, appName
from applications
union
select -1, 'All'
from dual
</pre>
<br />
Then use this data set as the dynamic values for your parameter.<br />
<br />
This way your applications parameter is always up to date and you now have a value (-1) that indicates all reports to be generated.<br />
<br />
Let me know how that works for you,<br />
Regards,<br />
Cedric