This is a migrated thread and some comments may be shown as answers.

problem with grouping multi-level table

1 Answer 93 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Wadigzon
Top achievements
Rank 1
Wadigzon asked on 08 May 2013, 09:03 PM
Hello there, 
I have this data structure:
{Id, Phases, Ring}
My content is
Id goes from 1:16
Phases is a random string
for each Id there are four Rings so Ring goes from 1:4
so the data I have is 
{1, "xx", 1}, {1, "xy", 2}, {1, "**", 3},{1, "fd", 4}, 
{2, "dk", 1}, {2, "%", 2}, {2, "T*", 3},{2, "sd", 4}, 
...
{15, "kk", 1}, {15, "ll", 2}, {15, "**", 3},{15, "ff", 4}, 
{16, "yy", 1}, {16, "uu", 2}, {16, "U*", 3},{16, "pp", 4}, 

I want to show this data in a report with the following layout (ignoring the edges and font types of course)
Id = 1
Ring    1    2   3  4
Phase xx   xy  **  fd

id=2
Ring    1    2   3   4
Phase dk  %  T*  sd

...

id=15
Ring    1    2   3   4
Phase kk  ll    **  &&

id=16
Ring    1    2   3    4
Phase yy  uu  U*  pp

What I did is created thee lists list1 (parent), list2 (child), list 3(child)
list2 and list3 are within list1 (in design mode as shown in rptexplorer.jpg)
"id=" (textBox1) and "Fields.Id"(textBox3) belong to panel2 (within list1)
"Ring" (textBox4)  and "Phases" (textBox6) are labels that belong to list2
Fields.Ring (textBox7) and Fields.Phase (textBox8) are data fields that belong to list3

I also have groupings
on list1 I have a Row Group equals to  "=Fields.Id"

on list2 I don't have any Groups 

on list3 I have a Row Group equals to "=(Fields.Ring-1)/4" and a Column group equals to "(Fields.Ring-1)%4"

when I run the report I only have the first sequence of data (though the layout is fine) like this:

Id = 1
Ring    1    2   3  4
Phase xx   xy  **  fd

id=2
Ring    1    2   3   4
Phase xx   xy  **  fd


...

id=15
Ring    1    2   3   4
Phase xx   xy  **  fd


id=16
Ring    1    2   3    4
Phase xx   xy  **  fd


What am I doing wrong? do I have something missing? please help!!!

1 Answer, 1 is accepted

Sort by
0
Hadib Ahmabi
Top achievements
Rank 1
answered on 13 May 2013, 08:18 AM
You are probably doing wrong data-binding. What is your DataSource and how you use it?
I also believe that for this layout you don't so many nested panels.
Tags
General Discussions
Asked by
Wadigzon
Top achievements
Rank 1
Answers by
Hadib Ahmabi
Top achievements
Rank 1
Share this question
or