"Chris McGuigan" wrote:

> Todd,
> In short, no!
>
> A data region can only access one dataset directly.
>
> There is an exception to that rule, but it won't help your scenario.
> You can refer to an aggregated field anywhere (except headers &
> footers),
> so in Table1 which uses DataSet1 you can refer to
> =Sum(Fields!MyField.Value, "DataSet2")
>
> For your scenario, you need to get all the data you need in one dataset.
>
> Cheers
> Chris
>
>
>
> Tango wrote:
>
> > Hi
> >
> > Is it possible to have a line chart with one group of colums stacked
> > based on 1 dataset with a column next to it based on a different
> > datatset. the catagory would be a common field in both datasets
> > (which is date)
> >
> > basically the chart would have 2 columns for each date, 1 would be
> > the staff away through sickness & the other would be relief staff
> > available to cover.
> >
> > Thanks in advance.
> >
> > Todd
>