Share via

SSRS Subscription parameters becomes disabled after changing Data Source from Dev to Production

Peter John Saliente 31 Reputation points
2021-06-08T01:38:17.9+00:00

I had created an SSRS (2016) Report on our reports server and this report have an email subscription which have the following report parameters:

103225-image.png

The report is using a custom data source to our test database, then we conducted our UAT and everything works as expected, so we proceed on moving the report to the production folder within the same reports server and then the release engineer then move the report to the production folder then change the data source to a shared data source that points to production database.

Then here comes the problem, when we checked the subscription to set the parameters we were surprised that some of the parameter dropdowns got disabled.

103135-image.png

Basically I was thinking that this should not happen because the tables and data on the Test and Production database should be identical thus the datasets for these parameters should still be able to retrieve the data even after changing the data source.

The workaround we did is we recreated the subscription (delete and create new), and now we were able to select again values for the parameter.

Now my question is, why did that happened? is this by design or a bug in the SSRS Report Server?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,065 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,496 Reputation points
    2021-06-08T07:21:57.88+00:00

    Hi @Peter John Saliente ,

    The issue is not common.

    Have you try to manage the subscription in compatibility mode?

    It's a little hard for us to determine if it is a known issue cause that I couldn't re-produce the issue.

    You may post this issue here.This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Peter John Saliente 31 Reputation points
    2021-06-09T02:22:43.77+00:00

    Hi Zoe,

    Thank you for the response, will try to do your suggestion and post my issue on the said link. Thanks again.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.