Principles of Report Writing

Principles of Report Writing
Slide Note
Embed
Share

Learn about the basic elements and applications used in creating and managing reports. Explore the process of report deployment and understand the necessary elements to create a report, including data sources, datasets, and stored procedures. Discover the significance of T-SQL and stored procedures in report creation. Covering essential concepts, this resource sets the foundation for effective report writing.

  • Report Writing
  • Paginated Reports
  • Data Sources
  • T-SQL
  • Stored Procedures

Uploaded on Feb 15, 2025 | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript


  1. Principles of report 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 Where? What? How? Machine name Database Name Authentication What tables? What rows? What columns? Presentation Layout Text/graphs Data Source Dataset Report Objects/ Layout

  7. Data Source -Wheres the Data? Machine Name: MP Server Name Database: MP Database Name Authentication: SQL Server login

  8. Data Source Connect ion Properti es

  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. MP Database Report Authoring Tools Visual Studio Report Builder Data Source Data Source: Microsoft SQL Server Computer Name: MP Database Name: MinistryPlatform Authentication: SQL User and password Report File (.rdl file) RMC E Phone Schedule Dataset Stored Procedure @DomainID varchar(40) @UserID varchar (40) @Page ID int

  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. SqlServer 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 Assign Your Report To a MP Page Create Report Object In MP Assign User Permissoins In MP 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

Related


More Related Content