Saturday, February 25, 2012

reporting services--preview error

I am ceating reports using VS 2005, for sql 2005(don't know if you can do it for sql 2000 also). but here is the link for tutorial,http://msdn2.microsoft.com/en-us/library/ms171046.aspx. When I add the query from Step 2. it get the following error, I have tried the code with "=" and "&" also.

"[rsFieldReference] The Value expression for the textbox 'FirstName' refers to the field 'FirstName'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

[rsFieldReference] The Value expression for the textbox 'LastName' refers to the field 'LastName'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

[rsFieldReference] The Value expression for the textbox 'Title' refers to the field 'Title'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

Build complete -- 3 errors, 0 warnings".

Can someone help me?

thanks in advance!

you might want to try runing the query in the data view or try removing the field entries and replacing them. i think what is happening is there's a problem when you update a dataset sometimes the field elements no longer reconize the dataset not to sure.|||

I figured it out today, you have to use generic query designer to execute the Parameter!... stuff. Apparently whan i toggled it; i was in the wrong query designer.

No comments:

Post a Comment