all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Default values for report parameters gets lost in Report Server


Default values for report parameters gets lost in Report Server anandr
6/14/2005 12:20:08 PM
sql server reporting services:
I have a report which takes few parameters. I have set some defalut value for
them. The default values work good when i Preview teh report. But when i
deploy the report to the Report Server, the default values get lost and the
RE: Default values for report parameters gets lost in Report Server Myles
6/14/2005 12:28:02 PM
I think you can try setting the default value in VS (designer) as

="Yes" instead of Yes

see if that works.

That being said, I am having some difficulty because it appears setting
things in the designer (for parameters) and setting parameter properties on
RS behaves in different ways. The prompt user, prompt string, default value
etc. seems to not be communicating clearly with what was set in the
designer. Example - if you have a date parameter, and in the designer you
set the default to be =Left(today, 10) - an expression, in other words - when
you go to look in RS and tweak the parameter properties it has default value
checked, but it does not sjow the expression and it doesn't see any valid
default value - and gives an error.


[quoted text, click to view]
RE: Default values for report parameters gets lost in Report Serve David Siebert
6/14/2005 1:06:05 PM
The reason you aren't seeing any value in the Default Value box is because
your default value is an expression. The Default Value textbox on the
Parameters property page only displays default values when they are strings
and not expressions (this does not mean that you do not have a default value
when it is an expression). The reason you might be getting an error is if
your parameter type is date, you're returning a string instead of a date. I
don't know what your parameter type is, but it is just a thought. Hope that
helps you a bit.

David

[quoted text, click to view]
RE: Default values for report parameters gets lost in Report Serve Myles
6/14/2005 1:17:02 PM
Thanks David -

actually, the parm type is a string - I believe that is the only way
something like
=Left(today, 10) would work, because it is a string function (basically).
It is trying, though, when you open up the parameters page of the properties
tab on http://<Server>/Reports and fiddle with a completely different
parameter and try to apply the changes, that it gives you the error on any
string type parameter that has an expression based default value. I would
think either you can have an expression as a default value, or you can't -
the ability to assign the default through the designer makes it appear that
that is ok, while later fiddling through RS makes it seem like it is wrong -
do you think possibly it's a bug?

Thanks,

Pete



[quoted text, click to view]
RE: Default values for report parameters gets lost in Report Serve David Siebert
6/14/2005 1:28:06 PM
I've noticed this also. I've gotten around it by unchecking the Has Default
boxes for any parameters that have a calculated value. The calculated
default values will still be there after you apply changes, and if you go
back to the properties page, you should see that the Has Default boxes are
checked again. I don't know if I would really consider this a major bug, but
a bug it may be. You can definitely use expressions as default values, but I
will caution you that using them can cause odd behavior when editing the
default values when actually running the report. If you have defaults that
are expressions and you change a parameter value, it will recalculate any
calculated default values for all the parameters after the one changed. This
is in order to allow cascading parameters, and can't really be changed as far
as I know. I actually use calculated values a lot (for dates e.g. beginning
of month, end of month, two weeks ago, etc.) but in order to get around the
odd behavior of cascading parameters, I will use sql to get the default
dates, and then set the default in VS to "From Query" and this manages to
work around the recalculation issue.

Hope this helps.
David

[quoted text, click to view]
RE: Default values for report parameters gets lost in Report Serve Myles
6/14/2005 1:36:07 PM
Excellent David - thank you! Yes I noticed if you un-check the 'has default
value' check box, the problem does go away and you retain the expression
based value. This is good to know! Thanks!


Pete


[quoted text, click to view]
RE: Default values for report parameters gets lost in Report Serve anandr
6/15/2005 7:28:11 AM
Where is the "Has Default" checkbox? I could not locate it in "Report
Parameters" screen

[quoted text, click to view]
RE: Default values for report parameters gets lost in Report Server Cory
9/13/2005 10:29:06 AM
I have run into the same issue.

I have defined 6 possible values for a parameter in a report. They are team
names - so they would look like:
Team 1
Team 2
and so on... I have defined Team 1 as the default selection in each report.
(by setting the default, unqueried value to: Team 1. If I use ="Team 1" or
something like that then it errors. And this appears to work correctly when
using the vs dev env. However when the report is published the selection
for team does not default to Team 1, it defaults to <Select A Value>.

Any ideas?

Thanks.

--Cory

[quoted text, click to view]
AddThis Social Bookmark Button