Muliple rows for group side by side with data

I have a report layout that has proved to be a little tricky. I hope
someone on this group can help me out.
I am going to show a simplified version that captures the problem. I
can easily create a report that looks like this:
NAME ADDR1 ADDR2 PHONE ITEM1
ITEM2
ITEM3
ITEM4
ITEM5
...
NAME2 ADDR ADDR PHONE ITEM1
...
where there could be zero or more items for each person. I have been
asked to create a report that looks somthing like thiS:
NAME ITEM1
ADDR1 ITEM2
ADDR2 ITEM3
PHONE ITEM4
ITEM5
...
If there are more than 4 items, then they appear below. If there are
less than 4 items, then the space to the right of the address and phone
is blank.
This is a simplified example. There are actually many more fixed
fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
them. If I were to put the repeating items below the fixed fields,
then 5 items would take a total of 12 lines for this person. By having
the items side by side with the fixed fields, 5 items would only take
the 7 lines and we save a lot of space.
Has anyone done this? Can anyone tell me how to place detail items
side by side with multiple rows of group header data?
Thank you,
TedHi, This is possible with Unions in your dataset.
Select Name From ?
Union
Select ADDR1 From ?
Union
Select ADDR2 From ?
Etc.
gr.
Mike
"Ted K" wrote:
> I have a report layout that has proved to be a little tricky. I hope
> someone on this group can help me out.
> I am going to show a simplified version that captures the problem. I
> can easily create a report that looks like this:
> NAME ADDR1 ADDR2 PHONE ITEM1
> ITEM2
> ITEM3
> ITEM4
> ITEM5
> ...
> NAME2 ADDR ADDR PHONE ITEM1
> ...
> where there could be zero or more items for each person. I have been
> asked to create a report that looks somthing like thiS:
> NAME ITEM1
> ADDR1 ITEM2
> ADDR2 ITEM3
> PHONE ITEM4
> ITEM5
> ...
> If there are more than 4 items, then they appear below. If there are
> less than 4 items, then the space to the right of the address and phone
> is blank.
> This is a simplified example. There are actually many more fixed
> fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> them. If I were to put the repeating items below the fixed fields,
> then 5 items would take a total of 12 lines for this person. By having
> the items side by side with the fixed fields, 5 items would only take
> the 7 lines and we save a lot of space.
> Has anyone done this? Can anyone tell me how to place detail items
> side by side with multiple rows of group header data?
> Thank you,
> Ted
>|||Thanks Mike. I'm very good with SQL and am confident I can write the query
to get the data back however I want. What I'm looking for is help with the
RDL layout. I have tried nested tables, lists, and other ways, but each has
problems. For example, one layout came up with:
NAME ITEM1
ADDR1
ADDR2
PHONE
ITEM2
ITEM3
ITEM4
ITEM5
...
instead of:
NAME ITEM1
ADDR1 ITEM2
ADDR2 ITEM3
PHONE ITEM4
ITEM5
Any experts out there know how to put the detail rows to the right of the
header fields instead of below?
Thank you very much,
Ted
"Mike Klaarhamer" wrote:
> Hi, This is possible with Unions in your dataset.
> Select Name From ?
> Union
> Select ADDR1 From ?
> Union
> Select ADDR2 From ?
> Etc.
> gr.
> Mike
> "Ted K" wrote:
> > I have a report layout that has proved to be a little tricky. I hope
> > someone on this group can help me out.
> >
> > I am going to show a simplified version that captures the problem. I
> > can easily create a report that looks like this:
> >
> > NAME ADDR1 ADDR2 PHONE ITEM1
> > ITEM2
> > ITEM3
> > ITEM4
> > ITEM5
> > ...
> > NAME2 ADDR ADDR PHONE ITEM1
> > ...
> >
> > where there could be zero or more items for each person. I have been
> > asked to create a report that looks somthing like thiS:
> >
> > NAME ITEM1
> > ADDR1 ITEM2
> > ADDR2 ITEM3
> > PHONE ITEM4
> > ITEM5
> > ...
> >
> > If there are more than 4 items, then they appear below. If there are
> > less than 4 items, then the space to the right of the address and phone
> > is blank.
> >
> > This is a simplified example. There are actually many more fixed
> > fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> > them. If I were to put the repeating items below the fixed fields,
> > then 5 items would take a total of 12 lines for this person. By having
> > the items side by side with the fixed fields, 5 items would only take
> > the 7 lines and we save a lot of space.
> >
> > Has anyone done this? Can anyone tell me how to place detail items
> > side by side with multiple rows of group header data?
> >
> > Thank you,
> > Ted
> >
> >|||Hi Ted,
I've done a similar thing just via using simple Tables.
I just created 2 tables next to each other, and they should get layed out
correctly.
I'm no expert, but I'm thinking I'd want to create a List with 2 Tables
inside it, like so:
--LIST--
| Table1- Table2- |
|| | | | |
||______| |_____| |
--
And that way you can layout table 1 as you want with the name and address
details, and table 2 with the details of the Items.
Let me know if it works for you, and if u understand my funny explanations.
Andre
"Ted K" wrote:
> Thanks Mike. I'm very good with SQL and am confident I can write the query
> to get the data back however I want. What I'm looking for is help with the
> RDL layout. I have tried nested tables, lists, and other ways, but each has
> problems. For example, one layout came up with:
> NAME ITEM1
> ADDR1
> ADDR2
> PHONE
> ITEM2
> ITEM3
> ITEM4
> ITEM5
> ...
> instead of:
> NAME ITEM1
> ADDR1 ITEM2
> ADDR2 ITEM3
> PHONE ITEM4
> ITEM5
> Any experts out there know how to put the detail rows to the right of the
> header fields instead of below?
> Thank you very much,
> Ted
> "Mike Klaarhamer" wrote:
> > Hi, This is possible with Unions in your dataset.
> > Select Name From ?
> > Union
> > Select ADDR1 From ?
> > Union
> > Select ADDR2 From ?
> > Etc.
> >
> > gr.
> >
> > Mike
> >
> > "Ted K" wrote:
> >
> > > I have a report layout that has proved to be a little tricky. I hope
> > > someone on this group can help me out.
> > >
> > > I am going to show a simplified version that captures the problem. I
> > > can easily create a report that looks like this:
> > >
> > > NAME ADDR1 ADDR2 PHONE ITEM1
> > > ITEM2
> > > ITEM3
> > > ITEM4
> > > ITEM5
> > > ...
> > > NAME2 ADDR ADDR PHONE ITEM1
> > > ...
> > >
> > > where there could be zero or more items for each person. I have been
> > > asked to create a report that looks somthing like thiS:
> > >
> > > NAME ITEM1
> > > ADDR1 ITEM2
> > > ADDR2 ITEM3
> > > PHONE ITEM4
> > > ITEM5
> > > ...
> > >
> > > If there are more than 4 items, then they appear below. If there are
> > > less than 4 items, then the space to the right of the address and phone
> > > is blank.
> > >
> > > This is a simplified example. There are actually many more fixed
> > > fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> > > them. If I were to put the repeating items below the fixed fields,
> > > then 5 items would take a total of 12 lines for this person. By having
> > > the items side by side with the fixed fields, 5 items would only take
> > > the 7 lines and we save a lot of space.
> > >
> > > Has anyone done this? Can anyone tell me how to place detail items
> > > side by side with multiple rows of group header data?
> > >
> > > Thank you,
> > > Ted
> > >
> > >|||Thanks for replying. Before I tried to work out the 2 tables next to each
other (and how to get the rows to match up right), I got one of my other
layouts working.
In case anyone wants to know, I created a list for the group, put all of the
static fields down, then put a list for the detail items to the right of the
static fields. The important part was to make the detail list as tall as all
of the static fields and also to set CanShrink to true. If there were very
few items, the list would shrink. If there were a lot, the list would grow,
but would not push down any of the static fields because the bottom of the
list was already below the text boxes.
Ted
"Arkiliknam" wrote:
> Hi Ted,
> I've done a similar thing just via using simple Tables.
> I just created 2 tables next to each other, and they should get layed out
> correctly.
> I'm no expert, but I'm thinking I'd want to create a List with 2 Tables
> inside it, like so:
> --LIST--
> | Table1- Table2- |
> || | | | |
> ||______| |_____| |
> --
> And that way you can layout table 1 as you want with the name and address
> details, and table 2 with the details of the Items.
> Let me know if it works for you, and if u understand my funny explanations.
> Andre
> "Ted K" wrote:
> > Thanks Mike. I'm very good with SQL and am confident I can write the query
> > to get the data back however I want. What I'm looking for is help with the
> > RDL layout. I have tried nested tables, lists, and other ways, but each has
> > problems. For example, one layout came up with:
> >
> > NAME ITEM1
> > ADDR1
> > ADDR2
> > PHONE
> > ITEM2
> > ITEM3
> > ITEM4
> > ITEM5
> > ...
> >
> > instead of:
> >
> > NAME ITEM1
> > ADDR1 ITEM2
> > ADDR2 ITEM3
> > PHONE ITEM4
> > ITEM5
> >
> > Any experts out there know how to put the detail rows to the right of the
> > header fields instead of below?
> >
> > Thank you very much,
> > Ted
> >
> > "Mike Klaarhamer" wrote:
> >
> > > Hi, This is possible with Unions in your dataset.
> > > Select Name From ?
> > > Union
> > > Select ADDR1 From ?
> > > Union
> > > Select ADDR2 From ?
> > > Etc.
> > >
> > > gr.
> > >
> > > Mike
> > >
> > > "Ted K" wrote:
> > >
> > > > I have a report layout that has proved to be a little tricky. I hope
> > > > someone on this group can help me out.
> > > >
> > > > I am going to show a simplified version that captures the problem. I
> > > > can easily create a report that looks like this:
> > > >
> > > > NAME ADDR1 ADDR2 PHONE ITEM1
> > > > ITEM2
> > > > ITEM3
> > > > ITEM4
> > > > ITEM5
> > > > ...
> > > > NAME2 ADDR ADDR PHONE ITEM1
> > > > ...
> > > >
> > > > where there could be zero or more items for each person. I have been
> > > > asked to create a report that looks somthing like thiS:
> > > >
> > > > NAME ITEM1
> > > > ADDR1 ITEM2
> > > > ADDR2 ITEM3
> > > > PHONE ITEM4
> > > > ITEM5
> > > > ...
> > > >
> > > > If there are more than 4 items, then they appear below. If there are
> > > > less than 4 items, then the space to the right of the address and phone
> > > > is blank.
> > > >
> > > > This is a simplified example. There are actually many more fixed
> > > > fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> > > > them. If I were to put the repeating items below the fixed fields,
> > > > then 5 items would take a total of 12 lines for this person. By having
> > > > the items side by side with the fixed fields, 5 items would only take
> > > > the 7 lines and we save a lot of space.
> > > >
> > > > Has anyone done this? Can anyone tell me how to place detail items
> > > > side by side with multiple rows of group header data?
> > > >
> > > > Thank you,
> > > > Ted
> > > >
> > > >sql