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

Creating Users and Managing Passwords in Microsoft Office 365

0 642 3

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

JavaScript for C# Developers – September 24, 2014

0 487 3

Is JavaScript worth taking the time to learn if I’m a server-side .NET developer? How much of C# carries over to JavaScript? In this recorded video from Dan Wahlin’s webinar on September 24,2014, Dan answers these questions and more while also discussing similarities between the languages, key differences, and the future of JavaScript (ES6). If … Continue reading JavaScript for C# Developers – September 24, 2014

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 602 5

How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015

Write a Comment

Share your thoughts...

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