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 3
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 Carl Daniel on 8/29/2016 at 4:47 PM
And, shockingly (actually, why should I be shocked - this is situation normal for SSRS), the report designer had new features added and a whole new list of things broken, making it more difficult than ever to author reports for SSRS.
Posted by Carl Daniel on 8/22/2016 at 1:57 PM
This was partially implemented by SQL 2016. Sadly, it was done in a way that makes it unusable for me. Re-arranging the parameters in the report designer has two effects: 1. It builds a new ReportParametersLayout structure - Good. 2. It re-orders the parameters in the ReportParameters section - BAD. Because the parameters are re-ordered, the resulting report is not fully backwards compatible with pre-2016 report viewers - those older viewers will display the parameters with the default auto-layout which is based on parameter order, but the parameter order has changed, resulting in a different layout than was had with previous versions. For people who author reports that need to target many versions of SSRS, this makes the custom parameter layout unusable.
Posted by Anushka_W on 8/11/2015 at 12:21 AM
How about using PerformancePoint designer to render reports into SharePoint. In that way you can place parameters in the top of report.
Posted by ajhuddymsdn on 7/29/2015 at 12:47 PM
Please just open source the ReportBuilder so the community can fix this
Posted by Tito Perez on 6/11/2015 at 10:18 AM
This is the reason we do not use Reporting Services in SharePoint integrated mode. We have SharePoint 2013, but there is no way for users to view parameter values that are longer than the *fixed* size allotted in the right (?!?) side of the screen. Just put the parameters on the top of the screen same as in SSRS-stand alone.
Posted by vasugi andavar on 4/13/2015 at 10:01 AM
We are using Sharepoint 2013 integrated mode in our organization . I have a need for my project, where i have to move the SSRS Report Parameters to the top of the page shown using sharepoint reporting Services WebPart.
Our report contains 10 or more report parameters, so the user has to scroll down to enter the report parameters and Click Apply button. I do not want to create a custom webpart, just for the sake of positioning the report parameters. I know in SSRS report builder , the page is loaded using HTMLViewer, which displays the parameters at the top. But in sharepoint view it is using the rsViewer, which is displaying the paramters to the right. Is it possible to have both these options in Sharepoint 2013?
                Is there is any workaround for this issue, while microsoft consider this request and fix it on their end?
Posted by DDasgupta on 4/6/2015 at 10:10 AM
Is it possible to update Parameters panel header text from "Parameters" to "Filters"? Also the Apply button text from "Apply" to "Submit".
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!?