PEPconnect

SQL Server Reporting Service (SSRS) for the Basic User

This web based training will provide the basic SQL Server Reporting Service (SSRS) user with the information required to run and export reports.  This training applies to syngo Workflow SLR VB20 and higher.

By the end of this training you will be able to:
  • Describe the folder structure from within Report Manager
  • Run a report
  • Export report outputManage existing reports

Welcome to this web based training on the SQL Server Reporting Service (SSRS) for the Basic User. You should now be able to: Describe the folder structure from within Report Manager Run a report Export report output By the end of this training you will be able to: Describe the folder structure from within Report Manager Run a report Export report output SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It is part of  the suite of Microsoft SQL Server services. SSRS is a set of readymade tools, that helps to create, deploy and manage reports. Report Manager Web Based Tool Used to run reports, manage reports, folders, and subscriptions Access via URL supplied by system administrator Used by RIS administrator, management Report Builder Used to create and/or modify reports Access from within Report manager Used by RIS administrator, SQL administrator Report manager folder structure How to run a report How to export report output How to idenfity the different types of folder items How to navigate folders The model folder structure Reports Shared Datasets Report parts Folders Data Source Left click to open folder Large text is current folder name Blue text is full folder path Production (PRD)    Datasets    ReportParts    Reports    PRD (DataSource) Training (TRN)   Datasets   ReportParts   Reports   TRN (DataSource) Test (TST)   Datasets   ReportParts   Reports   TST (DataSource) Warning: DO NOT MODIFY the Model Structure   Within the PRD folder are three subfolders and the PRD Data Source Within the Datasets folder are all the model datasets. Within the ReportParts folder are all the model report parts. Within the Reports folder are all the model reports. Details View Last Run Modified Date Modified By To run a report: Left click on report Enter Parameters Click View Report Click the link below to view a video example of this process. *To gain maximum benefit from this WBT, it is recommended that you practice these step by step instructions directly on your system. How to Run a Report How to Run a Report   Browse output pages Change zoom level Search the report Export the output Refresh the data Print the output.  Hover over the image below to see details on each of these functions.

  • ssrs
  • sql