Types of Reports
Santosh Gadila
http://msdn.microsoft.com/en-us/library/bb630404.aspx#Click
Types of Reports
------------------------
Parameterized Reports
Cascaded Parameterized Reports
Multivalued Parameterized Reports
Drill Down Reports
Drill Through Reports
ClickThrough Reports (Navigation functionality provided to the Report generated from Report Model in Report Builder)
Sub / Parent Child Reports
Map Reports
Linked Report
Snapshot Report (To maintain a history of the report for keeping track of the changes)
Cached Report (to reduce the network traffic / to solve the multiple user execution problems)
--- You store the executed report in the cache for a certain period of time and all the user requests will be answered from the Cache.
--- Optimization Technique to be followed for reports.
For Snapshot or Chached Report you may need to schedule the report snapshots or Cache Storage.
-- Make sure you store the credentials securely in the report Server
-- Make sure your SQL Server Agent is Running.