Report Builder Datetime Parameter Only Displaying as a List

Ryan 1 Reputation point
2020-10-21T17:12:55.953+00:00

I am attempting to add a Date/Time parameter to my Report Builder report; however, when running the report, the parameter only shows as a dropdown list, rather than a calendar input. I have confirmed that the data type of the field used in the parameter is datetime, and I have ensured that the parameter itself is set to the Date/Time datatype. If anyone else has had a similar issue or is aware of a potential resolution, any guidance would be appreciated. Thanks!

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 36,116 Reputation points
    2020-10-22T02:09:39.49+00:00

    Hi @Ryan ,

    Please have a check for the properties of the parameter.

    Have you set the “Allow multiple values”?

    Have you set the available values with specify values or get value from query.

    These settings will make the parameter shows as a dropdown list.

    You may also create a new report without any data and then add a Date/Time parameter for test.

    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.


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.