FIX: Incorrect data when a subscription runs on a computer whose time zone differs from the report server time zone in SQL Server 2016 Reporting Services

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer More


Consider the following scenario:

  • You have a report that accepts a DateTime type parameter in Microsoft SQL Server 2016 Reporting Services (SSRS).
  • You open the SSRS web portal on a computer that uses a different time zone setting than the setting that's used by the SSRS report server.
  • You create a subscription that accepts a DateTime type parameter to subscribe to the report.

In this scenario, when the subscription is run, incorrect data is returned.


This fix for this problem is included in Cumulative Update 3 for SQL Server 2016 Service Pack 1.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.