0
votes

When developing SSRS reports in Visual Studio, I use solution configurations (Debug/Release) to select whether the report will be deployed to a test server or to production. When developing the report, I set up default values for the report parameters so previewing can be done quickly, but these defaults should not be deployed to production, so at present I must remember to remove the default value from EVERY parameter before deploying when I switch to my "Release" configuration. (Or have to clean that up later within SSRS since redeploying does not modify parameter defaults).

I would hope there is some way to link the parameter defaults to the build configuration so that the step of manually removing all default values could be made unnecessary. Does Visual Studio have a way to do this?

1

1 Answers

1
votes

Default parameters are only propagated to the server on the first deployment. Keep the defaults set in your development environment. Once the report is deployed, go to the report server, find the report, open the parameters and remove the defaults. These won't be overwritten by subsequent deployments of the report.