Couldn't you make these cascading parameters? change the order of the parms
(ie put 'To' first) and then populate From using a dataset that uses the
value in the 'To' field as a parameter (that is used in the where clause,
along the lines of .... WHERE DATEDIFF(dd, @To_Date, <some_date>) <= 30 and
<some_date> < @To_Date
Steve.
[quoted text, click to view] "Ravi R" wrote:
> I think that amounts to parameter validation and dont think is possible
> with this version and SP of RS.
> I have faced similar issues but have built in some default behavior
> when a user enters invalid dates etc..
>
> donno how much this helps your cause though...
>
> Ravi
>
You can build a custom .aspx web page front end to accomplish this.
[quoted text, click to view] "stevefromoz" wrote:
> Couldn't you make these cascading parameters? change the order of the parms
> (ie put 'To' first) and then populate From using a dataset that uses the
> value in the 'To' field as a parameter (that is used in the where clause,
> along the lines of .... WHERE DATEDIFF(dd, @To_Date, <some_date>) <= 30 and
> <some_date> < @To_Date
> Steve.
>
> "Ravi R" wrote:
>
> > I think that amounts to parameter validation and dont think is possible
> > with this version and SP of RS.
> > I have faced similar issues but have built in some default behavior
> > when a user enters invalid dates etc..
> >
> > donno how much this helps your cause though...
> >
> > Ravi
> >
Hello,
Is it possible to limit parameters to specific values (other than combo
box). For example, I want to have two date fields (called From and To)
and I do not want to allow from > to and the number of days different to
be greater than 30.
Can this be done?
Thanks
Don't see what you're looking for? Try a search.
