Render list of Data Sources and Dataset's within a Report Definition (.RDL) file, using Reporting Services Web Services

by Hans Esquivel 22. July 2009 04:42
This article describes how to render a list of data sources and dataset's from with a Report Definition (.RDL) file, while using the SQL Server Reporting Services Web Services. [More]

Create a method to handle Stacked Values field in a Table or Matrix, using SSRS

by Hans Esquivel 14. July 2009 09:15
In this article we will examine developing a method to handle stacked values within a field, while using a table or matrix. There may be multiple ways to handle stacked values approach, but we will focus on delivering the solution using a custom assembly. [More]

Spice up your Pie Chart by setting the PieDrawingStyle property

by Hans Esquivel 10. July 2009 07:25
This article we will describe how to enhance a Pie Chart by using the SoftEdge or Concave value, using SQL Server 2008 Reporting Services. These values are available only on a 2D Pie Chart. The image below illustrates both SoftEdge and Concave styles, respectively. We will be using Report Builder 2.0 for this example. [More]

Uploading .RDL files using Reporting Services Web Services - Application Integration

by Hans Esquivel 8. July 2009 17:42
This post will demonstrates how to upload an .RDL file to the Reporting Services database. We will begin with creating the method to upload the file and save it to a temporary folder. Next, we then consume the web service method CreateReport to save the .RDL file to the Reporting Services database. [More]

Configure Report Manager to open Report Builder 2.0 with ClickOnce

by Hans Esquivel 8. July 2009 15:55
I was looking for a way to configure Report Manager to open Report Builder 2.0, instead of the default Report Builder 1.0 application. I was able to find this tidbit from the Report Builder 2.0 online help and thought I'd share. [More]

Working with Folders and Properties programmatically in Reporting Services

by Hans Esquivel 8. July 2009 10:14
In this article we will describe how to programmatically add a new Folder and Properties to the catalog list in Reporting Services. We will be using the CreateFolder and FindItems methods for this example. [More]

Integrating Reporting Services with Web Applications - Report Items TreeView

by Hans Esquivel 2. July 2009 13:11
This article will demo the use of Reporting Services SOAP API to integrate with a web application. We will begin by creating a new Web Project in VS 2008 and configuring the web.config so we can authenticate using impersonation. Next, we will reference the ReportingService2005 web services proxy object. Then enter some code to render a list of reports from within the Report Catalog. [More]

Creating a Shared Data Source in Reporting Services 2008

by Hans Esquivel 2. July 2009 06:29
This article will provide an example of how to create a Shared Data Source and publish it to your Report Server. You may use the data source while developing reports in Report Designer and Report Builder 2.0 tools. For this example, we will be using SQL Server Business Intelligence Development Studio 2008. [More]

About Us

infotoad
Info-Toad Consulting provides Data Management and Business Intelligence Solutions. If you would like to learn more about our services or solutons, please visit us at http://www.infotoad.com or call (877) 488-0566.