SQL SERVER REPORTING SERVICES (SSRS)
1.Report Creation and Authoring working with various report facilities a.Report server wizard b.Report server project c.Report model project creating a sample report a.tabular b.matrix c.chart formatting reports 2.Enhancing the reports(data sources & data sets) creating shared data sources creating datasets 3.working with reports extensively creating report by connecting to a.OLAP cubes b.RDBMS creating sub report and using it working with a.subtotals b.full totals c.page breaks d.page footer/header e.sorting f.grouping of data g.applying colors,fonts ...etc 4.working with actions and expressions Implementing various report actions working with various expressions a.calculated members b.global parameters c.report items collection |
5.Parameterised reports passing parameters a.queried b.non-queried c.multivalued d.cascaded 6.Report model & report builder 7.Publishing and excecuting reports executing the reports creating cached instances creating snapshots and report history 8.creating subscriptions Introduction to report subscription Creating report subscription managing report subscription |