Microsoft SQL Server Reporting Services (SSRS)

Description :

Warning: Illegal string offset 'ID' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 890

Warning: Illegal string offset 'key' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 891

Warning: Illegal string offset 'label' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 892

Warning: Illegal string offset 'name' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 893

Warning: Illegal string offset 'menu_order' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 894

Warning: Illegal string offset 'parent' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 895

Warning: Illegal string offset 'key' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 899
"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 This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful. 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; and Implement 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. It will assist with the "Build a report with SQL Server Reporting Services (SSRS)" section of Microsoft exam 70-766 "Implementing Data Models and Reports with Microsoft SQL Server".