Share via

issue in SSRS subscription + Date/Time Parameter

Rukshar Hial(Digital,ISC) (X-TransOrg Analytics) 0 Reputation points
2023-11-13T11:07:29.1933333+00:00

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,951 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-11-14T01:50:54.5166667+00:00

    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,

    Aniya

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.