Archive for the ‘SSRS’ Category

SQL Server 2005 Performance Dashboard Using SSRS

After a recent performance related post at http://www.sqlservercentral.com/Forums/Topic708345-360-1.aspx#bm708809, the SSC user Mohit posted some great references to Microsoft supplied performance related queries and reports for SQL Server 2005.  I decided to install the Performance Dashboard and document my results as I went.  This article is a detailed step by step intended for beginner level report […]

How to Rotate a Pie Chart in SSRS 2005

How to change the angle of the first slice of a Pie chart in SSRS 2005. Introduction In this article, we will discuss a common problem for people using SSRS 2005. The software doesn’t explicitly allow users to define the starting angle for their pie charts, which, in the opinion of many charting experts, has […]

SQL Server Reporting Services 2005 XML Extensions

In SSRS2005, a new provider is available: XML Data provider. This enables you to create reports from ADO.NET datasets or XML documents from URL-addressable resources, e.g. Web services. This article shows a step-by-step example (basic report, no parameters) how to use this new SSRS 2005 feature. Download source – 10.57 KB Download Northwind – 27.71 […]

SQL Reporting Services Viewer Page Using SOAP API

A report viewer page for SQL Reporting Services that uses exclusively its SOAP API. Download source – 46.7 Kb Contents Introduction Prerequisite Architecture The Web Page The Code Behind Rendering Images Using the Code Key Points Known Limitations Conclusion History Introduction This code is intended to provide a starting point for a SQL Reporting Services […]

Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps

Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps A Technical Blog article. View entire blog here. There are only 6 main steps to achieve this task assuming you already have an instance of SQL Server Reporting Services and SharePoint 2010. I had created this starting from a clean installation of SQL […]

Integrating Microsoft Access DB, SQL Reporting Services and Visual Studio .NET

In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE. Introduction In this article I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database using […]

A Simple GUI Tool for SQL 2005 Reports Deployment Without using BI Development Studio

Did you like this? Share it:Tweet

SQL Reporting Services Alternating and Varying Row Styles

Shows how to set various styles to rows in MS SQL Reporting Services reports based on row sequence or on data. Download source code – 597 KB Introduction Often we require our data rows / lines to have different colors for various purposes and reasons. The colors may be different purely for improving readability or […]

Building ASP.NET Reporting OLAP-Based Application Part-1

Did you like this? Share it:Tweet

Dynamic Data Grouping using Microsoft Reporting Services

Generate multiple outputs from a single physical report template using dynamic data grouping. Download source files – 107 Kb Image: 1.0 Introduction We hear this all the time, ?Two birds with one stone.? What if I say, ?Four birds with one stone?? I am sure four sound much better then two. So, what are my […]

Powered by WordPress | Compare Cell Phone Plans at iCellPhonePlans.com | Thanks to Cheap Palm Pixi, Bromoney and Wordpress Themes