report_parameter from dataset

birty

I'm designing a report to get the newest data from a db.
My SQL used in the DataSet fetches data that has been created today (select ID from table where date >= trunc(sysdate).

Means I get e.g. following data:
ID
----
12
13
15
18

Now, I want to fill a report_parameter with these IDs automatically.
Of course it's working fine when creating a parameter with combobox and set List of Value to Dynamic using the dataset, but I need this parameter to be filled automatically without prompting a combobox.

Thank u very much for ur feedback!!!

shahamar

Hi birty,

I am not much clear with your requirement. But still trying out few sugg if it works out

You might wanted to populate report parameter either to use it else where like display some where in report or in another dataset.

In first case u can iterate on ur dataset returning id instead of creating parameter.

In case of 2nd requirement you can bind ur first dataset with a list, and have a table or list with in that list with your 2nd dataset bounded. You can then pass value of first dataset in the 2nd dataset useing row.__outer.["ID"].

Not sure if this helps you.

Amar