Quick-Fix: Report parameter with space in SSRS
Hi guys,
One of the most common practices and a wise recommendation is to display selected report parameter(s) in report … may be in header or body of SSRS report.
Itβs a good reference when you export the SSRS report into available formats (Excel, PDF, Word etc.) Because if you donβt include/show selected parameter(s) in exported report then it becomes less-meaningful for a person who is reading/using the report … probably for some decision making.
Here, I would like to draw your attention to SSRS report which displays parameters on report.
Take a look at below screen-shot.
So, how to fix it? Simple. Open that parameter’s properties dialog box. And fix the “Label field” as shown below.
and then…
And finally, you will see your parameter without un-wanted space … as shown below π
I hope this will help you somewhere.
Thanks, Khilit
Interesting… Thanks a lot for sharing. Randhir
Thanks for starting the ball roillng with this insight.
Thanks Khilit, it was helpful to me. Keep up the good work..