<Disclaimer>This is personal notes of what I retained during the session. This can be incomplete, partially right or wrong. It is just part of the notes I took and what retained my attention. Nothing prevents the user to get more information on their favorite web site.</Disclaimer>

Nowadays, providing reporting capabilities to SharePoint is quite challenging and require different skillset.

With Denali, available in CTP3, it will come as a shared service, will support WCF and Claims Based communications, Powershell, administration will be done in the Central Administration and logging will be done in the ULS. In terms of performance, report viewer will use AJAX and a performance improvement of 30-60% is expected.

There is a separate pack for the Add-In to be installed on the WFEs and scripting will be done using PowerShell instead of WMI. For the configuration, just go in the Service Application of the Central Administration.

Today, people are overloaded by the amount of data, the number of reports generated can be too much for the users. With the alerting system of Denali, it is possible to set an alert for a report in order to be notified when data used in that report have changed. But, be careful, because it can be a good spam generator. It is possible to assign rules, schedule, parameters to an alert.

Denali supports the new 2007/2010 format, for Word and Excel and compressed files can be generated. Rdl files will also have a new format, rdlx.

The Crescent Project is “an interactive data exploration and visual presentation experience???…A demo is shown where an interactive report is built in a web browser, with table, and chart.

BIDS, RDLC Designer and Report Viewer controls will be available into VS2010. Microsoft is also working in moving to Dev 11. The goal is to separate the RS VS Addin. SQL Azure Reporting is the Reporting on the Cloud solution. It means that report can be built in BIDS and then deployed on Azure, from BIDS as well, in order to benefit of the same features of Azure. Currently, it is limited to SQL Azure data. The reports can also be embedded in your Azure application.