Dynamic Report Parameter generation

Rahul_NJ

Hi,
I would be thankful if I could get some good suggestions to approach a problem I am having. My problem is :

I have a set of input parameters for my report say :
1) Start Date and End Date
2) Start Time and End Time

and my third parameter (empId) should be dynamically generated. I will have to query a table to get the employeeIds between the above range of Start Date, time and End Date, time. Something like :

Select
empId // (Third Parameter)
From
Employee
Where
Date Between '01 Dec 2008' // (Start Date)
And '01 Dec 2008' // (End Date)
And Time Between 093000 // (Start Time)
And 093100 // (End Time)

bhanley

You can create a parametrized data set that will accept your time-based inputs as parameters. Then create your last parameter. Bind the dynamic parameter to the data set and you should be all set. Mark the parameter as hidden and the user will never see it, it will get populated behind the scenes.