all groups > sql server reporting services > august 2004 >
You're in the

sql server reporting services

group:

Default value with expression doesn't work


Default value with expression doesn't work AG, NLB d.d.
8/11/2004 10:35:02 PM
sql server reporting services:
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.
RE: Default value with expression doesn't work AG, NLB d.d.
8/11/2004 11:25:02 PM
I found the problem, but not the solution..

The problem arise when i have multiple parameters with 'expression' default
value.

[quoted text, click to view]
Re: Default value with expression doesn't work Lev Semenets [MSFT]
8/12/2004 12:10:42 AM
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.


[quoted text, click to view]

Re: Default value with expression doesn't work AG, NLB d.d.
8/12/2004 1:21:02 AM
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?


[quoted text, click to view]
Re: Default value with expression doesn't work Lev Semenets [MSFT]
8/16/2004 1:08:45 PM
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.


[quoted text, click to view]

AddThis Social Bookmark Button