SSRS - How can I increase a multi-value param dropdown?  Got to be a way

Posted on 2010-01-12
Medium Priority
Last Modified: 2012-06-22
Is there anyway to do this other than changes a CSS file which will affect params across the board?  I have a report with a customer name which is longer than the box cutoff.  I can't beleive they don't at least expand to the largest width value.

Thanks all I have to figure out a workaround worst case.
Question by:sbornstein2
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 29

Expert Comment

ID: 26295950
>I have a report with a customer name which is longer than the box cutoff.

What kind of box?  Can you explain?  A text input in a web page or a area in some report tool?


Author Comment

ID: 26296324
sorry dropdown box, it is a multi value param and using a query to pull in the values to the dropdown box.  It is the default dropdown for a multivalue param in the report manager directly where the report is run.

Author Comment

ID: 26296339
I have a .net report project and I created my RDL reports where I added the multi-value parameter.  I then published to the report server and using report manager to run the report.  The report works perfect its any multi value param is coming up as a dropdown box the same size.
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

LVL 29

Accepted Solution

rdivilbiss earned 2000 total points
ID: 26299153
>I can't beleive they don't at least expand to the largest width value.

In a normal HTML web page it would.  I strongly suspect your .NET report is formatting the length of the drop down list with CSS.  Most .NET editors have the developer drag and drop the controls onto a grid, then apply absolute positioning to the elements.  It's a horrible way to format pages but hides the CSS from the developer and lets non-experienced developers make pages quickly.

Check the element in your development tool and see if it is being assigned a fixed width.

In normal HTML, even if the list is shortened using CSS, the list will expand when clicked to show the longest value.  Ideally, you can figure out how to use a normal HTML <select>... list rather than a .NET control.



Author Comment

ID: 26307589
Its in a report project in .net all you see is the RDL's, you dont see the dropdown element until you hit preview.  When setting a multi-value param in the parameters section you don't see a control.
LVL 27

Expert Comment

by:Chris Luttrell
ID: 26316052
how did that answer help you solve the problem?  Did you solve your problem?  I have looked for ways to control SSRS parameters also and wanted to learn something from this, but I am not seeing a solution.

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 13 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question