Category: SSRS

If you start with reporting services platform you can find here few basic terms with brief explanation.

• Reporting services
  • Microsoft BI platform for creating, publishing and managing reports
• Report server
  • Fundamental component handling report processing, rendering, extension management, web services API  etc.
• Report server manager
  • Report server web API developer in ASP.NET
• Report server database
  • Report server database containing reports metadata
• Report
  • Document in xml format, graphical output of data
• Linked report
  • Link to report definition
• Data source
  • a name given to the connection set up
• Connection
  • A way client “talks” to server
• Dataset
  • Collection of data returned to report
• Tablix
  • Basic component for data presentation
• Report builder
  • Application for creating reports

For which kind of reports is reporting services platform suitable?

• Modern web dashboards
  • Graphical outputs
  • Table output
• Static forms for printing
  • Fixed graphic report elements
• Variable displays based on user input values
• Outputs for mobile devicess

Scenarios not to use reporting services

• Creating interactive web pages/applications
  • Even though SSRS can be used to create a report that allows the user to initiate an action
• Dynamic reporting (PivotTable)
  • Matrix component partially replaces in reporting services