Menu
Is there a way to control the size of the parameter drop down box? In my current drop down box, the width increase according to the option with label of the longest length, in which causes my report's width to increase out of my control.
Thanks in advance.
450
There is no simple way to control the parameter interface, such as changing the width of the boxes. You might be able to hack the html with some JavaScript. Or you can go full-on and build your own interface to collect the parameters and then call the SSRS report, either via web services or URL access.
A query parameter is passed to the data query engine to be incorporated into the SQL script's WHERE clause or some other part of the SQL that can accept parameters. A report parameter is passed to the report processor to be processed while the report is rendered on the client.
This is a frequent complaint. There is no simple way to control the parameter interface, such as changing the width of the boxes. You might be able to hack the html with some JavaScript. Or you can go full-on and build your own interface to collect the parameters and then call the SSRS report, either via web services or URL access.
127
What I have found to work was use the LEFT function to set the length of the field. In my situation the description column of my parameter (Program Type) was defined as varchar(200) so the dropdown drawn was very wide. When I changed the SQL to SELECT ProgramID, LEFT(Description, 25)... the dropdown was a better size, and the majority of the descriptions are less than 25 characters anyway.
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
