80 likes | 230 Views
SQL Server 2008 R2 Reporting Services. Chris Testa-O’Neill BI Practise Consultant EMC Consulting. Practise Consultant at EMC Consulting MCT for over 10 Years. Technical Author for Microsoft E-Learning www.SQLBits.com Manchester and Leeds SQL Server User Group Organiser
E N D
SQL Server 2008 R2 Reporting Services Chris Testa-O’Neill BI Practise Consultant EMC Consulting
Practise Consultant at EMC Consulting MCT for over 10 Years. Technical Author for Microsoft E-Learning www.SQLBits.com Manchester and Leeds SQL Server User Group Organiser www.sqlserverfaq.com Who Am I
Agenda • Accessing Data • Data regions • Report Builder 3
Accessing Data SQL Server Azure SQL Server Parallel Data Warehouse SharePoint List Shared Dataset rsd files Report Property changes
Increased Expressions Nested Aggregations New Global Variable – RenderFormat =iif(Globals!RenderFormat.Name="EXCEL",TRUE,FALSE) Properties: Hidden, Row Visibility Expressions, Page Breaks