One dropdownlist depend from other.

Hello, I need to know how can I pass two parameters, One select depends from what I selected on the first one. I did it once but I just dont remember

You are looking for a dynamic parameter ( or dynamic dropdown) walk through or " how to".

Ill use the example of store locations and employees located in each store.

Fist what you would do is create your data sources for your drop downs

==================================== Data source "stores"

Select StoreID,

StorelocationName

From storetable

===================================

The second table will have the employee info in it . In this statement will be a parameter in the where clause the depends on the out put of the first data source

======================================== data source "employee"

select EmployeeName,

EmployeeID

from sometable

where storeID = @.storeID

========================================

after creating this data sources you will notice that a new parameter has been created in the report labeled "StoreID".

you will need to use a use the "stores" data source. Make the value field the storeID field. Do the same for the employee data source.

On the Data Tab you will see a "..." button on for each data source press it and go to the parameters tab for the data source employee. Make sure the @.storeID parameter is listed.

this should help you figure out the rest

hope it helps

One Date field with different dates

I want to search on a date field with user input. How can I make it to where
it will give user a startdate and an enddate box? Remember I have only one
date field.
SELECT COURSE_NBR, ATTEND, COMPL_DATE
FROM EH_MEMINFO_1
WHERE (COURSE_NBR LIKE @.COURSE_NBR) or
(COMPL_DATE LIKE @.COMPL_DATE)
Thanks fo ryour help.Use this:
SELECT COURSE_NBR, ATTEND, COMPL_DATE
FROM EH_MEMINFO_1
WHERE (COURSE_NBR LIKE @.COURSE_NBR) or
(COMPL_DATE BETWEEN @.StartDate AND @.EndDate)
"Shan" wrote:
> I want to search on a date field with user input. How can I make it to where
> it will give user a startdate and an enddate box? Remember I have only one
> date field.
> SELECT COURSE_NBR, ATTEND, COMPL_DATE
> FROM EH_MEMINFO_1
> WHERE (COURSE_NBR LIKE @.COURSE_NBR) or
> (COMPL_DATE LIKE @.COMPL_DATE)
> Thanks fo ryour help.|||O Thank you soo much...that solved lots of problems.
Great Daw!
"daw" wrote:
> Use this:
> SELECT COURSE_NBR, ATTEND, COMPL_DATE
> FROM EH_MEMINFO_1
> WHERE (COURSE_NBR LIKE @.COURSE_NBR) or
> (COMPL_DATE BETWEEN @.StartDate AND @.EndDate)
>
> "Shan" wrote:
> > I want to search on a date field with user input. How can I make it to where
> > it will give user a startdate and an enddate box? Remember I have only one
> > date field.
> >
> > SELECT COURSE_NBR, ATTEND, COMPL_DATE
> > FROM EH_MEMINFO_1
> > WHERE (COURSE_NBR LIKE @.COURSE_NBR) or
> > (COMPL_DATE LIKE @.COMPL_DATE)
> >
> > Thanks fo ryour help.