1. Self-service Alerts
    1. requires
      1. SQL Server 2012 Reporting Services SharePoint Integrated mode
      2. report saved to a SharePoint library.
      3. credentials stored
      4. least one data region
      5. report should change over time
    2. Permissions
      1. Information worker
        1. View Items
        2. Create Alerts
      2. Alerting administrator
        1. Manage Alerts (Delete)
    3. Logs
    4. screenshot
    5. notifies user when data changes
      1. Alert Name
      2. Rules and Clauses
        1. Any data has
          1. i.e Sales is greater than 1500.00
        2. No data has
      3. Schedule settings
      4. Email Settings
  2. Power View
  3. Shared Schedule
    1. requires
      1. SQL Server Agent
      2. site administrator
      3. Only shared schedules can be paused and resumed
    2. Add Shared schedule
      1. 1. Click Site Actions
      2. 2. Site Settings
      3. 3. Manage Shared Schedules
      4. 4. Add Schedule
    3. Pause
    4. Delete
    5. Use shared schedules
      1. Subscriptions
        1. stored credentials
      2. Report Snapshot
        1. collection of report snapshots
      3. Report Cache Refresh
      4. Dataset Cache expiration
  4. Install Modes
    1. Native Mode
    2. SharePoint integrated
    3. Native Mode with Webpart
    4. Switch Mode
  5. Report Design
    1. Data Source
    2. Dataset
    3. Table
    4. Matrix
    5. Charts
    6. KPI
      1. Indicator
      2. Gauge
    7. Actions
    8. Drill down
    9. Subreports
  6. Enable Trace Log
    1. Sharepoint
      1. SharePoint Central Administration
      2. Click Monitoring.
      3. Click Configure Diagnostic Logging in the Reporting group.
      4. Find SQL Server Reporting Services
      5. Select the subcategories to be added to the trace log.
    2. Native Mode
      1. DefaultTraceSwitch
      2. RSTrace
      3. Config file's setting
  7. Enable Report Execution Log
    1. Sharepoint
      1. Open SharePoint Central Administration
      2. Click Manage service applications
      3. Select Reporting Services service application
      4. Click System Settings
      5. Enable Execution Logging in the Logging section
    2. Native Mode
      1. Start SQL Server Management Studio
      2. Connect to the desired report server
      3. Right-click the server name and click Properties
      4. Click the Logging page
      5. Change EnableExecutionLogging to True
  8. Logging Types
    1. Execution Logging
    2. Trace Logging
    3. HTTP Log
    4. Windows Application Log
    5. Windows Performance logs
    6. Setup log files
    7. IIS Logs