SSRS and the Case of the Out-of-Order Report Tables

Developer Support

In this post, Senior Application Development Manager, Patrick King shares a SSRS tip to help control report item order when it differs from what you may see in VS designer.

imageI recently worked with a customer developing a SQL Server Reporting Services (SSRS) report that was rendering in a different order than what appeared in the designer in Visual Studio 2013.

The report designer had three tables that were arranged sequentially, similar to those shown below:


When rendered in the designer preview, the tables were out of order, as shown here:


And when exported to PDF, one table was superimposed upon the others, like this:

After reviewing the designer, nothing stood out as being incorrect. My next step was to review the xml content of the RDL file.

Inspecting the RDL file revealed a rectangle that contained tablix2 and tablix3. In the designer, that same rectangle visually appeared to contain all three tables, but Tablix1 was just positioned on top of the rectangle. This caused layout conflicts when rendering the report, because the rectangle and Tablix1 were peers that occupied overlapping space.image


Issues like this seem simple in hindsight, but can cause hours of frustration when a developer is struggling to understand what is going on.  The issue was resolved by moving the rectangle start element so that it encompassed Tablix1 to match the original intent. Once this was done, the report rendered as expected.

Premier Support for Developers provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality.  Contact your Application Development Manager (ADM) or email us to learn more about what we can do for you.


Discussion is closed.

Feedback usabilla icon