Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center > SQL Server Forums > SQL Server Reporting Services

SQL Server Reporting Services

Report Server, Report Designer, Report Builder, and other reporting-related discussions. 

Announcements

  • Reporting Services 2008 - Resources & Latest Downloads (SP2)

    Robert BrucknerMicrosoft EmployeeThursday, February 05, 2009 9:44 PM
    Last update: Mar 27, 2011.


    Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services! 

    Important downloads for Reporting Services 2008:  

    SP2:

    SP1:

    RTM:


    Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release.

  • Reporting Services 2005 - Resources & Latest Downloads (SP4)

    Robert BrucknerMicrosoft EmployeeThursday, February 05, 2009 9:44 PM

    Last update: Mar 27, 2011.

    MSDN information aggregator site for Reporting Services 2005. 

    Important downloads for Reporting Services 2005:

    SP4:

    SP3:

    SP2:

     

  • SQL Server 2012 CTP3 - Project Crescent, Alerting, etc.

    Robert BrucknerMicrosoft EmployeeTuesday, July 12, 2011 6:15 PM

    There are many new exciting capabilities in CTP3 for Reporting Services. More details can also be found on the Reporting Services Team blog, with a brief overview below.

    SQL Server “Denali” CTP3 available for download: https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/ 
    Feature pack is available as well: http://www.microsoft.com/download/en/details.aspx?id=26726

    What’s new in Reporting Services in Denali CTP3?

    Project “Crescent”

    Project Crescent is about interactively visualizing data, quickly gaining analytical insights, and generally having fun with data!

    Crescent is Reporting Services’ new reporting tool targeted at data consumers to visually explore their data, answer ad-hoc questions with ease, and to present and collaborate with others in a SharePoint environment. Crescent is a thin browser experience and is working against a BI Semantic Model. BI Semantic Model is available on the client through the Excel-based Power Pivot modeling tool, or on the server through Analysis Services Tabular project with Denali CTP3.

    You can find a Project Crescent Overview on Technet. Furthermore, you can watch these session recordings from the recent Tech Ed conference:

    Crescent was also shown in today’s keynote at the Worldwide Partner Conference.

    Car category sales vs gas priceSLA dashboard

    Self Service Alerting

    Alerting is a new capability that we are adding to Reporting Services as well. It enables an end-user to setup alert rules and be alerted when report data changes occur that match a set of rules. No changes are required to the existing reports – you can create alerts for any reports created in previous versions of Reporting Services, as soon as upgrade/move to SQL Server Denali in SharePoint integrated mode.

    SharePoint Shared Service

    Reporting Services in SharePoint now runs as a SharePoint shared service. Among other benefits, this provides integration with claims authentication and scaling and load-balancing across the SharePoint farm. Furthermore, report viewing performance in SharePoint has been enhanced significantly.

    Excel rendering as XLSX, Word rendering as DOCX

    These new renderers produce now Open XML Office format and take advantage of some of the new capabilities in Office 2007 and 2010, such as export up to a 1 million rows in Excel. The original renderers for DOC and XLS, which produce binary formats for older Office versions are still available but hidden by default.

    BI Development Studio integrated in Visual Studio 2010

    Not only did we adopt the Visual Studio 2010 shell for BI Development Studio for report design, but we also rearchitected our integration with Visual Studio in general for RDLC designer and report viewer controls. This will be available with the upcoming next version of Visual Studio and enable much more simultaneous availability of SQL Server Reporting Services functionality in Visual Studio as well.

     

    Enjoy!

  • SQL Server 2012 RC0 - Power View

    Robert BrucknerMicrosoft EmployeeFriday, November 18, 2011 5:08 AM

    You can download RC0 here: http://www.microsoft.com/download/en/details.aspx?id=28145.

    This post summarizes much of the new functionality in Power View with RC0.

    Multiple Views in a Single Report

    You asked for it, and we are delivering it! Power View reports now support multiple views per report. The report pictured below contains a total of five views that you can see previews of to the left of the canvas.

    MultipleViews

    Export to Microsoft PowerPoint

    Along with the ability to create reports with multiple views, you can also export your report to PowerPoint. These are not just static images. Power View reports inside PowerPoint are fully interactive.

    PowerPoint Export

    PowerPivot Gallery Preview Images

    Power View now produces preview images in the PowerPivot Gallery, just like Excel workbooks. They are supported in all views of the PowerPivot Gallery (gallery, theater and carousel).


    PowerPivot Gallery Preview
    In addition, now that Power View reports support multiple views in a single report, when you click on a specific view of the report, Power View will launch with that view as the active view.

    Storyboard

    When you are presenting reports with multiple views in them, there is way to navigate the views in a report called storyboard. Just hover to preview any of the views and select the one you want to display.

    Storyboard

    Sorting

    We are certain you saw this one coming, but Power View now supports sorting on all data regions. On tables and matrices, all you have to do is click on the column headers to sort. For charts, there is an area above the chart that we call the “floatie” that allows you to choose to sort the chart by a measure or its categories.ChartSorting

    For charts that are displayed as multiples, you can sort those too. For multiples, sorting sorts the charts themselves by a subtotal, and of course, it’s just a click away via the floatie as well.
    MultipleSorting

    More Chart Features

    Power View has added more functionality to charts. In particular, charts now support
    • more than 20 series,
    • multiple measures,
    • and color (series) in scatter and bubble charts.
    The chart below shows multiple measures in action, depicting the average win percentage of major league baseball both at home and on the road over a set of years.
    MultipleSeries
    In the next chart, you can see colors assigned on the scatterplot.
    ScatterPlot
    Of course, the feature works with legend highlighting as well. Select a market size from the legend and all of the points associated with that entry will be highlighted in the chart.
    ScatterPlotHighlighting

    Chart Highlighting Enhancements

    There is also significant change to the highlighting feature with charts. When your column and bar charts contain non additive data, Power View will now display the highlighted values with a thinner column that is overlaid on top of the previous values. This is done to make it possible to see the previous values, regardless of the highlighted values.
    It also makes it possible to see cases where the selected item from another visual has no representation in the chart. For example, in the chart below, not only can we see how Expressjet compares against the average of all carriers for flights delayed by carrier, but we also can see that Expressjet did not operate any routes greater than 1,500 miles.
    ChartHighlighting

    Number Formatting for Tables and Matrix

    Power View now supports number formatting on both tables and matrix.
    NumberFormatting

    Slicers Cross Filter Other Slicers

    When you have multiple slicers on a view now, if you select an entry in one slicer, the other slicers in the view are filtered by it.

    Per Data Region Filtering

    Filtering improvements are available in RC0. Power View now supports filters on each data region. The picture below shows the chart region filter selected in the filter pane. If you want to switch to filtering the entire view, just hover over the grey “view” text and select it and you’ll be on your way to filtering the entire view.
    Filtering

    Measure Filters and Filter Restatement

    There are two other new features in the filter pane depicted above as well. The filter pane now supports measure filters and will also restate your filters even when a specific filter is in its collapsed state.
    MeasureFiltering

    Search in Filters

    But we’re not done yet. Have a long list of categories that you don’t want to wade through, use the search feature.
    SearchFilter

    SearchFilterResult

    Drag Your Data to the Canvas

    You can now drag fields directly to the canvas from the model explorer. If you hover the field over the canvas, it will create a new table. If you hover the field over an existing visualization, it will add that field to the next logical location in the visualization.
    DragDrop

    Print it!

    You can now print your current view. Print is “what you see is what you get”.
    Print

     

    Support for DirectQuery mode

    DirectQuery mode for Analysis Services tabular models allows you to keep your data in a SQL Server relational database and still get the benefits of interactive reporting with Power View. You can read all about direct query mode here.

    Database Image Support

    Power View now supports database images stored directly in the model.
    DatabaseImages

    Show Items with No Data

    Often referred to as “outer join”, Power View now supports the ability to display items with no data. The table below shows this feature in action.
    OuterJoin
    And just like everything else in Power View, this feature is just a click away in the field well.
    FieldWellOuterJoin

    Measures as Non-Measures

    PowerView also supports the ability to treat measures as non-measures (i.e. as categories). To do this, you just go to the field well and choose the option on the field to “Do Not Summarize” as shown below.
    MeasuresAsNonMeasures
    Below is an example of a report showing the count of airline flights by minutes late. Minutes late is a measure in the table on the left. The table on the right is the same table with the “Do Not Summarize” feature turned on.
    DoNotSummarize

    All New Canvas Look

    We’ve changed the overall look of the canvas and many of the items that you can place on the canvas. Here are a couple of examples of the new look in action.

    PowerView1

    PowerView2

  • Reporting Services 2008 R2 - Resources & Latest Downloads

    Robert BrucknerMicrosoft EmployeeMonday, May 24, 2010 3:45 PM

    Last Update: Mar 4, 2011.

    SQL Server 2008 R2 was released to manufacturing on April 21, 2010.  You can read more about it here.

    Downloads available: 

    Cumulative Updates:

    You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP.  You can research and ask questions on the dedicated MSDN forum. 

  • Reporting Services Migration Tool v1

    Tristan FernandoMicrosoft EmployeeSunday, April 22, 2012 10:54 PM

    We have released a beta version of the Reporting Services Migration Tool.  The tool is available for download at:

    http://www.microsoft.com/download/en/details.aspx?id=29560

    This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server.  Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.).  Some additional details are in this blog post, along with the download link:

    http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx

    We are working on enabling more features in this tool, so feel free to share any feedback or report any issues.  Thanks!

  • ** Please Include SSRS Version When Posting Questions

    Sean BoonMicrosoft EmployeeWednesday, April 22, 2009 4:45 AM
    When posting questions in this forum, please include the version of SQL Server Reporting Services you are using.  This will help us be more efficient in answering questions.  If you are using the Report Viewer Control, it will helpful if you include the version of the control as well. 

    Thanks,
    Sean

Filtering and SortingUse these options to narrow down the question and discussion list.

 
Items 1 to 20 of 5931512345Next ›Last »
 
RepliesViews
 
Items 1 to 20 of 5931512345Next ›Last »