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?
>

How to add additional functionality to parameter boxes

Is there a way to add additional functionality to the report parameter boxes?

For example, when a user enters an invalid choice into a report parameter box, I want a popup balloon that tells them to try again.

I know how to do this for a regular Winform combobox, but can I implement an interface to override the default behavior of the report parameter boxes?

Hey JordanBean... I'm trying to do the same thing. Kind of...

I also want to create a separate interface to override the default parameter behavior. I feel like there are just too many limitations on the default parameter interface.

I found out that you can set parameter values in the URL string by right-clicking on the report itself (not the parameters), click on Properties, copy and paste that URL, and you can see the parameter values embedded there. That means you could create your own interface and have it spit out its values into the URL string. The only down side is once you're there, the users don't have any more access to navigate the report pages, zoom in/out, or export to different formats. Then it basically becomes useless.

There must be a better way than this!

|||I agree. Is there not an interface that we can impelment to provide custom parameter textbox functionality?|||

The easiest way to do this is to Embed a ReportViewer control in your application and to provide a custom parameter UI. In this way, you have the ease of viewing reports without writing messy code to set URL properties, you get good debugging because you're using managed code controls. It also allows you to provide a custom parameters UI that looks and feels like it is part of the overall solution.

Hope that helps,

-Lukasz