Friday, February 24, 2012

Default value with expression doesn't work

I have a problem to set default value with expression like..
=DateSerial( Year(Now), Month(Now) +1, 0).
I try with Today, Globals!ExecutionTime,..but it doesn't work.
In preview and on server parameter filed is disabled. If i press View Report
then fileld gets correnct value. To view report i must press view report
again.
Thanks.I found the problem, but not the solution..
The problem arise when i have multiple parameters with 'expression' default
value.
"AG, NLB d.d." wrote:
> I have a problem to set default value with expression like..
> =DateSerial( Year(Now), Month(Now) +1, 0).
> I try with Today, Globals!ExecutionTime,..but it doesn't work.
> In preview and on server parameter filed is disabled. If i press View Report
> then fileld gets correnct value. To view report i must press view report
> again.
> Thanks.
>|||That's the way it works when parameter's default value is expression.
We do not know if expression depends on other parameters, therefore
expression is evaluated only when values of all preceding parameters are
known.
The workaround is to use default value from query.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:956DFDBD-5AA7-4050-866A-12C63E65DF99@.microsoft.com...
>I found the problem, but not the solution..
> The problem arise when i have multiple parameters with 'expression'
> default
> value.
> "AG, NLB d.d." wrote:
>> I have a problem to set default value with expression like..
>> =DateSerial( Year(Now), Month(Now) +1, 0).
>> I try with Today, Globals!ExecutionTime,..but it doesn't work.
>> In preview and on server parameter filed is disabled. If i press View
>> Report
>> then fileld gets correnct value. To view report i must press view report
>> again.
>> Thanks.|||But if i have only one parameter with expression =DateSerial( Year(Now),
Month(Now) +1, 0) it works fine, i get correct value.
If i have two or three there is a problem?
"Lev Semenets [MSFT]" wrote:
> That's the way it works when parameter's default value is expression.
> We do not know if expression depends on other parameters, therefore
> expression is evaluated only when values of all preceding parameters are
> known.
> The workaround is to use default value from query.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
> news:956DFDBD-5AA7-4050-866A-12C63E65DF99@.microsoft.com...
> >I found the problem, but not the solution..
> >
> > The problem arise when i have multiple parameters with 'expression'
> > default
> > value.
> >
> > "AG, NLB d.d." wrote:
> >
> >> I have a problem to set default value with expression like..
> >> =DateSerial( Year(Now), Month(Now) +1, 0).
> >>
> >> I try with Today, Globals!ExecutionTime,..but it doesn't work.
> >>
> >> In preview and on server parameter filed is disabled. If i press View
> >> Report
> >> then fileld gets correnct value. To view report i must press view report
> >> again.
> >>
> >> Thanks.
> >>
>
>|||Yes, it would happen if there are two or more such parameters.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:E8F7BDB8-3C0D-445D-A90B-7206B62F0698@.microsoft.com...
> But if i have only one parameter with expression =DateSerial( Year(Now),
> Month(Now) +1, 0) it works fine, i get correct value.
> If i have two or three there is a problem?
>
> "Lev Semenets [MSFT]" wrote:
>> That's the way it works when parameter's default value is expression.
>> We do not know if expression depends on other parameters, therefore
>> expression is evaluated only when values of all preceding parameters are
>> known.
>> The workaround is to use default value from query.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
>> news:956DFDBD-5AA7-4050-866A-12C63E65DF99@.microsoft.com...
>> >I found the problem, but not the solution..
>> >
>> > The problem arise when i have multiple parameters with 'expression'
>> > default
>> > value.
>> >
>> > "AG, NLB d.d." wrote:
>> >
>> >> I have a problem to set default value with expression like..
>> >> =DateSerial( Year(Now), Month(Now) +1, 0).
>> >>
>> >> I try with Today, Globals!ExecutionTime,..but it doesn't work.
>> >>
>> >> In preview and on server parameter filed is disabled. If i press View
>> >> Report
>> >> then fileld gets correnct value. To view report i must press view
>> >> report
>> >> again.
>> >>
>> >> Thanks.
>> >>
>>

No comments:

Post a Comment