SQL Server Reporting Services Introduction
Microsoft SQL Server Reporting Services 2005, there were two services, one unattended windows service and an on demand web service.
Windows service looked after report processing, scheduling and delivery, database maintenance and extensibility web service, on the other hand, worked with SOAP, URL access, Report Manager, Report processing, Report Models and extensibility
SSRS 2008, there is just one Windows service and there is no dependence on IIS.
This was achieved by replacing the functionality provided by IIS with native SQL Server components (SQL OS, SQL CLR and SQL networking interface) leveraging .NET Framework of varying versions in several of the CTP’s (Feb CTP required 3.0 and RC0 requires 3.5) including the RTM.
Report server also stores folders and files just like a computer file system. The report you create exists as a file in the file system with the extension .rdl. When it is published (the same thing as saving to the Report Server), it will be stored on the Report Server Database.
The names of these databases are ReportServer (Primary) and ReportServerTempdb.
• Temporary data
• Session information
• Cached reports
The Report Model project will consist of:
• One or more data source files (with .ds extension)
• One or more data source view files (with .dsv extension)
• One or more Report Model files (with .smdl extension)
The Report Model file can be referenced by only one .ds and one .dsv file.
Report Builder features
Flexible connection to data
°° Relational data
°° Multidimensional data
°° XML data
°° Custom data
• Connectivity to a variety of data source providers
°° Microsoft .NET managed data providers
°° OLE DB data providers
°° ODBC data sources
°° Table-valued functions and custom data
• Support of a variety of vendor data
°° SQL Anywhere 11
• Provide an Improved Report layout scheme
°° Page Orientation, Page Layout, margin sizing and so on are all supported
°° Tabular —> Column based
°° Matrix –> Summarized–> Use Aggregations
°° Tablix= Table + Matrix
°° Chart –> Graphical
°° Gauges–>Dynamic web-based
°° Graphics–>Database based or external graphics
• Support Ad-hoc reporting
°° Create and save reports on the fly.
°° Drillthrough reports and interactive reports
°° Links to subreports and drillthrough reports
°° Parameter based filtering
°° Model based reports providing fine-grained click through reports
• Provide Multiple Presentation/display formats
°° Web and desktop oriented application formats
°° Support HTML, MHTML, PDF, CSV, TIFF, WORD, XML, EXCEL
• Allow Integration with custom or third part controls
• Aid Report Navigation
°° Add bookmarks and document maps for navigating large reports
Rendering extensions support the export formats that are available in SSRS. There are three such extensions:
• Data renderers: data only display (support CSV and XML)
• Soft page-break renderers: Maintain format and layout (support MS Excel, Word, MHTML, and ReportViewer Controls)
• Hard page-break renderers: support TIFF and PDF
Report Server delivery extensions included with out-of-the-box SSRS 2008 to support scheduling and delivery of reports are:
• Report server E-Mail: Uses SMTP Server to email reports
• Report server File Share: for local distribution inside an organization with network file sharing
• Custom extensions are also possible using the API
• Create Subscription and Create Data-Driven Subscription are used to create subscriptions using the delivery extension
C:\Program Files\Microsoft SQL Server\MSRS10.\ReportingServices\ReportServer\rsreportserver.config.
you want to know the URL reservations for your installation you can run the Httpcfg tool. This is generally found at C:\ or C:\windows\Support\Tools\Support.cab.
c:> httpcfg query urlacl
Report Item Function
These are the data regions of a report and each links to a data set.Table, Matrix, and List together are called Tablix. When they are placed on the body of a report, they immediately call up the Data Source Wizard. Report definition is incomplete without the data source.
This is a container for plain text such as a column header.It can also contain data or a built-in data field. Table cells contain textboxes.
Links to an embedded, external or database referenced image.
The MIME type is an important property that must be specified.
Line and Rectangle:
These are graphical elements to improve the report design.
However, rectangles can contain data regions.