Using XML to Find Errors in a SSRS Report

Home > Blogs > SQL Server > Using XML to Find Errors in a SSRS Report

Using XML to Find Errors in a SSRS Report

Like This Blog 0 Peter Avila
Added by July 2, 2013

As we see in the BI779 SQL Server Reporting Services course, a report’s rdl file is actually an XML file. One of the benefits of an XML file is that, since it is text and includes all the objects of our report, we can use it to help us find solutions to certain errors that might otherwise be hard to find. Let’s see an example of this.

Let’s say we have a report with a parameter called @CustID. When we try to run the report, Reporting Services encounters an error in the spelling of a parameter name (@CustoID), but it does not tell us where the error was found.

001-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

Parameters can be used in many places, including datasets, textboxes, and others. If you have a large report with several data regions, each containing several textboxes, and/or multiple datasets, it can be a daunting task to find where the misspelling is located. But there is an easy way to pinpoint the location of the error. All we need to do is search for it in the XML file.

1. To open the XML file, right-click on the report .rdl file in Solution Explorer and select View Code.

002-view-code-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

2. Notice that the XML file is displayed.

003-xml-displayed-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

3. Press Ctrl-F on your keyboard to open the Find and Replace window, enter the text you want to find (@CustoID, in our case) in the Find what field, and then click Find Next.

004-find-replace-custID-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

4. In our example, the misspelling is found to be in the SalesOrders dataset.

005-SalesOrders dataset-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

5. So, now we know where to go to fix the problem. We right-click the SalesOrders dataset in the Report Data panel and select its properties…

006-SalesOrders-panel-dataset-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

6. …and we can now easily locate the problem and fix it.

007-fixed-dataset-using-XML-to-find-errors-in-a-SQL-Reporting-Services-Report

 

And that’s it!

Enjoy!
Peter Avila
SQL Server Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

A Simple Introduction to Cisco CML2

0 3902 0

Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2

Creating Dynamic DNS in Network Environments

0 646 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader teaches how to create Dynamic DNS zones in Network Environments. Video Transcription: Now that we’ve installed DNS, we’ve created our DNS zones, the next step is now, how do we produce those … Continue reading Creating Dynamic DNS in Network Environments

Cable Testers and How to Use them in Network Environments

0 735 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.