How controls a range of dates?

I have a report that asks for two dates and wanted to control that the
difference between two dates is not superior to two months.
Exists some way to control the dates before clicking the button of "View
Report"?
Thanks,On 28 Jun., 12:18, Cetel Sistemas
<CetelSiste...@.discussions.microsoft.com> wrote:
> I have a report that asks for two dates and wanted to control that the
> difference between two dates is not superior to two months.
> Exists some way to control the dates before clicking the button of "View
> Report"?
> Thanks,
Hi
If I understand you right, I think a solution would be to make the
second date dataset dependent of the first selected date parameter.
You could use the datedif() function. In that way you only display
dates for the second date that in is the allowed range.
-Henrik.

How can I use a Date Picker in a report

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.VectorR3,

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.|||Hi,

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

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.VectorR3,

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.|||Hi,

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,|||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 ...