Strict Standards: Non-static method Settings::setHostName() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\AutoConfig.php on line 20

Strict Standards: Non-static method Settings::addHostAlias() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\AutoConfig.php on line 22

Strict Standards: Non-static method Settings::setSiteRoot() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\AutoConfig.php on line 28

Strict Standards: Non-static method Settings::setDsn() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 16

Strict Standards: Non-static method Settings::setTitle() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 19

Strict Standards: Non-static method Settings::setDescription() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 20

Strict Standards: Non-static method Settings::setSiteRoot() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 24

Strict Standards: Non-static method Settings::setShowDeleted() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 31

Strict Standards: Non-static method Settings::setRecentTopicsDuration() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 36

Strict Standards: Non-static method Settings::test() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 28

Strict Standards: Non-static method Skin::test() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 29

Strict Standards: Non-static method Settings::getSkin() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 102

Strict Standards: Non-static method Settings::getSiteRoot() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 32

Strict Standards: Non-static method Settings::getDsn() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 35

Strict Standards: Non-static method Form::field() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 39

Strict Standards: Non-static method Form::fieldExists() should not be called statically, assuming $this from incompatible context in C:\website\www.networksteve.com\enterprise\_lib\Entity\User.php on line 92

Strict Standards: Non-static method Form::fieldExists() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 15

Strict Standards: Non-static method Form::field() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 17

Strict Standards: Non-static method Settings::getShowDeleted() should not be called statically, assuming $this from incompatible context in C:\website\www.networksteve.com\enterprise\_lib\Entity\Topic.php on line 139

Strict Standards: Non-static method Entity_Post::queryPosts() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 21

Strict Standards: Non-static method Settings::getShowDeleted() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Entity\Post.php on line 111

Strict Standards: Non-static method Skin::showHeader() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 23

Strict Standards: Non-static method Skin::includeFile() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 46

Strict Standards: Non-static method Settings::getSkin() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 91
changing default width of a multivalue parameter in SSRS 2008 (Network Steve Forum)
changing default width of a multivalue parameter in SSRS 2008
Hi is it possible to force the multivalue parameter to be wider in SSRS 2008 ? I have tried the following with no luck thus far - Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportManager\Styles\ReportingServices.css e.g. .msrs-multiValueDropDown{border: 1px DarkGray solid;width: 300px;} many thanks for your time
September 30th, 2008 1:40pm

Same problem in SQL2005, you cannot.
Free Windows Admin Tool Kit Click here and download it now
October 1st, 2008 7:17am

is there any news from Microsoft as to whether this is going to be fixed at all regards
October 3rd, 2008 2:38pm

I replied to a very old post regarding this today, I'll just cut and paste into here, as it is a very annoying thing that has not been fixed in the last few iterations of ssrs. If someone can verify my code works for 2008 please let us all know. There are two ways of modifying the width in 2005, not sure if it works in 2008. One is to modify the HtmlViewer.css file after you have setup SSRS to use it (http://msdn.microsoft.com/en-us/library/ms345247.aspx). After that is done, you can add the following to the file (Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportServer\Styles) DIV#ctl144_ctl00_ctl01_divDropDown{width: 350px !important;} the ctl144 part hasn't changed on the 4 or five machines I've used this on, but this number may be different on your installation, the middle ctl00 has been constant, but you need to add multiple lines for the last ctl## increments based on the number of input controls on the screen. so you may need to add 20 or 30 of these to your css file and increment the last ctl## because you catch all the dropdowns in your report. The second way, is to use a modification of the javascript code at http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx that Shyam also pointed out. If you read through all the code that loads the multi select window by doing a view source, you will see that it is based on the width of the visible textbox: Code Snippet function Show(){ var floatingEditor = document.getElementById(this.m_floatingEditorID); // only show if the editor is not currently visible. if (floatingEditor.style.display == "inline") return; // Set drop down and summary string to the same width to make it look like a drop down var visibleTextBox = document.getElementById(this.m_dropDownObject.m_visibleTextBoxID); floatingEditor.style.width = visibleTextBox.offsetWidth + "px"; floatingEditor.style.display = "inline"; // Call the drop down object to show the iframe this.m_dropDownObject.Show(); // Set the iframe height to our controls height var floatingIFrame = document.getElementById(this.m_dropDownObject.m_floatingIframeID); floatingIFrame.style.height = floatingEditor.offsetHeight; if (floatingEditor.childNodes[0].focus) floatingEditor.childNodes[0].focus();} Unfortunately, this function is hardcoded into a dll somewhere I guess. Plus the width of the textbox is set to size 28, and that is not changable anywhere easily. However, now that we know that it is based on the txtValue input box (ctl144_ctl00_ctl01_txtValue for example) we can insert the following code into the ReportServices.js file (Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportManager\js\ReportingServices.js): addLoadEvent(SetMultiSelectParamWidth); Code Snippet function addLoadEvent(fn) { if (window.addEventListener) window.addEventListener('load', fn, false) else if (window.attachEvent) window.attachEvent('onload', fn); } function SetMultiSelectParamWidth() { var headerDivs = document.getElementsByTagName('input'); for (var i=0;i<HEADERDIVS.LENGTH;I++)< P> { var idname = headerDivs[i].id; if (typeof idname != 'undefined' && idname.search(/txtValue/i)>0) { headerDivs[i].size='50'; } } } This runs after the page has finished loading and changes the width of any text box to 50, you can modify this at your leisure. Since the multiselect window size is based on the size of the textbox, we now have a larger multiselect window. Yay us. If you want to limit it to the dropdown text boxes only, you will have to add a loop that looks for matching _divDropDown controls and only modify the txtValue controls that match. Can't guarantee this works for everyone, but hope this helps. Haven't tried it on 2008 yet either. For any Microsoft guy that reads this, COME ON! This has been an issue since 2000. You add all sorts of useless *** to sql 2008 and can't fix a simple thing like this. Or even document the css classnames in reporting services. It isn't that much to do in the 10 years you have been developing this product. Shango
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 2:36pm

Well, after posting all that code, I found a better way to set the size of the control. This method overwrites the Show() function that the ShowBase() prototype points to. It is a copy of the Show() function, but with an option to set a customwidth of the multiselect drop down. The nice thing about this is that it leaves the text box size the same for design consistancy sake, but only the width of the drop down when it opens changes. Try it and use it if you like it. Original code is the Show() function that the viewer control outputs, so probably is (c) Microsoft, but since this only works for SSRS it shouldn't be a problem. This gets inserted at the top of ReportingServices.js (Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportManager\js\ReportingServices.js): Code Snippet addLoadEvent(SetMultiSelectParamWidth); function addLoadEvent(fn) { if (window.addEventListener) window.addEventListener('load', fn, false) else if (window.attachEvent) window.attachEvent('onload', fn); } function SetMultiSelectParamWidth() { MultiValueParamClass.prototype.ShowBase = ShowCustom; } function ShowCustom() { var customwidth="350px" var floatingEditor = document.getElementById(this.m_floatingEditorID); // only show if the editor is not currently visible. if (floatingEditor.style.display == "inline") return; // Set drop down and summary string to the same width to make it look like a drop down var visibleTextBox = document.getElementById(this.m_dropDownObject.m_visibleTextBoxID); floatingEditor.style.width = customwidth; floatingEditor.style.display = "inline"; // Call the drop down object to show the iframe this.m_dropDownObject.Show(); // Set the iframe height to our controls height var floatingIFrame = document.getElementById(this.m_dropDownObject.m_floatingIframeID); floatingIFrame.style.height = floatingEditor.offsetHeight; if (floatingEditor.childNodes[0].focus) floatingEditor.childNodes[0].focus(); } If someone can veriry it works on SSRS 2008, let us know! And now that you know you can overwrite some of the function calls, this gives you a bit more flexibility should you need it. Shango
October 16th, 2008 7:07pm

Shango, I am in the process of verifying if this works for 2008. I would like to blog about this if it works, or even if it doesn't. I would like to give you proper credit for coming up with this. I think you can get to me through my profile to confirm. Thanks.
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2008 8:59pm

Shango,Thank you for this post, it was exactly what I was looking for. Or at least I thought it was. I added the code snippet as instructed. I am using the native Reporting Services 2005 server and not a custom ASP.Net app to host my reports.I cannot get the new code to run or even to download to client machines. When I do a View Source, the new code is not present. I tried stopping and starting the instance in IIS, I restarted IIS itself, I even restarted the entire server. Nothing I have done gets the new code to download and run.Any ideas what else I might try?Many Thanks,Austin
November 5th, 2008 6:25pm

Shango and Austin, This also appears to be exactly what I am looking for. But alas, I am experiencing the same troubles as Austin. Any one have some ideas? Thanks, Chris
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2008 3:36pm

I lied, it actually does work. I was looking at the parameter selection not the dropdown that pops up for multi-select. Thank you guys!
November 10th, 2008 8:07pm

Is it working for specific reportin which i need to change thewidth of multi value parameter? i need it for only certain report as it is having more long parameter name. Can any one confirm please?
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2008 11:14am

Thanks ShangoY- worked on SSRS2005 for me. But only when looking at a report directly on the reportserver. Is there a way it will work when using URL access to view a report?
December 9th, 2008 1:56pm

Hi Niallhannon, is it working for specific report or worked for all report on reportserver? I need it for one report only and dont want to apply this changes to other report. Can you please confirm? thanks, vijay
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2008 2:01pm

It works for all reports. N
December 9th, 2008 2:45pm

If possible can any one confirm if there is any way to do this for specific report by making changes into .rdl file or anything? The problem is other multi value parameter is having less characters (ie. yes, no, all etc). I dont want it to look so big. But need for one report which shows long name around 30 characters. As it is the name of trust. If some one can confirm it is not possible for specific report in sql 2005 then i can stop looking into it. thanks, vijay
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2008 3:16pm

I can say with 99% confidence that you cannot specify the width of the multi-value paramter via rdl or any option on the report.
December 9th, 2008 3:23pm

thank you very much. Now i feel 100% that it is not possible.
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2008 4:41pm

Shango,This works perfect, Thank You! However, it does not work on the subscriptions page I looked for another .js file but couldn't find anything, Do you know how I can modify the width of the multi-parameters on the subscriptions page?Thank You
December 11th, 2008 2:22pm

This does not appear to work in SSRS 2008. I added the code to the js file, which now resides in it's own js directory. I even went so far as to restart the service and delete all references to the js file in my internet cache.Has anyone else tried this in SSRS 2008?
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2009 5:25pm

HAD same problem as Austin,I couldn't get the new Java script code to load.Couldn't get Report Server to use HTmlViewer.css What DID end up working was addingDIV#ctl140_ctl00_ctl01_divDropDown{width: 350px !important;}to ReportingServices.css (Located inC:\Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportManager\Styles)My machine used '140' instead of '144' like Shango'sand I did have to add it about 20 times, incrimenting the last ctl## each time.Works like a charm now, Thank you Shango. Edit: Just tried the same strategy for Reporting Services 2008, it also worked, just needed to use '145' this time around.
February 18th, 2009 7:28pm

Shango, I don't know why people could not get this to work in SSRS 2008, this is PERFECT for me! The width before clicking the multi-select is not altered with the change to the ReportingServices.js file; however, as I wanted, the multi-select grows when the user opens it up to the width specified. Great solution, and works fine in SSRS 2008. Regards, John
Free Windows Admin Tool Kit Click here and download it now
April 3rd, 2009 5:03pm

I changed the reportingservices.js file and can see the changes from report manager. I am using SSRS 2005. I do not see the changes when I load the same report using a report viewer control in an ASPX page. Is there anything else I have to change? Thanks
June 29th, 2009 5:43pm

Didnt work for me in SSRS 2008 guys, my boss gonna kill me, any solutions? in R2 its fixed?
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2011 1:10pm

Igorfosper: Adding addLoadEvent to ReportingServices.js in SSRS 2008 R2 doesn't work for me. If I find a solution I will post it here.
June 9th, 2011 5:35pm


Strict Standards: Non-static method Settings::getRecentTopicsLimit() should not be called statically, assuming $this from incompatible context in C:\website\www.networksteve.com\enterprise\_lib\Entity\Topic.php on line 121

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics

Strict Standards: Non-static method Skin::showFooter() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 119

Strict Standards: Non-static method Skin::includeFile() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 56

Strict Standards: Non-static method Settings::getSkin() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 91