all groups > sql server reporting services > september 2005 >
You're in the

sql server reporting services

group:

Stored Procedures and Preview


Stored Procedures and Preview Rosalba Meza
9/15/2005 4:24:01 PM
sql server reporting services: 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
RE: Stored Procedures and Preview tutor
9/16/2005 5:19:04 AM
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]
RE: Stored Procedures and Preview Rosalba Meza
9/16/2005 7:59:06 AM
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]
RE: Stored Procedures and Preview Ashish Ruparel
9/18/2005 11:08:02 PM
Is your SP refering to a Temporary Table ?

Ashish


[quoted text, click to view]
RE: Stored Procedures and Preview Rosalba Meza
9/19/2005 3:39:02 PM
No, i think i will have to use a query dataset

[quoted text, click to view]
AddThis Social Bookmark Button