SQL SERVER REPORTING SERVICES: FUNDAMENTALS
HOW THIS BOOK IS ORGANIZED PART I: JUST THE BASICS PART II: BUILDING REPORTS — YOUR CREATIVITY OPTIONS PART III: PUBLISHING, ACCESSING, AND SUBSCRIBING TO REPORTS PART IV: MAINTAINING YOUR REPORTS PART V: DEVELOPING ADVANCED REPORTS PART VI: MIGRATING FROM OTHER REPORTING TOOLS PART VII: THE PART OF TENS HOW TO USE THIS BOOK FOOLISH ASSUMPTIONS I MAKE ABOUT YOU ICONS USED IN THIS BOOK GETTING STARTED DEALING WITH REPORTING CHALLENGES MASTERING REPORTING PRINCIPLES PRESENTING THE RIGHT INFORMATION USING THE RIGHT MEDIUM PRESENTING TO THE RIGHT AUDIENCE OFFERING THE RIGHT CONTENT AND DESIGN PROVIDING THE RIGHT SECURITY INVESTIGATING BUSINESS DATA UNCOVERING THE MAJOR FEATURES OF REPORTING SERVICES IT’S A WEB SERVICE WORKING WITH THE DESIGN SURFACE CONNECTING TO A DATA SOURCE CREATING THE LAYOUT USING EXPRESSIONS AND FORMULAS FILTERING, SORTING, AND GROUPING DEFINING PARAMETERS NAVIGATING AND FACT-SEEKING FORMATTING THE CONTENT SAVING A REPORT DISPLAYING A REPORT MANAGING REPORTS SECURING A REPORT DISTRIBUTING A REPORT ACCESSING AND LOOKING AT REPORTS PRINTED REPORTS VERSUS ONLINE REPORTS VIEWING A REPORT DISCOVERING WHAT MAKES A DATABASE KEYING IN ON YOUR DATA STRIKING UP A RELATIONSHIP WITH YOUR DATA BUILDING A SQL QUERY BEING SELECTIVE FOLLOW ALONG WITH SQL SERVER QUERY ANALYZER WHERE YOU JOIN THE PARTY ORDER IN THE COURT GROUP BY FOR SUBTOTALS HAVING FOR FILTERING RESPECTING THE STORED PROCEDURES FACING DOWN THE BI DEVELOPMENT STUDIO WORKING WITH YOUR REPORTING PROJECT ESTABLISHING A SHARED DATA SOURCE WELCOME TO THE REPORT DESIGNER WORKING WITH YOUR DATA SKETCHING OUT YOUR DESIGN LAYOUT MODIFYING YOUR REPORT FORMATTING IN LAYOUT VIEW SAVING YOUR REPORT PRINTING THE REPORT ACCESSING THE WIZARD ESTABLISHING THE DATA SOURCE QUERYING THE DATA DESIGNING THE TABLE AND STYLES LAYING OUT THE REPORT — LAYOUT AND STYLE REPORT DESIGN SURFACE USING YOUR TOOLBOX IN THE WORKSHOP INTERACTING WITH DATASETS WORKING WITH DATA REGIONS AND OTHER REPORT ITEMS SETTING REPORT ITEM PROPERTIES USING TEXTBOXES FOR LABELS AND CAPTIONS USING TABLES FOR TABULAR DISPLAY USING A MATRIX FOR CROSS TABS USING RECTANGLES FOR SEPARATE REPORTS USING LISTS USING SUBREPORTS FOR CONTAINERS USING LINES FOR FORMATTING USING IMAGES FOR LOGOS USING CHARTS FOR VISUALIZATION SORTING, GROUPING, AND FILTERING SORTING AND FILTERING REPORT DATA GROUPING RELATED FIELDS NESTED GROUPINGS GROUPINGS WITH OTHER DATA REGIONS GROUPING WITH MATRIX CONTROLS ADDING A COLUMN GROUPING TO A MATRIX GROUPING WITH LIST CONTROLS USING NESTED LISTS SORTING AND GROUPING WITH CHARTS FILTERING DATA IN REPORTS USING EXPRESSIONS AGGREGATE FUNCTIONS ADDING CALCULATED COLUMNS TO A REPORT DISCOVERING HOW TO USE PARAMETERS REPORT PARAMETERS QUERY PARAMETERS USING PARAMETERS IN A REPORT USING CASCADING PARAMETERS IN A REPORT FORMATTING REPORTS HEADERS AND FOOTERS PAGINATING REPORTS — IS THAT LEGAL? SIZING THE PAGE CREATING MULTI-COLUMN REPORTS USING EXPRESSIONS IN FORMATTING REPORTS CUSTOM CODE CREATING A REPORT MODEL CREATING A MODEL PROJECT DEFINING A DATA SOURCE CREATING A DATA SOURCE VIEW DEFINE A REPORT MODEL FOR AD HOC ANALYSIS PUBLISH A REPORT MODEL PROJECT WORKING WITH THE REPORT BUILDER LAUNCHING REPORT BUILDER CREATING REPORTS IN REPORT BUILDER SORTING, GROUPING, AND TOTALING WITH REPORT BUILDER DRILL-DOWN ANALYSIS WITH REPORT BUILDER PUBLISHING REPORT BUILDER REPORTS TO REPORT MANAGER DEPLOYING REPORTS DEPLOYING A REPORT FROM REPORT DESIGNER SAVING A REPORT FROM REPORT BUILDER INTRODUCING THE REPORT MANAGER ACCESSING THE REPORT MANAGER UPLOADING A REPORT TO REPORT MANAGER VIEWING A REPORT IN REPORT MANAGER GETTING AROUND IN REPORT MANAGER THE REPORT TOOLBAR PRINTING A REPORT EXPORTING REPORTS TO OTHER FORMATS DESIGN CONSIDERATIONS FOR EACH RENDERING EXTENSION ARCHIVING REPORTS SAVING REPORTS TO CREATE AN ARCHIVE SAVING REPORT HISTORY OUT OF SITE: SERVER-LEVEL PROPERTIES UNDERSTANDING THE PULL MODEL TYPES OF REPORTS: PUBLISHED, INTERMEDIATE, AND RENDERED EXECUTING WITH THE LATEST DATA SAVING YOUR CACHE WORKING WITH THE SESSION CACHE CREATING WITH THE CACHED INSTANCE CONSIDERING QUERY PARAMETERS WITH CACHED INSTANCE CONSIDERING FILTERS WITH CACHED INSTANCE CONFIGURING A CACHED INSTANCE ORGANIZING SNAPSHOTS CREATING A SNAPSHOT USING QUERY PARAMETERS IN YOUR SNAPSHOTS USING FILTERS IN YOUR SNAPSHOTS CONFIGURATION GUIDELINES ON SNAPSHOTS CREATING A HISTORICAL PERSPECTIVE CREATING REPORT HISTORY CREATING SNAPSHOTS IN REPORT HISTORY MODIFYING PROPERTIES AND DELETING REPORT HISTORY RENDERING HISTORY AS A URL SUMMARY OF REPORT EXECUTION METHODS AUTOMATING THE DELIVERY OF REPORTS ACCESSING SUBSCRIPTIONS GETTING FAMILIAR WITH SUBSCRIPTION COMPONENTS WORKING WITH E-MAIL DELIVERY WORKING WITH FILESHARE DELIVERY SELECTING A RENDERING FORMAT SPECIFYING EXECUTION CONDITIONS SPECIFYING EXECUTION PARAMETERS CREATING STANDARD SUBSCRIPTIONS CREATING A STANDARD SUBSCRIPTION CREATING DATA-DRIVEN SUBSCRIPTIONS SUPPORTING A FLUCTUATING LIST OF SUBSCRIBERS FILESHARE DELIVERY OF DATA-DRIVEN SUBSCRIPTIONS E-MAIL DELIVERY OF DATA-DRIVEN SUBSCRIPTIONS NULL DELIVERY OF DATA-DRIVEN SUBSCRIPTIONS USING SUBSCRIPTION FOR COMMON BUSINESS SCENARIOS PRELOADING A SNAPSHOT REPORT PROVIDING ACCESS TO LATEST REPORTS IN A FILE DIRECTORY BROADCASTING EXCEPTION REPORTS BURSTING REPORTS MAINTAINING YOUR SUBSCRIPTIONS WORKING WITH INACTIVE SUBSCRIPTIONS EXECUTION MODE MODIFICATIONS AND SUBSCRIPTION PROCESSING MANAGING SUBSCRIPTIONS WITH MY SUBSCRIPTIONS CONFIGURING SUBSCRIPTION PROCESSING MANAGING YOUR REPORTS USING MANAGEMENT STUDIO USING REPORT MANAGER UPLOADING FILES MOVING FILES USING LINKED REPORTS SEARCHING FOR REPORTS NAVIGATING HIERARCHIES IN REPORT MANAGER WORKING WITH THE MY REPORTS FOLDER ADMINISTERING REPORTING SERVICES APPLYING TIMEOUTS USING TRACE FILES USING THE EXECUTION LOG QUERYING THE REPORT EXECUTION LOG UNDERSTANDING DATABASE STORAGE UNDERSTANDING SECURITY FUNDAMENTALS INTRODUCING THE AUTHORIZATION MODEL CREATING ROLE ASSIGNMENTS MAINTAINING ITEM-LEVEL SECURITY USING SYSTEM-LEVEL SECURITY BEST PRACTICES FOR PROTECTING AGAINST AN ATTACK SECURE SUPPORT FOR EXTERNAL USERS UNDERSTANDING DATA SECURITY MONITORING REPORT SERVER PERFORMANCE USING TASK MANAGER USING EVENT VIEWER USING PERFORMANCE CONSOLE STRATEGY FOR PERFORMANCE TUNING BENCHMARKING SYSTEM PERFORMANCE SEARCHING FOR PERFORMANCE BOTTLENECKS TUNING SYSTEM PERFORMANCE UNDERSTANDING DATABASE REQUIREMENTS FOR REPORT SERVER REPORTS, FOLDERS, SHARED DATA SOURCE ITEMS, AND METADATA RESOURCES SESSION STATE INFORMATION CACHED REPORTS REPORT HISTORY SNAPSHOTS AND REPORT EXECUTION SNAPSHOTS PROVIDING ADEQUATE SPACE FOR CACHING CONFIGURING REPORTING SERVICES COMPONENTS CONFIGURING AND RUNNING LARGE REPORTS RENDERING REPORTS DISTRIBUTING REPORTS USING PARAMETERS AND FILTERS USING SNAPSHOTS CACHING IN ON PERFORMANCE USING VISIBILITY OPTIONS HIDING ITEMS IN A REPORT DRILLING DOWN ON REPORTS DRILLING DOWN A RECURSIVE HIERARCHY DYNAMICALLY VISIBLE DATA REGIONS USING NAVIGATION TECHNIQUES ADDING BOOKMARK LINKS ADDING HYPERLINKS USING DOCUMENT MAPS USING TOOLTIPS INTERACTIVE SORTING DRILLING FROM SUMMARY TO DETAIL DRILLING DOWN AND PIVOTING ON DETAIL LINES PROVIDING MULTIPLE DRILL-DOWN OPTIONS PROVIDING NAVIGATION LINKS TO REPORTS HANDLING MULTIPLE DRILL PATHS PREPARING A REPORT MENU PAGE DISCOVERING OLAP CAPABILITIES LEARNING THE DIMENSIONAL MODEL JUST THE FACTS, MA’AM UNDERSTANDING DIMENSIONS CONSTRUCTING CUBES INTRODUCING MICROSOFT ANALYSIS SERVICES GAINING PERSPECTIVE SPEAKING THE LANGUAGE OF OLAP BUILDING AN MDX QUERY DEFINING CALCULATIONS WITH MDX DEFINING KPIS WITH MDX CREATING REPORTS WITH OLAP CUBES CONNECTING TO AN OLAP DATA SOURCE CREATING AN OLAP REPORT WITH THE REPORT WIZARD CREATING AN OLAP REPORT WITHOUT THE REPORT WIZARD MONITORING ENTERPRISE PERFORMANCE UNDERSTANDING KEY PERFORMANCE INDICATORS MEASURING CORPORATE PERFORMANCE OFFERING IMMEDIATE BUSINESS INSIGHT BUILDING THE PRESENTATION GETTING A FIRST LOOK AT INDICATORS ENSURING INTUITIVE NAVIGATION SHIFTING TO A CUSTOMER VIEW TRACKING PRODUCTS USING PROFILES TO HIGHLIGHT DETAIL SEARCHING FOR LOW MARGIN CULPRITS ACCESSORIES TO THE EXECUTIVE ANALYSIS USING CHARTS FOR TREND ANALYSIS GETTING DOWN TO THE DETAILS INTEGRATING AD HOC ANALYSIS SHARING THE WEALTH OF INFORMATION REVIEWING REPORTS OFFLINE PUBLISHING SPECIAL SUPPORTING ANALYSES INTRODUCING OTHER REPORTING PLATFORMS MICROSOFT ACCESS REPORTING BUSINESS OBJECTS COGNOS REPORTNET REPORTING SERVICES COMPARING DATA RETRIEVAL FEATURES RETRIEVING DATA FROM A DATABASE COMPARING REPORT DEVELOPMENT USING A REPORT WIZARD STYLING WITH REPORT TYPES ACCESSORIZING REPORTS REPORTING WITH PARAMETERS AND FORMATTING OPTIONS REPORT BUILDER FOR AD HOC REPORTING BY BUSINESS USERS COMPARING PUBLISH, SUBSCRIBE, AND ACCESS PUBLISHING YOUR REPORTS ACCESSING REPORTS ON DEMAND DELIVERING REPORTS COMPARING MANAGEMENT AND ADMINISTRATION OF REPORTS MANAGING YOUR REPORTS SECURING INFORMATION COMPARING ADVANCED REPORTING CAPABILITIES MAKING REPORTS INTERACTIVE REPORTING FROM OLAP SOURCES REPORTING FOR EXECUTIVE USE COMPARING PRICE TOOL COMPARISON TAKEAWAYS IMPORTING THE ACCESS REPORT UNDERSTANDING HOW ACCESS REPORTS DIFFER FROM REPORTING SERVICES SUPPORTING CAST FOR REPORTING SERVICES MAKING SURE EVERYTHING CONVERTS TIGHTENING UP REPORTS AFTER CONVERSION UPSIZING AN ACCESS DATABASE AND REPORTS HIGH PERFORMANCE AND SCALABILITY INCREASED AVAILABILITY IMPROVED SECURITY IMMEDIATE RECOVERABILITY SERVER-BASED PROCESSING UPSIZING YOUR ACCESS DATABASE GREENBAR PAPER FORMATTING CONTROLLING PAGE BREAKS RUNNING TOTALS SIMULATING END-USER SORTING SIMULATING THE ALL PARAMETER VALUE DYNAMICALLY CREATING A REPORT QUERY CHANGING THE REPORT MANAGER FOLDER ICON TO A CORPORATE LOGO SUPPRESSING OBJECTS OR FORMULAS IN AN EXCEL RENDERING OF A REPORT SECURING REPORTS WITH A USERID PARAMETER MEASURING AND IMPROVING REPORT PERFORMANCE ANALYSIS SERVICES INTEGRATION SERVICES DATA MINING CLUSTERING SUPPORT KEY PERFORMANCE INDICATORS SCALABILITY AND PERFORMANCE ONE-CLICK CUBE PROACTIVE CACHING INTEGRATION WITH MICROSOFT OFFICE MICROSOFT SQL SERVER REPORTING SERVICES WEB SITE SAMPLE DATABASES FOR REPORTING REPORT PACKS REPORTING SERVICES NEWSGROUP CHAT OR WEBCAST OLAP REPORTING SQL SERVER MAGAZINE SQL SERVER DEVELOPMENT CENTER GENERAL BI LINKS ATTUNITY CIZER SOFTWARE DUNDAS SOFTWARE FENESTRAE GFI OUTLOOKSOFT PANORAMA SOFTWARE PROCLARITY PROPOSION OFFICEWRITER