SQL Server Reporting Service Start Tutorial

Basic 

-Add New Report 
-Add DataSource
-Add DataSet

-Use Query Designer

-Add Metric, Dimension tables

-(Optional)Add Parameters

-Set Available Values

-Set Default Values

-Add Chart or Table, Matrix, List

-Drop Dataset Field to chart

Advanced Feature

            -Add ReportHeader && Sub Header

                        -(Optional)Dropparameters to load dynamic content

            -Add Logo

            -Add Tabular Layout

                        -Add Table

                                    -SetRepeated Header Property = true

                                    -Header

                                    -Data

                                                -(Optional)AddExpression

                                    -RowGroups

                                                -(Optional)DropDataset Field to be group by

                                                -(Optional)AddTotal After/Before to get sub total

                                                -(Optional)AddPage Breaks

                                                -(Optional) DisplayLayout

                                                            -Occupy(Default): Each group occupy one column

                                                            -Steppedout : All groups in one column

                                                                        -Add parent group

                                                                        -Addgroup header

                                                                        -Addgroup footer

                                                                        -Copy parent group above current column

                                                                        -Delete parent group column

      

                                                -(Optional)Add Sorting

                                                -(Optional)Add Detail Sorting (Detail: Data)

                                    -ColumnGroups        

                                                -(Optional)AddCrosstabReport

                                                            -Add Group - Adjacent Left/Right

                                                -(Optional)Add Sub Total to Dynamic Column

                                    -Color

                                                -UseExpression to display color base on value (e.g.<0 shows red)

                                                -UseExpression to display color base on row (e.g.odd row shows red)

                                    -Footer

                                                -(Optional)AddExecution Time from Build-in Fields Folder

                        -AddMatrix

                        -Add List

                                    -Implment  Freeform Layout Report

- Must Add Detail Group

      

 

            -DataVisualization Feature

                        -Axis Properties - Enable scale breaks

                        -Show Data Label

-Add Marker

                        -3dimensions chart

                                    -SeriesProperties

                                                -Axesand Chart Area

                                                            -Valueaxis: secondary

                        -GaugeReport - one dimension value only

                                    -AddRange

                                    -AddPointer

                                    -AddChild Gauge