Techbubbles

Posts Tagged ‘SQL server Reporting Services’

Filtering Techniques for SQL Server 2008 R2 Reports

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 reports, it greatly reduces the network traffic and helps the report to render efficiently.

 
We are […]

Chart Reports in SQL Server 2008 R2 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 R2 compared to SQL 2005.

Choosing Chart types: The important point while choosing a report type […]

Tabular Reports in SQL Server 2008 R2 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 types available and explains in detail the steps to create a Tabular Report. It also explains […]

Configuring SQL Server Reporting Services in SharePoint 2010

 
 

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 services can be configured in two modes
Related Posts:Using SharePoint 2010 dialogsActivating and Deactivating Feature programmatically in SharePointUsing Property […]

SQL Server Reports Integration with SharePoint 2007

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.

 
Related Posts:Filtering Techniques for SQL Server 2008 R2 ReportsTabular Reports in SQL Server 2008 R2 Reporting ServicesConfiguring SQL Server Reporting Services in […]

Report Builder 2.0 in SQL Server 2008

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 run the report, the report processor takes all the information you specified and retrieves the […]