Monday, March 12, 2012

Multiple Tables Inside a List

I have 3 tables inside a list, all of which use the same dataset. The
layout is something like this:
List
Table1
Table2
Table3
The List has a group defined on it, lets assume the grouped column is
named Entity. What I want when the report renders is this:
Table1 for Entity 1
Table2 for Entity 1
Table3 for Entity 1
Table1 for Entity 2
Table2 for Entity 2
Table3 for Entity 2
...but instead I get this:
Table1 for Entity1
Table1 for Entity2
Table2 for Entity1
Table2 for Entity2
Table3 for Entity1
Table3 for Entity2
I checked the RDL and confirmed that all 3 tables are part of the
List's ReportItems collection. All of the data is displaying
correctly. The list is just rendering the tables as if there were
three separate lists, instead of just one. I tried putting all three
tables inside a Rectangle, but it had no effect. The problem occurs in
Visual Studio, IE, and PDF layout.
This looks like a bug to me. I think it is reasonable to expect that
if I nest three sequential tables in a list, I should get repeating
groups of Table1 / Table2 / Table3 for each entity in the list. Am I
correct in that assumption? If anyone can suggest a workaround, I
would appreciate it.
TIAWell I confirmed the rendering engine can handle a simple case of
tables inside a list. I created a simple report with 3 tables inside a
list using AdventureWorks, and it worked as expected. Unfortunately my
real report rdl is over 10,000 lines long with multiple layers of
nested tables inside the tables inside the lists... so this could take
a while to debug.|||For posterity, in case anyone runs into this type of issue... There
was a left-over Group in the table, which was causing data to repeat.
I had copied the table into the list, intending to use the list for
grouping instead of a group expression within the table. I never
deleted the group. I discovered what was going on by looking at the
raw RDL. The list appears to be working well now.
On Sep 28, 5:05 pm, Chris Durkin <durki...@.gmail.com> wrote:
> Well I confirmed the rendering engine can handle a simple case of
> tables inside a list. I created a simple report with 3 tables inside a
> list using AdventureWorks, and it worked as expected. Unfortunately my
> real report rdl is over 10,000 lines long with multiple layers of
> nested tables inside the tables inside the lists... so this could take
> a while to debug.

No comments:

Post a Comment