how to add multiple entities in report builder?

I have SQLRS running under MOSS (ie in a report library).
Have created a datasource and use report builder the build a report.
When I *start* a *new* report I see all the entitities (tables) in the
database on the left hand side......I can drag and drop tables/
columns to the report BUT once I have dragged *one* entities columns
to the report all the others disappear......
so I now *only* have one entity on the left hand side with its columns
below.
Is this expected behavour? I thought I would be able to add another
entity and make a join between them...but this doesnt seem to be
possible?
How can i make other entitiies display in the explorer on the left?
Thanks
Al BlakeHi
RB works with Report Model and the relations are set there. If you want to
add any other entity you need to define there at RM. This behaviour is by
design.
Amarnath, MCTS
"scubaal" wrote:
> I have SQLRS running under MOSS (ie in a report library).
> Have created a datasource and use report builder the build a report.
> When I *start* a *new* report I see all the entitities (tables) in the
> database on the left hand side......I can drag and drop tables/
> columns to the report BUT once I have dragged *one* entities columns
> to the report all the others disappear......
> so I now *only* have one entity on the left hand side with its columns
> below.
> Is this expected behavour? I thought I would be able to add another
> entity and make a join between them...but this doesnt seem to be
> possible?
> How can i make other entitiies display in the explorer on the left?
> Thanks
> Al Blake
>