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