IF working with your RDL in VS.NET, right-click the RDL and select view (XML)
code. Do an Edit-Find (for field 'ZZZZ'), it will take you directly to the
field and from this you should be able to identify what the data source field
reference is (possibly mispelled, dataset fields need to be refreshed, etc.).
Rob
[quoted text, click to view] "Rosalba Meza" wrote:
> Hi i am working with SP in RS when i run the dataset i get the right results,
> but when i try to preview the repor i get this error "The data set ‘XXX’
> contains a definition for the field ‘ZZZZ’. This field is missing from the
> returned result set from the data source."
>
> I added the fields in the dataset definition and all are right and I can not
I checked everything and make another report using the same SP but i am
getting the same error, could you please give me any advice or maybe i do not
know how to use a SP in RS.
[quoted text, click to view] "tutor" wrote:
> IF working with your RDL in VS.NET, right-click the RDL and select view (XML)
> code. Do an Edit-Find (for field 'ZZZZ'), it will take you directly to the
> field and from this you should be able to identify what the data source field
> reference is (possibly mispelled, dataset fields need to be refreshed, etc.).
>
> Rob
>
> "Rosalba Meza" wrote:
>
> > Hi i am working with SP in RS when i run the dataset i get the right results,
> > but when i try to preview the repor i get this error "The data set ‘XXX’
> > contains a definition for the field ‘ZZZZ’. This field is missing from the
> > returned result set from the data source."
> >
> > I added the fields in the dataset definition and all are right and I can not
Is your SP refering to a Temporary Table ?
Ashish
[quoted text, click to view] "Rosalba Meza" wrote:
> I checked everything and make another report using the same SP but i am
> getting the same error, could you please give me any advice or maybe i do not
> know how to use a SP in RS.
>
> "tutor" wrote:
>
> > IF working with your RDL in VS.NET, right-click the RDL and select view (XML)
> > code. Do an Edit-Find (for field 'ZZZZ'), it will take you directly to the
> > field and from this you should be able to identify what the data source field
> > reference is (possibly mispelled, dataset fields need to be refreshed, etc.).
> >
> > Rob
> >
> > "Rosalba Meza" wrote:
> >
> > > Hi i am working with SP in RS when i run the dataset i get the right results,
> > > but when i try to preview the repor i get this error "The data set ‘XXX’
> > > contains a definition for the field ‘ZZZZ’. This field is missing from the
> > > returned result set from the data source."
> > >
> > > I added the fields in the dataset definition and all are right and I can not
No, i think i will have to use a query dataset
[quoted text, click to view] "Ashish Ruparel" wrote:
> Is your SP refering to a Temporary Table ?
>
> Ashish
>
>
> "Rosalba Meza" wrote:
>
> > I checked everything and make another report using the same SP but i am
> > getting the same error, could you please give me any advice or maybe i do not
> > know how to use a SP in RS.
> >
> > "tutor" wrote:
> >
> > > IF working with your RDL in VS.NET, right-click the RDL and select view (XML)
> > > code. Do an Edit-Find (for field 'ZZZZ'), it will take you directly to the
> > > field and from this you should be able to identify what the data source field
> > > reference is (possibly mispelled, dataset fields need to be refreshed, etc.).
> > >
> > > Rob
> > >
> > > "Rosalba Meza" wrote:
> > >
> > > > Hi i am working with SP in RS when i run the dataset i get the right results,
> > > > but when i try to preview the repor i get this error "The data set ‘XXX’
> > > > contains a definition for the field ‘ZZZZ’. This field is missing from the
> > > > returned result set from the data source."
> > > >
> > > > I added the fields in the dataset definition and all are right and I can not
Don't see what you're looking for? Try a search.