question

PeterJohnSaliente-7096 avatar image
0 Votes"
PeterJohnSaliente-7096 asked PeterJohnSaliente-7096 answered

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

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
image.png (38.5 KiB)
image.png (37.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @PeterJohnSaliente-7096,

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PeterJohnSaliente-7096 avatar image
1 Vote"
PeterJohnSaliente-7096 answered

Hi Zoe,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.