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.
SSRS 2016 Report Parameter formatting
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.
2 answers
Sort by: Most helpful
-
-
Isabellaz-1451 3,616 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.
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.