sql server reporting services: To add date ctrls in Reports for providing Parameters in View Repo -- sql server reporting services

Re: To add date ctrls in Reports for providing Parameters in View

Sarath
2/20/2006 9:45:27 AM

Is this date picker available with RS 2000 edition?

Thanks,
Sarath

[quoted text, click to view]

Re: To add date ctrls in Reports for providing Parameters in View Repo

Bruce L-C [MVP]
2/20/2006 11:11:55 AM

Add a parameter to your query. RS automatically creates a report parameter.
If the report parameter is considered text then you need to change it to be
of date type.

So, first, have a parameter in your query:

select myfield from mytable where somedatefield > @DATEPARAMNAME

Next, go to layout view. Report Menu->Report Parameters. Change the data
type to date. You will now have a date picker (if RS 2005 is being used).

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: To add date ctrls in Reports for providing Parameters in View

Bruce L-C [MVP]
2/20/2006 12:46:09 PM

No. If you define the report parameter as of date type then the Report
Manager UI will enforce that only valid date/times are entered but there is
no datepicker.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.