Wednesday, April 30, 2014

SSRS Interview : Report Manager

Report Manager is a Web-based report access and management tool that you use to administer a single report server instance from a remote location over an HTTP connection. You can also use Report Manager for its report viewer and navigation features. You can use Report Manager to perform the following tasks:
View, search, print, and subscribe to reports.

  • Create, secure, and maintain the folder hierarchy to organize items on the server.
  • Configure role-based security that determines access to items and operations.
  • Configure report execution properties, report history, and report parameters.
  • Create report models that connect to and retrieve data from a Microsoft SQL Server Analysis Services data source or from a SQL Server relational data source.
  • Set model item security to allow access to specific entities in the model, or map entities to predefined clickthrough reports that you create in advance.
  • Create shared schedules and shared data sources to make schedules and data source connections more manageable.
  • Create data-driven subscriptions that roll out reports to a large recipient list.
  • Create linked reports to reuse and repurpose an existing report in different ways.
  • Launch Report Builder to create reports that you can save and run on the report server.
You can use Report Manager to browse the report server folders or search for specific reports. You can view a report, its general properties, and past copies of the report that are captured in report history. Depending on your permissions, you might also be able to subscribe to reports for delivery to an e-mail inbox or a shared folder on the file system.
To use Report Manager, you must have Microsoft Internet Explorer 6.0 or later.

No comments:

Post a Comment