Allow SSRS Parameter Panel to be formatted - by Tim Kent - Adatis

Status : 


Sign in
to vote
ID 545893 Comments
Status Active Workarounds
Type Suggestion Repros 1
Opened 3/30/2010 3:16:16 PM
Access Restriction Public


The parameter panel layout for a SSRS report cannot be customised in any way.  This is a major flaw and often a reason that SSRS is rejected as an end user tool.  The parameter panel has changed very little since the initial release of SSRS and looks dated
Sign in to post a comment.
Posted by Paul playing with BI on 2/20/2015 at 1:31 AM
I did the following, and it was no so bad:
- I launched the dashboard designer
- Created a data source
- Created a Filter for every drop-down/multi-select list in the reports
- Created a dashboard with the desired layout
- Uploaded the reports to SP
- Created a "Reporting Services" Report for every SSRS Report - Basically you just need to point to the report location, and also unckeck the "Show parameters option"
- Dragged the reports and the filters into the dashboard and create the respective connections
- Published to SP and adjust again the layout
- Done
I know an improvement is needed but at least there is an option for a better look-and-feel
Kind Regards,
Posted by Mike Honey - Manga Solutions on 9/30/2014 at 3:52 PM
For those who are wondering, there are no improvements to this with SQL Server 2014.

It's also recently struck me how much wasted space there is in the parameter panel - on a standard desktop monitor it's around 60-70% whitespace.

@Steven A - you make a good point - relevant to SSRS Integrated with SharePoint.
Posted by WhyTheQ on 9/30/2014 at 1:58 AM
Is @CubeZene's comment is either very worrying or a joke? To make the parameter bar customizable would certainly add value to this excellent product.
Posted by Steven A on 9/17/2014 at 2:46 PM
Putting the bar on the right is dumb as hell. The resize handle is on the bottom right of the dropdown box and if the monitor isn't wide enough, requires you to scroll right. We need to have options on where to place the parameters bar else our reports designer has to redo well over 100 reports to get it to play nice, and her time isn't cheap.
Posted by jorgeghr on 5/28/2014 at 5:17 PM
Any updates on this request? SSRS is getting old and outdated.
Posted by CubeZene on 2/21/2014 at 10:37 AM
Unfortunately, the source code to change this has been misplaced. The Microsoft BI Team for SSRS is searching for it, but someone on the team deleted it by mistake. All the backups have been lost too.
Posted by Mike Honey - Manga Solutions on 1/19/2014 at 10:18 PM
I agree with most of the suggestions below, and I'm also disappointed that this crucial UI hasnt really been improved since SSRS v1 - 10 years ago!

I'd also like to see a modern Bing-style "search as you type" parameter style, e.g. the designer points SSRS at a dataset and the list of choices starts to populate as the user types. Even if this was just a simplistic wildcard match it would be a big step forward.
Posted by gorka34 on 12/19/2013 at 12:31 PM
This is disappointing and odd that it is relatively ignored by Microsoft. Why not help make the SSRS experience in SharePoint more acceptable to end users?
Posted by Sebastien Mistouflet on 12/12/2013 at 7:44 PM
Waow, how disappointing !
Posted by george wen on 10/31/2013 at 4:43 PM
This is very funny that a small change like this can't be done, I have SSRS integrated with SharePoint and the parameters panel has to be stuck to the right all the time!
Posted by Stoonad on 6/6/2013 at 9:52 AM
If MS does not want to spend the time making this better, at least release the source to ReportViewer.aspx to Codeplex, and allow the community to do it.
Posted by Dave R - 140362 on 4/19/2013 at 10:58 AM
Will there be a celebration on the third anniversary of this issue being ignored by Microsoft?
Posted by Valentino Vranken on 2/20/2013 at 3:54 AM
And the Boolean parameter type requires some changes too, two radio buttons, really? The person who designed that wasn't aware of the Checkbox control?
Posted by Koen Verbeeck on 2/20/2013 at 3:43 AM
This is in my opinion a big shortcoming of SSRS. Competitors like Cognos have prompt pages, which are a separate set of "report" pages where you can define yourself the position and layout of the parameter prompts.
It would be really nice to see a similar feature in SSRS.
Posted by Bluey47 on 5/16/2012 at 11:52 PM
Did this make it into 2012? I haven’t found anything about it in the feature lists.

Wish list: Widths, colours, fonts, spacing, more parameters on the one line, tooltips, parameter refreshing more intelligently/quicker.

I work with SSRS every day (2008 and 2010) and I am frustrated by this every day. This is the reason I recommend any other reporting solution above SSRS. It’s not even the fact that it’s annoying; it’s the fact it’s been like this for 10 years and hasn’t been touched.
Posted by Scott Cameron on 9/28/2011 at 6:19 PM
SSRS 2008 RS in SharePoint 2010 integrated mode has the Parameter panel on the right side. And based on the length of parameter values, the panel can expand to be very wide.

Need to be able to configure the Parameter panel so that it can be on the top or the left. I have a client that may decide to use SSRS stand-alone instead of SP integrated mode because of this issue.
Posted by Robert Heinig II on 2/23/2011 at 9:24 AM

- Placement control, at the very least a "ForceToLeftColumn" for a parameter or a separator
- Size control. As it is, single-choice dropdowns grow with the contents with no limits, to the point of pushing the "go" button out of the window, but multi-choice dropdowns get truncated to 175 pixels. Statically improvable in the ReportingServices.css, but better to be considered as feature in BIDS report design.
- Basic label font formatting in RDL and/or Manager
- Label text set in Manager surviving RDL update
- Display-only parameters ("yes, this is only data for YOUR department")
- Better calendar control (as in BIDS preview or Ajax CTK)
These sound trivial, right?
Posted by Microsoft on 4/26/2010 at 10:59 AM
Thank you for the suggestion and we do agree with you. We are looking at improving the parameter story in our next release. We agree with your idea for using sliders and other more "up to date" features. Look for changes in SQL11 and possibly Dev11.
Posted by jrmunn on 4/1/2010 at 8:04 AM
It would be really nice to be able to use other input controls at the very least. We always talk about "end-user experience" but that concept doesn't seem to reach to end-users running SSRS reports. Multi-value drop-down lists only go so far for input, particularly with reports that use KPI--ah, wouldn't it be nice to have a slider!?