January 31, 2012 at 3:38 am
If you have a report with a min and max date is there any way to restrict the interval to say 2 months? - So users can go as far back as they want, however, they're not able to choose dates more than 2 months within each other?
January 31, 2012 at 5:29 am
Taken a different approach to this... I setup a test SP and within the SP I calculated a date diff based on days and reset the date parameters based on its result - i.e. more than 60 days reset to 10 days something like that.
From a user perspective, however, this doesn't look obvious, so I added an expression to the title of the report calculating the same date diff and presenting a warning message if it was exceeded.
Not ideal because I'll have to change both the report and the SP if date changes are required, however, it does prevent someone running eons of data off (unless they do it loads of times in a row selecting different dates)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply