Error: "expression can only refer to field w/ data scope"

I get the following error when i try to add a new field being returned in a
dataset:
"Report item expressions can only refer to fields within the current data
set scope or, if inside an aggregate, the specified data set scope".
I have no idea what this means, and i can reference just fine every other
field i'm returning in the dataset.
I found an earlier person who had this problem, and the response was "you
can only bind one dataset to a report item". This can't be my problem,
though, as i've only GOT one dataset.
TIA,
--
BrianSide note (may not be the solution to your problem):
You can bind more than one dataset to a report! I've done this
successfully, and it's actually pretty easy.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> I get the following error when i try to add a new field being returned in
a
> dataset:
> "Report item expressions can only refer to fields within the current data
> set scope or, if inside an aggregate, the specified data set scope".
> I have no idea what this means, and i can reference just fine every other
> field i'm returning in the dataset.
> I found an earlier person who had this problem, and the response was "you
> can only bind one dataset to a report item". This can't be my problem,
> though, as i've only GOT one dataset.
> TIA,
> --
> Brian
>|||Both comments below are true: You can have several datasets in a **report**
but only bind one dataset to a **report item**.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQL" <nospam@.adfadfadf.com> wrote in message
news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> Side note (may not be the solution to your problem):
> You can bind more than one dataset to a report! I've done this
> successfully, and it's actually pretty easy.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > I get the following error when i try to add a new field being returned
in
> a
> > dataset:
> >
> > "Report item expressions can only refer to fields within the current
data
> > set scope or, if inside an aggregate, the specified data set scope".
> >
> > I have no idea what this means, and i can reference just fine every
other
> > field i'm returning in the dataset.
> >
> > I found an earlier person who had this problem, and the response was
"you
> > can only bind one dataset to a report item". This can't be my problem,
> > though, as i've only GOT one dataset.
> >
> > TIA,
> >
> > --
> > Brian
> >
> >
>|||That's all well and good, but none of these apply to my situation! I have
only one dataset, period, yet i'm getting this error.
Is there another problem that could cause this sort of error?
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:Ot5fX7xfEHA.1048@.tk2msftngp13.phx.gbl...
> Both comments below are true: You can have several datasets in a
**report**
> but only bind one dataset to a **report item**.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "SQL" <nospam@.adfadfadf.com> wrote in message
> news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> > Side note (may not be the solution to your problem):
> >
> > You can bind more than one dataset to a report! I've done this
> > successfully, and it's actually pretty easy.
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > I get the following error when i try to add a new field being returned
> in
> > a
> > > dataset:
> > >
> > > "Report item expressions can only refer to fields within the current
> data
> > > set scope or, if inside an aggregate, the specified data set scope".
> > >
> > > I have no idea what this means, and i can reference just fine every
> other
> > > field i'm returning in the dataset.
> > >
> > > I found an earlier person who had this problem, and the response was
> "you
> > > can only bind one dataset to a report item". This can't be my problem,
> > > though, as i've only GOT one dataset.
> > >
> > > TIA,
> > >
> > > --
> > > Brian
> > >
> > >
> >
> >
>|||Found it!!!!
Dunno if this is a bug or expected behavior or what but....
I was using the custom query designer because i had a rather dynamic query
to write. When i added a new field in the return set, that field was NOT
automatically added to the field list in the dataset returned fields window.
I had to manually add that field. Solved the problem.
Brian
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:OIUd%23Y6fEHA.236@.tk2msftngp13.phx.gbl...
> That's all well and good, but none of these apply to my situation! I have
> only one dataset, period, yet i'm getting this error.
> Is there another problem that could cause this sort of error?
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:Ot5fX7xfEHA.1048@.tk2msftngp13.phx.gbl...
> > Both comments below are true: You can have several datasets in a
> **report**
> > but only bind one dataset to a **report item**.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "SQL" <nospam@.adfadfadf.com> wrote in message
> > news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> > > Side note (may not be the solution to your problem):
> > >
> > > You can bind more than one dataset to a report! I've done this
> > > successfully, and it's actually pretty easy.
> > >
> > >
> > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > > I get the following error when i try to add a new field being
returned
> > in
> > > a
> > > > dataset:
> > > >
> > > > "Report item expressions can only refer to fields within the current
> > data
> > > > set scope or, if inside an aggregate, the specified data set scope".
> > > >
> > > > I have no idea what this means, and i can reference just fine every
> > other
> > > > field i'm returning in the dataset.
> > > >
> > > > I found an earlier person who had this problem, and the response was
> > "you
> > > > can only bind one dataset to a report item". This can't be my
problem,
> > > > though, as i've only GOT one dataset.
> > > >
> > > > TIA,
> > > >
> > > > --
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>|||Either that or you can use the static version of the query first, which will
populate the fields list for you, and then replace it with the the
corresponding query expression.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:up0IDI7fEHA.2020@.TK2MSFTNGP10.phx.gbl...
> Found it!!!!
> Dunno if this is a bug or expected behavior or what but....
> I was using the custom query designer because i had a rather dynamic query
> to write. When i added a new field in the return set, that field was NOT
> automatically added to the field list in the dataset returned fields
window.
> I had to manually add that field. Solved the problem.
> Brian
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:OIUd%23Y6fEHA.236@.tk2msftngp13.phx.gbl...
> > That's all well and good, but none of these apply to my situation! I
have
> > only one dataset, period, yet i'm getting this error.
> >
> > Is there another problem that could cause this sort of error?
> >
> >
> > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
message
> > news:Ot5fX7xfEHA.1048@.tk2msftngp13.phx.gbl...
> > > Both comments below are true: You can have several datasets in a
> > **report**
> > > but only bind one dataset to a **report item**.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > "SQL" <nospam@.adfadfadf.com> wrote in message
> > > news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> > > > Side note (may not be the solution to your problem):
> > > >
> > > > You can bind more than one dataset to a report! I've done this
> > > > successfully, and it's actually pretty easy.
> > > >
> > > >
> > > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > > news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > > > I get the following error when i try to add a new field being
> returned
> > > in
> > > > a
> > > > > dataset:
> > > > >
> > > > > "Report item expressions can only refer to fields within the
current
> > > data
> > > > > set scope or, if inside an aggregate, the specified data set
scope".
> > > > >
> > > > > I have no idea what this means, and i can reference just fine
every
> > > other
> > > > > field i'm returning in the dataset.
> > > > >
> > > > > I found an earlier person who had this problem, and the response
was
> > > "you
> > > > > can only bind one dataset to a report item". This can't be my
> problem,
> > > > > though, as i've only GOT one dataset.
> > > > >
> > > > > TIA,
> > > > >
> > > > > --
> > > > > Brian
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>