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

bigatorMay 13, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, Interview QA, Quick Fix, SQL Server, SSRS

3 Responses

  1. Randhir Singh - June 8, 2012

    Interesting… Thanks a lot for sharing. Randhir

  2. Mickey - June 24, 2012

    Thanks for starting the ball roillng with this insight.

  3. Santosh Kumar Joshi - July 15, 2012

    Thanks Khilit, it was helpful to me. Keep up the good work..

Leave a Reply

%d bloggers like this: