Define Parameter pane placement. Allow Parameter pane placement at the top, right, left, bottom. Allow parameter pane to default to visible or hidden.
... View more
There are a couple of scenarios where column widths are not respected when exporting to Word. The most common is where a nested table has a column with "narrow" content - the column width sometimes shrinks to contents. The other is when a column contains a long word with no spaces or breaking characters - the Word column width is increased to the width of that word.
... View more
In Reporting Services, when you design a report, the parameter section has limited functionality. User can only change sequence of parameters. Besides that, user has no control over the parameters like background colors, size of fields, combining and showing multiple fields in the dropdowns etc
... View more
Submitted on03-04-201503:56 AMSubmitted bychris_rosson03-04-201503:56 AM
SSRS is good for desktop users, but is very difficult to make great on mobile and tablet (esp w/in SP). I'd like to be able to design a single report and configure it to automatically re-size and re-layout objects according to the type and size of device being used. For example, a single report of 4 charts arranged left-to-right would be shown on individual pages (that could be flipped through) on a mobile phone.
... View more
Submitted on03-04-201504:30 AMSubmitted bychris_rosson03-04-201504:30 AM
I'd like to be able to control specific objects (using checkboxes, buttons, etc) on a page independent of the overall report parameters. For example, So if I've got two charts on a page but only want the user to see one at a time, I currently use drillthrough actions to reload the whole report. I'd like to add a button or link or some sort of control to the page to show/hide the two different charts.
... View more
Retain parameter focus with a large parameter list. Focus goes back to the top forcing users to scroll back down to finish parameter selection.
... View more
For SSRS Text Box controls, add a "Justify" option for the Horizontal/TextAlign property. This would produce fully justified text, as in Word. This feature supports automated production and distribution of documents of publication quality. This has been an open Connect item for over 5 years, gathering over 500 votes: https://connect.microsoft.com/SQLServer/feedback/details/404966/full-justification-in-reporting-services-2008-needed
... View more
Allow Charts to switch rows to columns or vice versa at design time to display the data on the axis that you want. Similar functionality exists in excel.
... View more
Buggy behaviors in RB make users give up (especially less-technical business users who this tool was designed for). The rest of us just get angry. These include: - Sometimes (inconsistently), pressing Enter will close the expression window and other time is adds a carriage return. - VB functions are (sometimes) translated to full-qualified object references which confuses users. - Certain field properties are changed when a data region is copied and pasted (example .UniqueName is changed to .Value) - Expression window just hangs & then crashes.
... View more
Centralized management tools for subscriptions for SSRS reports. Running in SP integrated mode we need a way to see in the SP subscription list something unique to visually identify subscriptions. Something as simple as displaying a comment or allowing the subscriptions "manager" to enter a name/title for the subscription. We also need a consolidated view/report to see all the subscriptions with the parameters and schedule selected as well as the user email address would be helpful.
... View more
System Administrator ought to be able to see all subscriptions running on their system to schedule subscriptions to fire at non-peak hours or to avoid heavy reports hitting their SSRS servers all at once. We shouldn't have to buy or develop anything separate to do this.
... View more
Creating a Reporting Services dataset based on a DAX query driven by parameter values created using MDX queries is currently a nightmare. The process is complex using the DMX editor and string expressions in order to build a dynamic DAX query to be run against a tabular model. There are significant performance benefits using DAX queries vs. MDX queries when returning detail data sets for drill through reports against a large tabular model. I believe that creating better support for DAX queries within Reporting Services would help to drive usage of Analysis Services Tabular models and help Microsoft BI users unlock the incredible capabilities of the stack.
... View more
Add dynamic actions and effects to reports to make them more interactive. There are several great examples of after-market products and projects that demonstrate what could be accomplished by adding JavaScript support to SSRS rendering, such as d3js.org. I think this is what many users consider to be a "modern" report UI. The work that Jason and his group have done at ForeRunner SW using JSON to layer JavaScript over SSRS in the rendering phase demonstrates how the current product could be enhanced in very specific ways.
... View more
Parameters are the key to building interactive reporting solutions but complex report designs can become difficult to maintain. Let's say that I have ten items on a dashboard style report that pass all the parameters back to the same report (which is necessary to maintain the state of previously-selected parameter values)... Now I add one more parameter to the report and I have to find every item with an action to add that parameter. If there were some kind of a parameter collection object, similar to the property bag in old VB or the Request/Response/Application/Cookies objects commonly used in ASP.NET; this could be used to add the new parameter to the collection and simply pass the whole thing as an object to maintain the state of previously selected values. I have several specific thoughts and examples to share on this subject.
... View more