Parameters textbox size and other report manager configurations
Hello, 1.i am using the built in report manager to view reports to many users in my organization and lately many people complain that the size of the textbox showing the multivalue parameters prompt is too small! you can barely see the values to choose from. 2. can i change the color of the links (of the reports) in the report manager? is there any place where i can configure the settings regarding the manager? thank you.
April 6th, 2008 1:43pm

I am also very interested if in 2008 we'll be able to manipulate the size of the parameter drop-down box for multi valued parameters. If a string is fairly long, the usercurrently has to scroll all the way to see the text. We have many users in our company complaining about it, please advise if something will be done in the new version. Thank you very much for your expertise.
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2008 1:00am

anyone? anyone? i too am having issue with the size of the text boxes for a simple integer value. does it really need to be large enough to fit a 27 digit number? no. i'd like to control the size to a more apropriate width for a 2 digit integer. anyone? anyone? Bueller.... Bueller....
April 26th, 2008 8:55am

Hey. I managed to dig something. still no luck with the parameters textbox size , but other settings are deffinately changeable. Some ppl even say it works with the parameters as well. Try getting inside rsreportingservices.css file in you reporting services -> report manager directory and playing with the css classes. specially, u can add classes from htmlviewer.css located in reporting services-> report server-> styles directory or something like that. classes like .INSERT and others. you can change pretty much everything there.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2008 10:39am

Microid wrote: Hey. I managed to dig something. still no luck with the parameters textbox size , but other settings are deffinately changeable. Some ppl even say it works with the parameters as well. Try getting inside rsreportingservices.css file in you reporting services -> report manager directory and playing with the css classes. specially, u can add classes from htmlviewer.css located in reporting services-> report server-> styles directory or something like that. classes like .INSERT and others. you can change pretty much everything there.hi!... im ALSO! very intersted on the parameters Size... specially with DropDowns... and... i can't believe this... but, i'm trying hard... so,with.csshowmuchcanwechangeaboutthesizeofdropdownparameters...forexample...fontsize?...maybe...breakline(whenhave2large dropdowns...)?...well.. i'll go to w3school... still too much to learn about css.
May 2nd, 2008 8:33pm

We have not made parameter text box size configurable in SQL 2008. As the thread mentions, it might be possible to do something with CSS, but I imagine it will be with limited success. We have not targeted this kind of parameter area customization. If your goal is to provide a nicer experience for customers, you can provide use the ReportViewer control in Visual Studio 2005 and 2008as part of an applicationto allow your users to viewreports. Please open and issue on http://connect.microsoft.com so we can track this feedback as part of our planning process for future versions. Thanks, -Lukasz
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2008 1:49am

Thank you for your response. i was afraid of that answer. though the configuration mentioned above seems managable with the CSS files located in the Report Manager folders it doesnt do the trick. it seems there are classes that simply dont do what they should. the problem is more specific, at least in my case. my users view the reports using Report Manager only, and when choosing the parameters value from a parameter dropdown list or a textbox, the postback retrieved paramters do not fit the size (width) of the textbox/dropdown list. meaning user has to scroll the very small and utterly uncomfortable list just to see what do they choose from. i believe this to be more that just comfort. more because users simply facing slightly more difficult problems fiding their wished parameters... is there anything i can do about this? thank you.
June 11th, 2008 1:32pm

CSScannotcontrol the width of the parameter textboxes/dropdowns simply because the report manager does not put either an id property or use a class when creating them. there is almost no way to get to them in the DOM using conventional methods. the issue for me is really how beautiful the sql server reporting service is in general and how fugly the final user interface is in production. as i said, a textbox the length of a football field to enter a single digit integer is just plain stupid. users ask me all the time to fix it. "i can't" is the answer. "that is the way the Microsoft has designed it" i say. even though it may just be a limitation of the rdl specification. of course that has never stopped Microsoft before in including non-standard features to their implementations. whatever, hopefully you have enough complaints to fix this in the next version. as for too many or to much information being crammed into a parameter dropdown, i suggest you redesign your report to appropriately reduce the size or number of choices returnedby the sub query that creates the list. your users should not have to scroll more than say 20 records. if they do, you should add another parameter to filter that first. just my 2 cents. wyatt
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2008 8:13pm

A static CSS solution involves: 1. Deploy report as is and view in browser2. View source and locate the control id (Ex. ReportViewerControl_ctl00_ctl07_txtValue). You can usually find the control by searching for the parameter caption text.3. Ensure the <HTMLViewerStyleSheet>HTMLViewer</HTMLViewerStyleSheet> is in rsreportserver.config.4. Add an 'id' targeted CSS entry in HTMLViewer.css like the following: #ReportViewerControl_ctl00_ctl07_txtValue { width: 500px }
February 27th, 2009 8:04am

Hi, Imran,Does the solution of modifying the HTMLViewer you detail above work for the parameter size problem? Thanks for your great feedback.Rick
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2010 5:20pm

Hello, Did someone find a solution to this? I need to align and make all parameters textboxes same width. Could we control it? Thank you!
January 31st, 2011 11:48pm

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

Other recent topics Other recent topics