Windows Azure SQL Reporting Succinctly

OVERVIEWWindows Azure SQL Reporting provides a flexible platform for managing and viewing reports. Its cloud-based architecture means that its services are instantly scalable for any number of users—adding and removing servers through Windows Azure is significantly simpler than managing on-site servers—and maintenance costs are kept to a minimum. With Windows Azure SQL Reporting Succinctly by Stacia Misner, you'll learn how to set up a SQL Database server, migrate your existing data to the cloud, design report items, and deploy complete reports to the server. Instruction is also provided for managing user roles and creating reusable report parts.TABLE OF CONTENTS• Introduction to SQL Reporting• Getting Started• Report Development• Report Management• Report Parts• Security• Report Access The Story behind the Succinctly Series of Books 8 About the Author 10 Chapter 1 Introduction to SQL Reporting 11 What Is SQL Reporting? 11 How Does SQL Reporting Compare to Reporting Services? 12 Why Use SQL Reporting? 14 Small Company 14 Large Company 15 Limited Project Lifespan 15 Cloud Application Developer 16 Chapter 2 Getting Started 17 Windows Azure Setup 17 SQL Database Setup 17 Data Migration Options 19 Deploy Database Wizard 19 Database Script 20 Windows Azure Data Sync 21 Data-Tier Application Export and Import 22 Windows Azure Blob Storage Account 22 BACPAC Export 23 Migration into SQL Database 25 SQL Server Integration Services 25 Bulk Copy Utility 27 SQL Reporting Setup 28 Chapter 3 Report Development 29 Tools 29 Report Development Fundamentals 30 Report Projects 30 Report Items 37 Expressions 43 Report Parameters 49 Filters 52 Query Parameters 54 Subreports and Drillthrough 54 Interactivity 55 Actions 58 Pagination 60 Report Builder 66 Getting Started Wizard 66 Report Development in Report Builder 67 ReportViewer Control 67 On-Premises Application 67 Windows Azure Application 69 Chapter 4 Report Management 72 Report Deployment 72 Redeployment 73 Data Source Management 73 Execution Log 74 Server Usage Statistics 75 Report Server Properties 76 General Properties 77 Execution Properties 78 Chapter 5 Report Parts 79 Benefits of Report Parts 79 Report Part Creation 79 Report Part Deployment 80 Deployment from Report Designer 80 Deployment from Report Builder 82 Report Part Redeployment 82 Report Part Management 83 Report Part Gallery 83 Update Notification 84 Chapter 6 Security 86 Role-Based Security 86 Item Roles 86 System Roles 87 Users 87 Report Server Item Permissions 88 Chapter 7 Report Access 90 Web Service URL 90 Rendering Formats 91 Excel 92 Word 93 MHTML 93 PDF 94 TIFF 94 CSV 94 XML 95 My Reports Folder 96 URL Access 97 Report URL 97 URL Access Parameters 97 Windows Azure,SQL Reporting,succinctly,database,SQL Getting started with SQL Reporting