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
Improve Reporting Services (or converge it with Power BI). SSRS hasn't been improved very much in the last versions. For many uses cases SSRS still offers features such as export to several formats (PDF, Word, Excel...) which are not covered by Power BI.
... View more
SSRS is rapidly going stale. client side interactive reporting like Highcharts and dygraphs should be native to the Visual Studio SSRS environment. Stop adding the need for additional and other tools.
... View more
Support for more data sources such as OData, HDInsight/HDFS etc. Maybe converge the support/approach similar to the support in Power Query or PowerPviot.
... View more
In SSRS, the maps you design are static. We should have more functionality like dynamic zooming in and out, dynamic selection of objects on map, showing different levels of data at different level of zooming. Developers have to search online for map objects and then import it. We should have a bigger library of basic maps.
... View more
Submitted on02-04-201508:59 AMSubmitted byfbcideas_migusron02-04-201508:59 AM
Add a method by which you can see the reports you have navigated through to get where you are now. This enables you to jump back and also gives you a good idea of where you are in complex report heirarchies
... View more