Reporting Services Data Sources

In this tip we cover how you can use JSON source data as input for a SSRS report.

In this tip, I will show you how you can create dynamic data source connections for SQL Server Reporting Services (SSRS) reports.

After designing several SSRS reports based on regular relational databases, your boss would now like several new reports to be designed and rolled out to production based on your organization's SSAS OLAP cube. In this tip we show you how to get started wi

Although you would prefer to use SQL Server only, your organization has data in a large list of different databases including TeraData. In this tip we cover how to use SQL Server Reporting Services with a Teradata data source.

SQL Server Reporting Services is a great tool to create reports from a SQL Server database, but you can also use SSRS to create reports from a mySQL database. In this example I will show you how to create a report using SQL Server Reporting Services from

I noticed a new feature in SQL Server 2008 R2 Reporting Services called ATOM data feeds. This sounds very interesting. Can you provide an example of how I can use this? Check out this tip to find out.

There are two constraints with using SQL Server Integration Services 2008 R2 (SSIS hereafter) packages as a data source with SQL Server Reporting Services 2008 R2 (SSRS 2008 R2 hereafter). Firstly, SSIS is not enabled as a data source type itself on any r

SSIS packages can be used as a data-source for SSRS and this was well supported in SSRS 2005. In the SQL 2008 R2 release (Nov CTP), this data source extension is not enabled and supported. So when you create a data source in SSRS 2008 R2 (Nov CTP), you wo

This tip covers how to setup SQL Server Reporting Services (SSRS) snapshot reports. This walks through the step by step process of creating a report and scheduling the creation of snapshots for later review.

The Reporting Services datasource is a programming object that holds the configuration information on how to access data for reporting. This includes the server name, database name, the type of data source (i.e. SQL Server, Oracle, text file, etc.) and th