Increase Report parameter width

Question

Increase Report parameter width

YumiPhx

Mr or Mrs. 500

Points: 512
More actions
September 15, 2009 at 3:52 pm

#214399

Does anyone know how to increase the width of the report parameter in SSRS 2005?
My parameter concatenate the ID & Description. The default of Parameter Drop down list box is very narrow. We can only see the ID.
Your help is much appreciated,
Yumi

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

sam-770000 Ten Centuries Points: 1267 More actions · Answer 1

Hi there,

The length of the report parameter should increase based on the longest parameter value in your list. It seems a bit weird that it doesnt; giving us some more details of this problem will help figure out this issue. cheers!

YumiPhx Mr or Mrs. 500 Points: 512 More actions · Answer 2

HI Sam,

I am sorry that I forgot to mention about Multi-Value selection.

Yes, the report parameter width increase to fit the longest length of the text in Drop-down list box ONLY for Single selection. When I set the parameter to Multi-Value, the Drop-down text box automaticaly decrease to haft size only. I tried to find a solution to work around it but there is no luck so far.

Please let me know If you have any work around solution then I would be very appreciate.

Thanks,

Yumi

Jon Spink SSCarpal Tunnel Points: 4010 More actions · Answer 3

I have tried to alter the width of multi-value parameter drop-downs but have not found a way. You can however vary the width of other parameters by editing the ReportingServices.css file in the ReportManager folder.

tiffanyjanetblack SSCommitted Points: 1877 More actions · Answer 4

I personally have never found a way to increase

the width of the parm boxes. Ever.

I really wish more parm properties were exposed.

I really really do. Maybe becasue I am used to

having full control since I started out as a VB app

developer 🙂

atfalatitkb Old Hand Points: 381 More actions · Answer 5

I have encountered the same issue.

This is what I found works well: With parameters you typically display the parameter.label. you select the parameter.label, and pass the parameter.value to you query or stored procedure.

When you populate your parameter.label field, pad it with spaces at the end, the beginning, or both ends. This will cause the parameter.label to use up more real estate when it is displayed.

eaa

YumiPhx Mr or Mrs. 500 Points: 512 More actions · Answer 6

Thank you for sharing your work around solution.

However, I tried but the width did not increase. It stays about 2 inches.

Below is the code that I put in my dataset (SSRS). CostCenterWDesc is the field that I bring in for Lable of the Parameter. I did not put the Space at the begining because it shows the spaces in the Multivalue Parameter list.

Please let me know if you did not do it right.

Select CostCenterWDesc =

( CostCenter + ' - ' + Description + ' ')

Thanks,

Yumi

YumiPhx Mr or Mrs. 500 Points: 512 More actions · Answer 7

OOPs I am so sorry.

2 Corrections for reply Post;

1) I mean " Please let me know if I did not do it right"

2) I added Many spaces at the end, not only one

Sorry again,

Yumi

tiffanyjanetblack SSCommitted Points: 1877 More actions · Answer 8

I've not had any luck with that technique either.

I've had parameters values like "INDUSTRIAL SALES REGION - SOUTHEAST DIVISION" and still only like 1/2 of the phrase is immediately

visible. Users had to use the scrollbar to see the rest of the value.

atfalatitkb Old Hand Points: 381 More actions · Answer 9

I am sorry I completely overlooked the fact that you were dealing with multi-value parameters. I know that this works for single value parameters. Good luck with this as this problem doesn't appear to be resolved by Microsoft.

eaa

youngm24 SSC Rookie Points: 42 More actions · Answer 10

I have had the same problem in SSRS 2008. Not sure if you are displaying your reports in RS directly, or using a reporting control on the Web.

I am using the reporting control on the web, and I asked Microsoft about it at Tech Ed. They said the only workaround is to create the pickers for the parameters on a webpage myself, hide the ones on the report, and pass the values into the report when you call it (as URL parameters).

But that requires coding on my part....coding that would have to stay in sync with the reports, especially their names and their parameters if they change. Kinda defeats some of the benefits we are getting out of SSRS. So far I have managed to convince the analysts that we have more important things to work on. That may change soon, but for now they prefer to tweak the reports instead.

sanjeev.gaur SSC Rookie Points: 35 More actions · Answer 11

Try this

SELECT EmpID, EmpName from Employee

UNION

SELECT NULL AS EmpID, 'ALL' AS EmpName

ORDER BY EmpName

And SET default value as NULL