SQL Reporting Services 2008 | Technology tips

Monday, April 12, 2010

SQL Reporting Services 2008

Microsoft has released a sophisticated platform for managing and designing reports using SQL Reporting Services 2008. Using this service you can create reports that cover all areas of businesses and bring them across the enterprise so all employees has real time access to the data and information which is relevant too and enables all employees to take good decision.
Other types of reports are called “Ad-Hoc reporting” which enables organization to build their reports on ad hoc basis as its name suggest provides them with the flexibility to instantly get the information they need.
In the format they want instead of submitting the request for little or a big customization to the IT Department and wait until they develop it for you.

Another mechanism help organization to build report and link them directly into portal area – now a days everything is going online. So organization can consume report within their business process. You also can use a web part and sharepoint directly render the report inside the workspace and use them in your BI Workspace so all information workers can use the centralize BI dashboard with the linked reports to enhance the performance or use it in the Webpart only.

There are three report authoring environment that are focused and released with SQL Server Reporting Services.

Report Designer tool: you can use this tool in combination of Visual Studio and develop report -this tool is for Developers.

Report Builder tool: Information worker can do authoring type activities using this tool and it has office type look and feel. Information workers and power user can use this tool.

Report Builder 1.0 has been widely used with SQL Server 2005.


Few components are same in all earlier versions of report builder like grouping pane, data pane and dialog.

Report Builder 2.0 UI: (SQL Reporting Services 2008)

You an create datasource and specify query you want to display data based on it, set the layout of the datafields in groups and columns, select layout and done.


Once you define datasource then you can select its table and select columns from the table and write complex queries too because you define parameters there to filter data based on the parameters defined in this report. Matrix format is the easiest format to display data in tabular format in the report with aggregated information.

 Report Builder 2.0 / SQL Reporting Services 2008

Please leave questions if you have.

No comments: