SQL Server Reporting Services (SSRS) is a report generation environment for data gathered from SQL Server databases. It is administered via a web interface. Reporting services features a web services interface to support the development of custom reporting applications. Reports are created as [[Report Definition Language|RDL]] files.<ref name="SQL Server Reporting Services" />
Reports can be designed using recent versions of [[Microsoft Visual Studio]] (Visual Studio.NET 2003, 2005, and 2008)<ref name="Reporting Services" /> with [[Business Intelligence Development Studio]], installed or with the included [[Report Builder]]. Once created, RDL files can be rendered in a variety of formats,<ref name="Render Method" /><ref name="Device Information Settings" /> including Excel, [[PDF]], [[Comma-separated values|CSV]], [[XML]], [[BMP file format|BMP]], [[Windows Metafile|EMF]], [[GIF]], [[JPEG]], [[Portable Network Graphics|PNG]], and [[TIFF]],<ref name="Image Device Information Settings" /> and HTML Web Archive.
=== Notification Services ===
Line 231:
{{Main|Business Intelligence Development Studio}}
[[Business Intelligence Development Studio]] (BIDS) is the [[Integrated Development Environment|IDE]] from [[Microsoft]] used for developing data analysis and Business Intelligence solutions utilizing the Microsoft [[SQL Server Analysis Services]], [[SQL Server Reporting Services|Reporting Services]] and [[SQL Server Integration Services|Integration Services]]. It is based on the [[Microsoft Visual Studio]] development environment but is customized with the SQL Server services-specific extensions and project types, including tools, controls and projects for reports (using Reporting Services), [[OLAP cube|Cubes]] and [[data mining]] structures (using Analysis Services).<ref name="Business Intelligence Development Studio" /> For SQL Server 2012 and later, this IDE has been renamed SQL Server Data Tools (SSDT).
