default parameter values not updated

Hot Topic

sql server 2000
Log restore failure
Automatic Activation - Message is null/Monitoring of Readers
SSRS 2005 and Stored Procedures
SQL CE 2.0 and SQL Mobile 2005
problem with Display databound images in page header
move file task using variable
which algorithm to be used with symmetric keys
AMO Connection
how to use sqliostress.exe on remote server?

SQL Server

Problem with query using SQL Server 2005 September CTP
32bit Admin tools when the only media you have is 64 bit
Error when restoring database
Active (non executed) objects will still drain performance!?
hiding "Change Credential" link
Inserting long string cuts of at 150 chars
SQL2005: Reource database
SQL Performance
SQL Server CE and Memory Issue
Strange cube processing error

default parameter values not updated

For testing purposes, I had placed default values in my report parameters. I deployed the whole suite of reports once and tested them. Then I eliminated the default parameters and redeployed, but the server doesn't pick up the changes. Other changes are updated fine, but for some reason it's hanging on to my default parameter values Why Is there a way around this

Using RS 2000 Beta 2, btw.




Answer this question

default parameter values not updated

  • Keith Brown

    > use the rs command line tool
    Is there a tutorial available on this tool   RS.exe is asking for a script file to execute, but I have no idea what format it's looking for.


  • GinkZ182

    I came across the same thing in Reporting Services 2005. However, you can change the parameters using the Report Manager.

    http://<servername>/Reports

    Click "Show Details"

    Click the properties icon in the "Edit" column

    Click the "parameters" tab

    Uncheck or reset the default values here.

    Regards, Jeroen

  • igorbaITALY

    Sorry, I meant i'm running SP2, not Beta 2.

    > Perhaps deleting the reports and recreating them would help
    Yes, that's what I'm doing. Seems stupid, though.



  • Waxxy

    Sorry, feature, not bug... Smile

    If you are deleting the reports manually, one option would be to use the rs command line tool to delete & republish the reports.


  • CraigBoyd

    Modifying the tables directly is not supported. However, you can see this information in the Parameter column in the Catalog table.

    The original intent was to allow for an admin to change the defaults, prompts, etc. and not have it overwritten by the report developer. We should provide a way to override this behavior.

  • dolf

    Which table in the ReportServer database contains the default parameter info



  • W. Jansoone

    Perhaps deleting the reports and recreating them would help

    I think it is a bug.  RS 2000 is up to SP2 now so you should upgrade...


  • default parameter values not updated
Answer this question