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