zz815

Hi All,

I figured out a way close to what but still not function properly.

Here's what I got for the parameter property:

Year:

Data Type is integer,

available value for non-queried is from 1995 - 2010,

default value = null

DateStart:

Data type is Datetime

available value is blank

default value = cdate("1/1/' & parameters!year.value)

DateEnd:

Data type is Datetime

available value is blank

default value = cdate("12/31/' & parameters!year.value)

Now if I add an extra parameter after year and set the available value as Parameters!year.value, and default value = parameters!year.value. then DateStart and DateEnd's default value will change base on the selection of the year and the calendar is showed.

Now the problem is I can not hide the parameter that I have added, If I do that again the whole thing is not function the way I want. It looks weird if I show an extra parameter on the report.

Any hint will be every appreciated.

Sue

Hi,

I have problem to pass a value from one parameter to other parameters in my report.

In my report I have 3 parameters, year as integer, DateStart as datetime, DateEnd as datetime.

Is anyone know how to set the display value of the Datestart as (1/1/selectedyear) and DateEnd (12/31/selectyear) bases on the selection of the year and the calendar control will show next to the DateStart and DateEnd

btw, I am using SSRS 2005 reporting services.

Thanks for your help.

Sue