How to add Combo box or dropdown List for picking month,Day and Year,Seperately as a Repor

If Anyone konws that :
How to add Combo box or dorpdown list for date picking option as three
different boxes are to be used for Month, Day & Year OR Any other
way of picking date in Sql Server 2000 Reporting Services as a Report
Parameter?Look for dependent or cascading parameters concept in RS 2000. You'll want
the year to be the first parameter though so you can control leap years for
the days value (for Feb).
The other way you could implement date selection is to get a distinct list
of dates from your transactions you're querying and let the user select from
those. This however, may not be viable if you're working with a large
database.
-Tim
<ajmera.puneet@.gmail.com> wrote in message
news:1153136865.596528.34410@.b28g2000cwb.googlegroups.com...
> If Anyone konws that :
> How to add Combo box or dorpdown list for date picking option as three
> different boxes are to be used for Month, Day & Year OR Any other
> way of picking date in Sql Server 2000 Reporting Services as a Report
> Parameter?
>|||Tim Dot NoSpam wrote:
> Look for dependent or cascading parameters concept in RS 2000. You'll want
> the year to be the first parameter though so you can control leap years for
> the days value (for Feb).
> The other way you could implement date selection is to get a distinct list
> of dates from your transactions you're querying and let the user select from
> those. This however, may not be viable if you're working with a large
> database.
> -Tim
> <ajmera.puneet@.gmail.com> wrote in message
> news:1153136865.596528.34410@.b28g2000cwb.googlegroups.com...
> > If Anyone konws that :
> > How to add Combo box or dorpdown list for date picking option as three
> > different boxes are to be used for Month, Day & Year OR Any other
> > way of picking date in Sql Server 2000 Reporting Services as a Report
> > Parameter?
> >
Thanks Tim...
One more thing , How to get an input value in database (or as a
parameter Value field) for Year, Month and Day(That menas should I
enter it manually....) for picking it?|||> Thanks Tim...
> One more thing , How to get an input value in database (or as a
> parameter Value field) for Year, Month and Day(That menas should I
> enter it manually....) for picking it?
>
You could use a user defined function to return the values, you could enter
them manually in a list, you could write a stored procedure to return them,
etc. etc.
If you don't care if the user selects an invalid date, the simplest method
is to create the parameters, then enter name/value pairs for them in the
parameer dialog box. Jan = 1, Feb = 2, Mar = 3, ... Dec = 12, Then 1-31 for
day and whatever years you want to allow the user to select. This is the
fastest, but not the best solution since your users could select an invalid
date (such as Feb 31, 2005).
<ajmera.puneet@.gmail.com> wrote in message
news:1153142816.399046.24400@.75g2000cwc.googlegroups.com...
> Tim Dot NoSpam wrote:
>> Look for dependent or cascading parameters concept in RS 2000. You'll
>> want
>> the year to be the first parameter though so you can control leap years
>> for
>> the days value (for Feb).
>> The other way you could implement date selection is to get a distinct
>> list
>> of dates from your transactions you're querying and let the user select
>> from
>> those. This however, may not be viable if you're working with a large
>> database.
>> -Tim
>> <ajmera.puneet@.gmail.com> wrote in message
>> news:1153136865.596528.34410@.b28g2000cwb.googlegroups.com...
>> > If Anyone konws that :
>> > How to add Combo box or dorpdown list for date picking option as three
>> > different boxes are to be used for Month, Day & Year OR Any other
>> > way of picking date in Sql Server 2000 Reporting Services as a Report
>> > Parameter?
>> >
>
> Thanks Tim...
> One more thing , How to get an input value in database (or as a
> parameter Value field) for Year, Month and Day(That menas should I
> enter it manually....) for picking it?
>