|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-reporting-services-ssrs/
课程评论：没有评论
课程名称：Microsoft SQL Server Reporting Services (SSRS) 课程概述： 在本课程中，您将学习如何使用SQL Server Reporting Services (SSRS) 创建报告。课程经过更新，采用Visual Studio 2022录制，适合所有水平的学习者，虽有一定的T-SQL基础会更有帮助。请注意，本课程并未与微软合作或获得其赞助。 我们将提供一个包含SSRS的SQL Server版本，并免费下载一个名为AdventureWorks的数据库，以便在报告中使用。在课程中，您将逐步创建各种报告，发展您的技能。 课程内容包括： - 选择报告组件（如矩阵、表格、图表等数据可视化组件） - 确定数据源及参数 - 设计分组结构 - 创建逐级报告和逐步报告 在报告布局的实现方面，您将学习： - 格式化技巧（包括颜色、日期和数字格式化） - 页面配置 - 实现页眉和页脚 - 在报告中实现矩阵、表格、图表、图像、指示器、地图和分组 - 创建多种使用不同数据区域的报告 - 定义自定义字段 - 实现全局集合和表达式 - 实现数据可视化组件 在报告的交互性实现方面，您将学习： - 创建逐级报告和逐步报告 - 添加交互式排序 - 研究参数（包括多值参数） - 使用参数创建动态报告 - 实现显示/隐藏属性 - 添加动作（跳转到报告和URL） - 添加固定页眉和文档地图 完成本课程后，您将能够自信地独立创建自己的SSRS报告。
Reviews:"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." - Koos ten Bras"Excellent course, well presented and clear examples." - Peter Cawthorne"Excellent Course, I just started a new job and after doing this course I now understand what I am looking at and working with with a fully built-up report." - BjornThis course is all about creating reports in SQL Server Reporting Services (SSRS). Most of the course has been re-recorded using Visual Studio 2022. No prior knowledge is needed, but some knowledge of T-SQL would be useful.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.We will download a version of SQL Server which includes SSRS - for free. We'll also download a database called AdventureWorks, which we will use in our reports.We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:Select report components (matrix, table, chart and other data visualisation component),Identify the data source and parameters,Design a grouping structure,Create drilldown reports and drillthrough reports.As part of implementing a report layout, we will:Find out how to format, including formatting colours, dates and numbers;Configure the page;Implement headers and footers;Implement matrices, tables, chart, images, indicators, maps and groupings in reports;Create a range of reports using different data regions;Define custom fields;Implement global collections;Define expressions; andImplement data visualisation components.As part of implementing interactivity in a report, we will:Create drilldown reports;Create drillthrough reports;Add interactive sorting;Investigate parameters, including multi-value parameters;Create dynamic reports in SSRS using parameters;Implement show/hide property;Add actions (jump to report and URL);Add Fixed headers and a document map.By the end of this course, you should be confident in creating your own reports in SSRS.
