Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : Parameter is not getting defauilt value


Mark
10/19/2004 1:53:07 PM
I have a numeric parameter that does not get its default value when I deploy
the report. It works fine in report designer preview.
Peter Blackburn (www.sqlreportingservices.net)
10/20/2004 2:11:03 AM
Mark,

This behaviour is by design.
Once a report has been deployed, if you reconfigure the default value for a
particular parameter through the Report Manager then that will take
precedence over any default values that you subsequently include in the RDL
that you may re-deploy.

The rationale behind these kind of things is that the Report Administrator
is King - if the Report Administrator has manually set something on the
Report Manager to be overridden then it is not welcome that a Report
Developer comes along and overwrites such a setting.

Bill and my book gives in-depth treatment of Report Parameters on pages
283 - 292 and p286 explains the feature you are experiencing.

Best Wishes.

Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
www.sqlreportingservices.net



[quoted text, click to view]

Mark
10/21/2004 7:39:15 AM
What I dont understand is it's by design.
For it looks like a bug.
Let's say I have a report with a parameter that has to be entered by the user.
Later on the user decides to have a default value for that paramter.
But I cannot do it because the has entered the value for the parameter at
least once.
Am I correct?

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