Principles of report writing

Download this Presentation

0

Presentation Transcript

  • 1.Principles ofreport writing Creating Paginated Reports with Report Builder 3.0
  • 2.Hello! I am Matt Patterson IT Director/Pastoral Care Rocky Mountain Calvary Colorado Springs, CO mattp@rmcalvary.org
  • 3.Session Purpose The basic elements of a report Applications used to create/manage reports Report Deployment to MP Demo: Create a simple report and make it available within MP
  • 4.Reporting Elements Understanding the Basic Concepts of a Report
  • 5.What is a report? A report is a one or more datasets formatted to share as a printed document or a PDF file
  • 6.Three Necessary Elements to Create a Report What? What tables? What rows? What columns? Dataset Where? Machine name Database Name Authentication Data Source How? Presentation Layout Text/graphs Report Objects/ Layout
  • 7.Data Source - Where’s the Data? Machine Name: MP Server Name Database: MP Database Name Authentication: SQL Server login
  • 8.Data Source Connection Properties
  • 9.Dataset – What Data Do You Want? The set of data to be displayed in your report. MUST be created as a stored procedure (SP) with three parameters Domain GUID User GUID Page ID Assign prefixes to SP names RMC_report_Staff_Phone_Schedule
  • 10.What the Heck is T-SQL or a Stored Procedure? T-SQL (Transact-Structured Query Language) SELECT = Read, INSERT = Add, UPDATE = Change, DELETE = Remove A Stored Procedure = Complied and saved T-SQL code.
  • 11.Place your screenshot here Stored Procedure Example
  • 12.
  • 13.Report Authoring and Management SQL Server Reporting Services & Report Builder 3.0
  • 14.Report authoring tools Visual Studio & Report Builder
  • 15.Place your screenshot here Report Builder 3.0 Notice the “Office” like interface
  • 16.Sql Server Reporting Services (SSRS) Web application used to store and manage report files
  • 17.Place your screenshot here SQL Server Reporting Services (SSRS) The version of SSRS installed with SQL Server 2012 Default path: http://[Computer_Name]/reports
  • 18.Deploying Your Report Using the System Setup area in MP
  • 19.Deploying Reports in MP Create Report Object In MP Assign User Permissoins In MP Assign Your Report To a MP Page Reports are configured in the System Setup and Administration sections in MP
  • 20.Place your screenshot here Create Report Object and Assign to Page
  • 21.Place your screenshot here Assign User Permissions
  • 22.Demonstration Let’s Do This!
  • 23.Thanks! Any questions? You can find me at: mattp@rmcalvary.org Presentation Resources https://rmcalvary.org/mpug2018