SQL server Reporting Services Archives

Filtering Techniques for SQL Server 2008 R2 Reports

February 20, 2011

SQL server, SQL server 2008, SQL server Reporting Services

It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on…

Chart Reports in SQL Server 2008 R2 reporting services

February 17, 2011

Kalyan Bandarupalli

SQL server 2008, SQL server Reporting Services

Charts are effective way to visualize the aggregated values. This post discuss about creating a chart, Pie and Gauge reports using SQL server 2008 R2 Reporting Services. You will notice a significant difference in chart types in SQL 2008…

Tabular Reports in SQL Server 2008 R2 Reporting Services

February 15, 2011

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL server Reporting Services

It is important to understand the reporting options available in SQL Server 2008 R2 to provide an appropriate report layout to meet the business requirements and needs of our end users. This post briefly discusses about different report layout…

Configuring SQL Server Reporting Services in SharePoint 2010

February 4, 2011

Kalyan Bandarupalli

SharePoint, Sharepoint 2010, SharePoint Server IntegrationMode, SQL server 2008, SQL server Reporting Services

This post discusses how to configure SQL server reporting services in SharePoint Integration mode. You must do some configuration steps on both report server and SharePoint server to get report viewing on SharePoint sites. SQL server reporting…

SQL Server Reports Integration with SharePoint 2007

March 5, 2010

Kalyan Bandarupalli

SharePoint Server IntegrationMode, SQL server, SQL server Reporting Services

No Comments

This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in Native Mode or Share Point Integration Mode. (more…)

Report Builder 2.0 in SQL Server 2008

February 23, 2010

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL server Reporting Services

No Comments

Report builder 2.0 is a report authoring tool that we can use to design and publish reports. We can specify the data source, what data to display on report and which layout you prefer to see the report. When you…