Friday, August 7, 2015

SSRS Concepts

SSRS (SQL Server Reporting Services)
SSRS Architecture
Report Server Project
Report Model Project
Report Builder
Data Source
    Embedded Data Source
    Shared Data Source
Data Set
    Embedded Data Set
    Shared Data Set
    Filters at Data set Level
Data Regions
RDL (Report Definition Language)
My First SSRS Report
Report Server Project Wizard
Report Server Project Wizard1
Create a Report using Wizard
Custom Report Template in SSRS
SSRS Query Designer
              Tabular Report
              Matrix Report
                     Filters at Tablix Report
                     Filter at Tablix Level
              Chart Report
                      Bar Chart
                      Pie Chart
                      Drill-Down Chart
                      Column Chart
              Text box
              Image Report
              Line
              List
              Rectangle
             Gauge Report
             Map Report
                  Document Map Report
             Data Bar
             Spark line
             Indicator
Types of Reports:
              Drilldown Report
              DrillThrough
                    Go To URL Action
              Sub Report
Tabbed Report
Parameterized Reports
           Parameters in Report
           Report Parameters
           Multiple Parameters
           Drop-Down List Parameters
           Cascading Parameters
           Multi-Value Parameter
Grouping in Report
Grouping in SSRS Report
Row Grouping
Sorting in SSRS
Sort the data at Tablix
Interactive Sorting in Report
Interactive Sorting
Page Header and Page Footer
Built-In-Functions
Commonly used functions
Linked Report
Caching
Snapshot
Subscriptions
      Standard Subscriptions
      Data-Driven Subscriptions
Roles
Security




Scenario Based:

Installations:

Install SSRS Report Builder 3.0

Development:

How to show tablix inside the tablix
Creating Calculate field in SSRS
Create a report with Excel as Source
Create a report with Excel as Source1
Create a report with Excel as Source2
Conditionally Setting column visibility in SSRS
Keep Headers Visible while scrolling
Repeat Table Header on Each page in SSRS
Repeat Table Header on Each page in SSRS1
Repeat Headers each page
Format Numbers in SSRS
Format Fonts and Background Color of a Textbox in SSRSSet an alternative color in Report
Display a fixed number of rows per page for an SSRS reportCreate a parameterized report in SSRS
Create a report using Expressions in SSRS
SSRS - How to add input parameters in the report
Creating a multi-option parameter report for SQL Server Reporting Services
SQL Server Reporting Services Text Box Orientation
Calendar Date Picker for MDX based Reports in SSRS



Email Configuration in SSRS with SMTP in Windows Server 2008R2