Groups | Blog | Home
all groups > sql server reporting services > september 2007 >

sql server reporting services : Multiple Tables Inside a List


Chris Durkin
9/28/2007 4:30:23 PM
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.


TIA
Chris Durkin
9/28/2007 5:05:24 PM
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.
Chris Durkin
10/1/2007 4:30:39 PM
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.



[quoted text, click to view]

AddThis Social Bookmark Button