Denali CTP3: Project Crescent, Alerting, etc.

    Diskusi Umum

  • 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.



    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    12 Juli 2011 18:26

Semua Balasan

  • Hi,

    Is the feature Self Service Alerting available for the reporting service server in native mode? And Is there API to call to manage a alert in a custom BI application?

    Thank you,

    17 Agustus 2011 13:14
  • As mentioned in the announcement email above, self service alerting is only available in SharePoint Integrated mode in Denali.  The new Alerting UIs for creating and managing Alerts are all based on new and/or existing public APIs of the RS webservice.  You could call those APIs from your own application as well.


    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    17 Agustus 2011 20:00