SQL Server Integration Services (SSRS) is a part of SLQ Server that allows to build various reports.
The SSRS is a separate Windows Service (EXE file) on an MS SQL Server and should be started separately:
A SSRS report is contained in a special file format RDL. Here is an example of an RDL file (during the design stage; not on runtime stage):
Here is an example of design of an RDL file opened in Visual Studio:
- The “1” is deign of the file;
- The “2” is a simple status text within the file;
- The “3” is Tablix control embedded into the Report. It is connected to a Data Source that is denoted by the number “4”. Therefore, at runtime the “3” Tablix man have many rows (that may spread out on many pages) brought from a DB that the “4” refers. The “4” may be either simple SQL query or a call of a huge and sophisticated SQL procedure.
The Reports may be parametrized that improves their flexibility.
Ans inctance of an SSRS often has an URK like http:///Reports .