Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 29, 2004

MSSQL Server Reporting Services: Managing Reporting Services: Data Connections and Uploads - Page 5

By William Pearson

Testing the Reports - and Resolving Data Source Issues

Having uploaded the seven reports listed above, let's perform a test of the first, Company Sales, to ascertain that it is working properly. This offers us an opportunity to experience a data connection problem, and then to resolve it. The same process will need to be accomplished for each of the uploaded reports experiencing the issue.

9.  From the Home page Folder view, Contents tab, click the Company Sales report we uploaded first in the previous section.

We arrive at the Company Sales page, View tab, but are confronted with a Reporting Services Error message, as seen in Illustration 10.

Click for larger image

Illustration 10: Reporting Error Appears for Most of Us

NOTE: If no error was received, and if data appears, close the report and perform the connectivity test on the remaining reports, returning to the steps that follow if, and when, an error occurs.

10.  Click the Properties tab of the page to see properties for the Company Sales report.

The Properties tab assumes the focus.

11.  Click the Data Sources link at the left side of the page.

The Data Sources page appears, indicating the cause of the error, as shown in Illustration 11.

Illustration 11: Data Source Page, Indicating Problem

12.  Click Browse.

The next page that appears gives us an opportunity to remedy the missing data source issue. A box exists within which we can name an alternative source; we also see a tree from which we can select a data source with which to marry the report under consideration, as shown in Illustration 12.

Illustration 12: Options for Associating the Report with the Data Source

Let's correct the problem by naming the replacement data source. Regardless of the number of data sources you may see here (what you see on your local PC will vary if you have set up other data sources, before, etc.), we will select the AdventureWorks2000 data source we created earlier, located in the Home folder, as depicted in Illustration 13.

Illustration 13: Select the AdventureWorks2000 Data Source

13.  Click AdventureWorks2000 in the tree, under the Home folder.

We see AdventureWorks2000 populate the Location box, as shown in Illustration 14.

Illustration 14: AdventureWorks2000 Populates the Location Box

14.  Click OK to accept our specifications.

We arrive at the initial Data Source property page, where we see that the shared data source is designated.

15.  Click Apply at the bottom of the page to apply the new data source designation.

16.  Click the View tab at the top left of the Properties page.

NOTE: Be sure to always apply before navigating to the View tab - there is no "are you sure?" message if we skip this step.

The Company Sales report appears, as shown in Illustration 15.

Illustration 15: The Company Sales Report - Connection Established

We see that we have established a data connection to the report.

17.  Perform steps 9 through 16 above for each newly uploaded report, as required to establish connectivity.

The Folder view of the Report Manager will appear similar to that shown in Illustration 16, once we have uploaded the reports we listed earlier.

Illustration 16: Report Manager - Folder View, Displaying Uploads

Keep in mind that uploading can happen in other ways: the most common method, outside the confines of the Report Manager, is via the Report Designer, which we visited from a fairly high level in our initial articles, and to which we will no doubt return in upcoming articles of the series.

18.  Close the browser, after experimenting with the various reports, as desired.

Summary and Conclusion ...

In this article, we introduced Managing as a phase of the Reporting Services development life cycle. We discussed the focus of this and subsequent Managing articles, and then took a look at data connections within Reporting Services. We set up a shared data source item for the sample reports set. We then practiced the upload process with each of the sample reports, to gain familiarity with the steps involved.

Next, we associated the sample reports with the new shared data source item, with the tandem benefit of returning the reports to a working status, and of practicing a method of re-establishing connections to a data source, in cases where a previous connection has been deleted or altered. Finally, we practiced the verification of data connections through initial report viewing, ensuring that each brought back data as expected.

» See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Reporting Services Forum.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM