Implementing Mobile Reports in SQL Sserver 2016 Reporting Services

Implementing Mobile Reports in SQL Server 2016 Reporting Services Athens Nov 26, 2016

PresenterInfo 1982 I started working with computers 1988 I started my professional career in computers industry. 1996 I started working with SQL Server 6.0 1998 I earned my first certification at Microsoft as Microsoft Certified Solution Developer (3rd in Greece) I started my career as Microsoft Certified Trainer (MCT) with more than 25.000 hours of training until now! 2010 I became for first time Microsoft MVP on Data Platform I created the SQL School Greece www.sqlschool.gr 2012 I became MCT Regional Lead by Microsoft Learning Program. 2013 I was certified as MCSE : Data Platform & Business Intelligence 2016 I was certified as MCSE: Data Management & Analytics Antonios Chatzipavlis Data Scientist, SQL Server Evangelist MCT, MCSE, MCITP, MCPD, MCSD, MCDBA, MCSA, MCTS, MCAD, MCP, OCA, ITIL-F

Followus insocialmedia @antoniosch / @sqlschool fb/sqlschoolgr yt/c/SqlschoolGr SQL School Greece group

Sign up for a free membership today at sqlpass.org. Linked In: http://www.sqlpass.org/linkedin Facebook: http://www.sqlpass.org/facebook Twitter: @SQLPASS PASS: http://www.sqlpass.org

PresentationContent  Overview of SQL Server Mobile Reports  Preparing Data for Mobile Reports  SQL Server Mobile Report Publisher  Publishing Mobile Reports

Overview of SQL Server Mobile Reports

 Better experience for mobile users  Browser or Power BI for iOS, Android or Windows Phone  KPI and dashboard components  Draw together data from many sources  Consistent look and feel across desktop, mobile and tablet Why do we need Mobile Reports?

 Start from the source data, then link the source data to reporting elements  Use when:  Your source data is correctly formatted for mobile reports  The format of the source data is fixed (for example, when converting an existing report to a mobile report)  Shared Data Sets  Use SSRS shared data sets as a source for report data Data-First Approach to Mobile Reports

 Report layout is designed before data is available  Use when:  Data is not available in suitable format  To prototype report design  To guide data design Design-First Approach to Mobile Reports

 Very high-level performance indicators  Can be manually configured, or configured from data, or from a mixture of manual configuration and data  Security controlled at object level Mobile Report KPIs

Preparing Data for Mobile Reports

 Mobile reports perform fastest when they do minimal processing on small data sets  Pre-aggregate data for best performance  Pre-aggregation when using shared data sources allows performance tuning of source queries  Shared data set caching is most effective when minimal aggregation is done on cached result sets  Trade off between performance and reuse of data sets between reports Optimizing Reports with Pre-Aggregation

 Dates and times must be presented in a suitable format  Many formats are supported  Data sources with date and time types will typically present data in a suitable format  Be aware of date formatting in untyped data, and data from Excel  Most important for time navigator reports Formatting Time Data

 Each filter can only have one filter key column  Different filters on the same report can use different filter key columns  Hierarchical filter data for use with a Selection List navigator can be represented as an adjacency list Prepare Filter Data

 After Excel data is imported to a report definition, it must be reimported to pick up changes  Rules for using Excel data include:  One dataset per worksheet  Put column names in the first row  Use consistent data types  Format dates as dates  Use consistent formulas  Images, charts, and pivot tables will be ignored  Excel 2007 or later (.xlsx file format) Using Excel Files in Mobile Reports

 Configure firewalls to allow connection to mobile reports  No special requirements in addition to firewall rules required for access to SSRS  For Power BI app access:  SSRS must run in native mode  Basic authentication must be enabled  Enable SSL to prevent information leakage of user names and passwords when using basic authentication Enable a Report Server for Mobile Access

SQL Server Mobile Report Publisher

 Accessing SQL Server Mobile Report Publisher (SSMRP):  Direct download  Download via SSRS portal  Working with SSMRP:  Layout tab  Data tab  Settings tab  Preview tab What Is SQL Server Mobile Report Publisher?

 A report can be built from multiple datasets  Formal relationships do not need to be defined between datasets  Two sources of datasets:  Excel workbook  SSRS Shared Datasets Adding Datasets

 Navigators:  Time navigator  Selection list  Scorecard grid Designing Reports  Visualizations:  Gauges  Charts:  Time Chart  Category Chart  Totals Chart  Comparison Chart  Pie and Funnel Charts  TreeMap  Maps  DataGrids

 Master view  5x10 grid  New elements are added in the master view  Tablet view  8x6 grid  Phone view  4x6 grid  Customizing views Phone, Tablet, and Master Views

Implementing Mobile Reports in SQL Sserver 2016 Reporting Services

More Related Content

What's hot

Viewers also liked

Similar to Implementing Mobile Reports in SQL Sserver 2016 Reporting Services

More from Antonios Chatzipavlis

Recently uploaded

Implementing Mobile Reports in SQL Sserver 2016 Reporting Services