report model project question

I am having a problem trying to get the correct data on the report.
It is a typical schema where we have clients, doctors and both of those have
doctors. I am unable to show clients, client addresses and doctors on the
same report builder report. I can get 2 of those not 3.
any ideas? (is this a limitation of the product?)It all depends on the relation you set to be visible in the report model. So
you need to select the proper table and the keys.
Amarnath
"dave" wrote:
> I am having a problem trying to get the correct data on the report.
> It is a typical schema where we have clients, doctors and both of those have
> doctors. I am unable to show clients, client addresses and doctors on the
> same report builder report. I can get 2 of those not 3.
> any ideas? (is this a limitation of the product?)|||What do you mean "the relation you set to be visible"? How and where do you
specify visible options?
Sorry new to this.
thank you
dave
"Amarnath" wrote:
> It all depends on the relation you set to be visible in the report model. So
> you need to select the proper table and the keys.
> Amarnath
>
> "dave" wrote:
> > I am having a problem trying to get the correct data on the report.
> >
> > It is a typical schema where we have clients, doctors and both of those have
> > doctors. I am unable to show clients, client addresses and doctors on the
> > same report builder report. I can get 2 of those not 3.
> >
> > any ideas? (is this a limitation of the product?)|||Ok, Visible means nothing like enabling or disabling. but what I meant was,
setting the right relation, so that it can be selected for your reports from
report builder. If you dont have the relation or if the PK or FK is not
present in the tables, then that can't be selected, which you will come to
know when you go for setting the relation using the wizard.
Amarnath
"dave" wrote:
> What do you mean "the relation you set to be visible"? How and where do you
> specify visible options?
> Sorry new to this.
> thank you
> dave
> "Amarnath" wrote:
> > It all depends on the relation you set to be visible in the report model. So
> > you need to select the proper table and the keys.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I am having a problem trying to get the correct data on the report.
> > >
> > > It is a typical schema where we have clients, doctors and both of those have
> > > doctors. I am unable to show clients, client addresses and doctors on the
> > > same report builder report. I can get 2 of those not 3.
> > >
> > > any ideas? (is this a limitation of the product?)