Data From 2 Datasets In One Table

i have 2 datasets in my report.



dataset1 brings back:

date shirts pants

4/1 3 5

4/2 4 6

4/3 2 9



dataset2 brings back:

date shoes boots

4/1 7 4

4/2 3 2

4/3 9 8



i want to to have a report that shows:

date shirts pants shoes boots

4/1 3 5 7 4

4/2 4 6 3 2

4/3 2 9 9 8



when i added a table in the layout tab, and drag in fields from the 2 datasets, for the dataset1, i would get fields like "=Fields!shirts.Value". but, when i drag in fields from dataset2, it shows up like "=Sum(Fields!shoes.Value, "dataset1")".



i don't want the sum, i just want the value. when i take out the "sum" part of the field expression, i get an error that says:

[rsFieldReference] The Value expression for the textbox €˜shoes_1€™ refers to the field €˜shoes€™. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.


any advice?



thank you much :-)