Dismiss Notice

Register now to be one of the first members of this SharePoint Community! Click here it just takes seconds!

Dismiss Notice
Welcome Guest from Country Flag

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

Discussion in 'Official Microsoft News' started by Premier Developer, Apr 5, 2017.

Thread Status:
Not open for further replies.
  1. Premier Developer

    Premier Developer Guest

    Blog Posts:
    0
    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.

    [​IMG]
    I 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:
    [​IMG]
    When rendered in the designer preview, the tables were out of order, as shown here:
    [​IMG]
    And when exported to PDF, one table was superimposed upon the others, like this:
    [​IMG]
    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.[​IMG]
    [​IMG]
    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.

    Continue reading...
     
Thread Status:
Not open for further replies.

Share This Page

LiveZilla Live Chat Software