Duration: 1 day
Trainer: WC315P
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Course summary:
This course focus on producing reports using MS SQL Server Report Builder 3.0 : how to use the product features and tools related to data retrieval, visualisations and deployment.
The Target Audience: end-users who will produce reports for their department or group without in-depth SQL knowledge.
MS SQL Server Report Builder 3.0 gives you a user-friendly visual interface to create report.
Course Outline:
Report Models:
Data source views
Creating a model
Entities, attributes and roles
Tables
Creating tables
Interactive sorting
Floating headers
Grouping
Inserting groups
Group headers/footers
Displaying group totals
Expanding and collapsing
Expressions
The expression builder
The ReportItems collection
Built-in fields
Conditional formatting expressions
Page set-up
Page headers and footers
Page names and numbers
Exporting reports
The various report formats
Using RenderFormat.Name
Parameters
Creating parameters
Filtering using parameters
Drop list parameters
Coping with empty tables
Matrices
Row and column groups
Sorting and filtering matrices
Creating subtotals
Charts
Creating charts
The parts of a chart
Formatting charts
Basic reports
Text boxes and images
Selecting report items
Formatting parts of a report
Miniature charts
Creating sparklines
Creating data bars
Graphical indicators
Creating and customising indicators
Linear and radial gauges
Lists
Page-per-record lists
Dashboard lists
Other list ideas
Subreports
Creating a child report
Creating the main report
Linking the two reports
Report parts
Publishing report parts
The report part gallery
Updating report parts
Duration:
2 days
Location | Region | Start Date | Days | Price ex. VAT | ||
---|---|---|---|---|---|---|
ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Thu 4 Apr 24 This course lasts for one day duration, start date as indicated. |
1 | £390 + VAT | BOOK | ENQUIRE |
ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Thu 11 Apr 24 This course lasts for one day duration, start date as indicated. |
1 | £390 + VAT | BOOK | ENQUIRE |
ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Thu 18 Apr 24 This course lasts for one day duration, start date as indicated. |
1 | £390 + VAT | BOOK | ENQUIRE |
ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Thu 25 Apr 24 This course lasts for one day duration, start date as indicated. |
1 | £390 + VAT | BOOK | ENQUIRE |
Courses found 1 to 4 of 4 | 1 | |||||
Click location to see venue | Move cursor over calendar icon to see course dates |