Groups | Blog | Home
all groups > sql server reporting services > june 2007 >

sql server reporting services : How controls a range of dates?


Cetel Sistemas
6/28/2007 3:18:02 AM
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"?

Henrik
6/28/2007 11:13:02 AM
On 28 Jun., 12:18, Cetel Sistemas
[quoted text, click to view]

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.

AddThis Social Bookmark Button