SSRS Training
£695 + VAT for most venues (£850 + VAT for London)
2 days
If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! SSRS (as it's often called) allows you to create impressive reports, including drill-through, indicators, gauges and lots of other whizzy features. You can then publish these reports directly to your company's website in a number of different formats, or push them out to subscribers by email.
This two-day course runs in SSRS 2016, but if you're using SSRS 2012 you'll still be able to attend, as the report design interface has barely changed (even since SSRS 2008 R2).
Locations:Manchester, London
Next course:Thu 19 April 2018
Time:09.30-16.30
Visual Studio and SQL Server Data ToolsSolutions and projectsThe Visual Studio environmentAuthoring a reportUsing report itemsSelecting and formatting report itemsNumber formatsShared data sourcesShared versus embedded datasetsUsing Query DesignerStructure of a tableFormatting tablesInserting rowsInteractive sortingRepeating page headersUsing the grouping panesRow and column groupsDisplaying subtotalsOutliningCalculated fieldsThe ReportItems collectionUsing built-in fieldsConditional formatting using expressionsPage headers and footersPagination between groupsHeader and footer expressionsUsing query parametersCreating drop listsMulti-value drop listsFormatting using parametersCreating indicatorsChanging the symbols displayedStopping indicators stretchingCreating and formatting gaugesGauge panelsPointers, scales and rangesAreas of a matrixSorting and grouping matricesCreating and formatting subtotalsThe areas of a chartCreating chartsFormatting chartsNeed for a grouped rowCreating data barsCreating sparklinesCreating and formatting listsGrouping using listsUsing rectangles in lists
If time
Creating a child reportCreating the main reportCreating and formatting subreportsParent and child reportsCreating actionsPassing values to a child report
If time
ESRI shapefiles / SQL spatial dataLinking to datasetsMap layersCenter points and point layersSetting the target serverDeploying an entire projectDeploying single reportsBrowsing to the web portalViewing reportsManaging reports
If time
Creating a KPIInstalling Mobile Report PublisherCreating a mobile report
If time
How subscriptions workCreating a new subscriptionManaging subscriptions
No more than 6 people per classProper restaurant lunch included572 references viewable onlineFree USB stick containing course filesGenuine Wise Owl trainers onlyUnbelievably good coursewareTom Preston (Argos Ltd)
Samantha Sharples (Places for People Group)
David Edwards (Branston Ltd)
Simon Haistead (East of England Ambulance Service NHS Trust)
Michael Gruetzner (Sherwood Compliance Services)
There are lots more where these came from (or just refresh this page to change the quotes shown).
You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases).
View SSRS 2016 exercises
View Reporting Services - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos
View SSRS blogs
