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!!!
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!!!