Reporting Services 2008 - Querying a Web Service(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 8 months ago

Reporting Services 2008 - Using XML Data Source type and Querying a Web Service This article will demo using an XML Data Source type in Reporting Services 2008. We will then consume three different web service methods – simple web service method, parameter based method and a method that returns a dataset. read more...

add a comment |category: Web Services |Views: 60

tags: WebServices another

Working with a Recursive Hierarchy Group in SQL Reporting Services(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 9 months ago

This article explains how to create a recursive hierarchy group, which organize data in a report to include multiple hierarchical levels. This is helpful when you want to display hierarchical data in a report. For example: employees in an organizational chart, or product subcategory in a product list. read more...

add a comment |category: Database |Views: 111

tags: Database another

Render list of Data Sources and Dataset's within a Report Definition ((blog.infotoad.com)

submitted by hesquivel(110) 2 years, 9 months ago

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. read more...

add a comment |category: Database |Views: 8

tags: Database another

Create a method to handle Stacked Values field in a Table or Matrix(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 4

tags: Database another

Spice up your Pie Chart by setting the PieDrawingStyle property(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

This article we will describe how to enhance a Pie Chart by using the SoftEdge or Concave value. 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. read more...

add a comment |category: Database |Views: 42

tags: Database another

Uploading .RDL files using Reporting Services Web Services - Applicati(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 216

tags: Database another

Working with Folders and Properties programmatically in SSRS(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 44

tags: Database another

Integrating Reporting Services with Web Applications - Report Items Tr(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 34

tags: Database another

Adding a Chart and defining a Custom Palette in Reporting Services 200(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

This article will provide you with a tip on how to define your own palette for charts, using Reporting Services 2008. read more...

add a comment |category: Database |Views: 136

tags: Database another

Creating a Shared Data Source in Reporting Services 2008(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 14

tags: Database another

Adding Embedded Code to a Report(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 10 months ago

Reporting Services provides the ability to add references to embededed VB.NET code from within the report. You can use this feature to create reusable functions that are called more than once in a report. This post walks you though the steps needed to add embedded code to your reports. read more...

add a comment |category: Database |Views: 11

tags: Database another

Working with Cascading Parameters in Reporting Services(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 11 months ago

In this post we will walk through the steps of building a report and with query parameters for both product category and subcategory items. Then we will develop individual datasets to provide values for the cascading parameters. We will be using Report Builder 2.0 for this demo, but you may use the concepts presented below, while designing a report using BIDS. read more...

add a comment |category: Database |Views: 146

tags: Database another

Conditional formatting in SQL Server Reporting Services 2008(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 11 months ago

In this post we will discuss changing the format of report items or properties based on the data in the report. We will show how build conditional expressions. read more...

add a comment |category: Database |Views: 43

tags: Database another

Reference custom assemblies in SQL Server Reporting Services 2008(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 11 months ago

For this post we will walk through the steps in creating a custom assembly and referencing it from Reporting Services 2008. After we reference the assembly we will can the call the static (shared) method from a texbox field, using a custom expression. read more...

add a comment |category: Database |Views: 32

tags: Database another

Using Parameters in Report Builder 2.0(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 11 months ago

Creating and using parameters in Report Builder 2.0 read more...

add a comment |category: Database |Views: 126

tags: Database another

Introduction to Report Builder 2.0 Part 1(blog.infotoad.com)

submitted by hesquivel(110) 2 years, 11 months ago

With the new release of Microsoft SQL Server 2008 you will find available, a seperate download Report Builder 2.0 for Reporting Services. Report Builder 2.0 is a report authoring tool that runs on your local computer. read more...

add a comment |category: Database |Views: 22

tags: Database another