SSRS 2016 Report Parameter formatting

Anna 21 Reputation points
2021-11-03T15:26:41.263+00:00

Is there a way to predefine a parameter box so it accepts pre formatted value?
I wanted to format a text parameter to be 1234-56-789 and give the users a pre formatted parameter box because a lot of times they forget the dash and they don't get what they are looking for in the report.

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rob Mills 1 Reputation point
    2021-11-03T18:01:18.397+00:00

    Unfortunately since you can't tell SSRS to use a format string with a text parameter I think your best solution may be to check to see if there are 2 dashes in the right places when the report is submitted. If not add them with an expression before using the value.

  2. Isabellaz-1451 3,611 Reputation points
    2021-11-04T02:07:49.707+00:00

    Hi @Anna ,

    I am not sure if I see your point， why not create a dateset that formatted already，and use the dateset to fill the parameter.

    146415-test.png

    Best Regards,
    Isabella

    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.