I have a parametrized report which actually uses a combo with dates to render the report. And I want to change it for a Date picker. Can I do it
Thanks in advance.
I am using MS SQL Server 2205 Developer Edition Beta 2 (September 2004 release), but I cannot see the calendar button you mentioned. Is it becuase my version is old & does not have the feature. I am selecting the parameter data type as 'datetime'. Please advice.
You can do this ins Reporting Services 2005, not in Reporting Services 2000. Go to "Reports", "Report Parameters". In here change the type on your field to a datetime field. Then when you select preview report you will see the calendar button for that parameter. You will also see it in the Report Manager when you run it.
That's right - the date picker was added after Beta 2 (from what I can recall, it first appeared in the June CTP). At this point, Beta 2 is way out of date, and you should be looking at the released version, if possible ...
How can I use a Date Picker in a report
Cameron T
I am using MS SQL Server 2205 Developer Edition Beta 2 (September 2004 release), but I cannot see the calendar button you mentioned. Is it becuase my version is old & does not have the feature. I am selecting the parameter data type as 'datetime'. Please advice.
Thanks in advance,
Matt Masson - MSFT
You can do this ins Reporting Services 2005, not in Reporting Services 2000. Go to "Reports", "Report Parameters". In here change the type on your field to a datetime field. Then when you select preview report you will see the calendar button for that parameter. You will also see it in the Report Manager when you run it.
fivefinger