List & Dataset

Hi,
i have two matrix in two different lists with two different dataset. i would
like to know if it is posible to put one of the list into another list?
Please advice.
For example, i have a item table with the item no ,price and sub item, item
is unique, and i have another table which has the subitem no and item
features, each item might have multiple row of feature.
let say:
Table 1
--
item price subitem
A 2.50 AA
B 1.50 AA
C 1.00 BB
D 2.00 AA
E 1.00 CC
Table 2
--
subitem feature
AA a
AA b
AA c
BB t
C y
i would like to display
--
subitem: AA
feature : a
b
c
--
item: A 2.50
B 1.50
D 2.00
--
subitem: BB
feature : t
--
item: C 1.00
--
subitem: CC
feature : y
--
item: E 1.00
--
i tried to link the two table together as one, it will display duplicate
item, like below
item price subitem features
A 2.50 AA a
A 2.50 AA b
A 2.50 AA c
B 1.50 AA a
B 1.50 AA b
B 1.50 AA c
C 1.00 BB t
D 2.00 AA a
D 2.00 AA b
D 2.00 AA c
E 1.00 CC y
and the result will be
--
subitem: AA
feature : a
b
c
--
item: A 2.50
A 2.50
A 2.50
B 1.50
B 1.50
B 1.50
D 2.00
D 2.00
D 2.00
--
subitem: BB
feature : t
--
item: C 1.00
--
subitem: CC
feature : y
--
item: E 1.00
--
or any idea to make the item to be distinct?On May 10, 5:53 pm, SL <S...@.discussions.microsoft.com> wrote:
> Hi,
> i have two matrix in two different lists with two different dataset. i would
> like to know if it is posible to put one of the list into another list?
> Please advice.
> For example, i have a item table with the item no ,price and sub item, item
> is unique, and i have another table which has the subitem no and item
> features, each item might have multiple row of feature.
> let say:
> Table 1
> --
> item price subitem
> A 2.50 AA
> B 1.50 AA
> C 1.00 BB
> D 2.00 AA
> E 1.00 CC
> Table 2
> --
> subitem feature
> AA a
> AA b
> AA c
> BB t
> C y
> i would like to display
> --
> subitem: AA
> feature : a
> b
> c
> --
> item: A 2.50
> B 1.50
> D 2.00
> --
> subitem: BB
> feature : t
> --
> item: C 1.00
> --
> subitem: CC
> feature : y
> --
> item: E 1.00
> --
> i tried to link the two table together as one, it will display duplicate
> item, like below
> item price subitem features
> A 2.50 AA a
> A 2.50 AA b
> A 2.50 AA c
> B 1.50 AA a
> B 1.50 AA b
> B 1.50 AA c
> C 1.00 BB t
> D 2.00 AA a
> D 2.00 AA b
> D 2.00 AA c
> E 1.00 CC y
> and the result will be
> --
> subitem: AA
> feature : a
> b
> c
> --
> item: A 2.50
> A 2.50
> A 2.50
> B 1.50
> B 1.50
> B 1.50
> D 2.00
> D 2.00
> D 2.00
> --
> subitem: BB
> feature : t
> --
> item: C 1.00
> --
> subitem: CC
> feature : y
> --
> item: E 1.00
> --
> or any idea to make the item to be distinct?
I would suggest handling this in the stored procedure/query that is
sourcing the report. You will most likely want to look into your
grouping setup.
Regards,
Enrique Martinez
Sr. Software Consultant|||The result is come from store procedure. As i said in the previous post, i
can either seperate into two dataset or combine two into one dataset which
will cause duplication. The duplication cannot be avoid in store procedure
because i need all the data, just that when i display them, i need to be
distinct. My question is that if it is possible to insert a list with
dataset1 into another list which has diff dataset, dataset2?|||Yes, you want subreports. The second report has a single list on it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SL" <SL@.discussions.microsoft.com> wrote in message
news:7CC9ACC7-4073-4DCD-BE1A-3FB7A4A9E29A@.microsoft.com...
> The result is come from store procedure. As i said in the previous post, i
> can either seperate into two dataset or combine two into one dataset which
> will cause duplication. The duplication cannot be avoid in store procedure
> because i need all the data, just that when i display them, i need to be
> distinct. My question is that if it is possible to insert a list with
> dataset1 into another list which has diff dataset, dataset2?
>