issue in SSRS subscription + Date/Time Parameter


How to enable date(calendar) parameter in SSRS and subscription should continue as usual.My subscription stops working when i make the Date/time parameter visible from hidden.Can anyone pls help

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.
2,641 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 11,561 Reputation points Microsoft Vendor

    Hi @Rukshar Hial(Digital,ISC) (X-TransOrg Analytics)

    I did a simple test. A report containing date parameters is created. The parameter type is "Date/Time" and is set to "Hidden". Then a subscription was created and set to run every five minutes. When I change the report parameter visibility to "Visble", and save, the subscription still works fine.

    Did you make other changes to the parameters? For example, changed the parameter name or data type? You can refer to this document and check the logs to see possible reasons for subscription failure: Troubleshoot Reporting Services Subscriptions and Delivery.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,