report builder - need help reporting from multiple tables

I created a data view and model that has two tables joined (one to many
relationship). When I go into report builder, I see both entities
available for me. When I click one of the entities, I am able to select
that entities data items to drag onto my report. However, the other
entity disapears. If I delete all the fields from the report, both
entities are available again. So it appears as if I can have as many
entities defined as I want, but can only use one at a time to report
on. I know I am doing something wrong because I have seen samples that
do what I am looking for - I just can't figure out how to do it.its because you don't have relationship between your 2 tables.
if you have some relation, in this case you can go from table A to table B
"directly"
else you have to go through other shared tables (with unexpected results)
"steve" <stevensherman@.comcast.net> wrote in message
news:1165065154.712904.183760@.f1g2000cwa.googlegroups.com...
>I created a data view and model that has two tables joined (one to many
> relationship). When I go into report builder, I see both entities
> available for me. When I click one of the entities, I am able to select
> that entities data items to drag onto my report. However, the other
> entity disapears. If I delete all the fields from the report, both
> entities are available again. So it appears as if I can have as many
> entities defined as I want, but can only use one at a time to report
> on. I know I am doing something wrong because I have seen samples that
> do what I am looking for - I just can't figure out how to do it.
>|||Thanks for your reply. I do have the relationship defined in the
reporting services model. Do I need to depict it somewhere else or am I
missing setting a property or something?|||Once the ralationships are defined in the datasource view, that is all
it takes. Report builder recognizes the relationship and will let you
select from both tables. If the tables are not joined in the datasource
view, then you will only be able to select attributes from one table or
the other - but not both.