Download

Principles of report writing

Upload
0
Embed
Share
Upload and view presentations on any device and embed the player to your website! --- > >
Upload PPT
Upload PPT

Download this Presentation

lll123456lll

2021-10-12 published at Spiritual/ Inspirational category

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

Latest Release