Report item expressions can only refer to other report items

Question

Post reply

Report item expressions can only refer to other report items

abbysql

SSC-Addicted

Points: 471
More actions
October 5, 2011 at 1:14 am

#244776

Can someone resolve this issue for me pleasee
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/15169a60-a783-429c-95b6-d004dd6d2d42

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Usually this means I have to go back to the dataset and do my calculation there and just put the field on the report.

Martin Schoombee SSCoach Points: 19128 More actions · Answer 2

abbysql (10/5/2011)

Can someone resolve this issue for me pleasee

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/15169a60-a783-429c-95b6-d004dd6d2d42%5B/quote%5D

Are there any differences between the source queries (probably stored procs...I hope) on the two servers?

abbysql SSC-Addicted Points: 471 More actions · Answer 3

Data Source is basically the same. The Stored Procedures used to be always on SERVER B, and from SERVER A it used to access the Stored Procedures on SERVER B. Now its more direct. Since all the Reports are being moved to SERVER B it self.

Still confused. I downloaded from Server A and tried to upload and these out of scope errors popped up.

Could it be that the XML File was not formatted properly when I downloaded the report, is there any clean way to get the original XML file for the SSRS Report.

Martin Schoombee SSCoach Points: 19128 More actions · Answer 4

abbysql (10/7/2011)
Data Source is basically the same. The Stored Procedures used to be always on SERVER B, and from SERVER A it used to access the Stored Procedures on SERVER B. Now its more direct. Since all the Reports are being moved to SERVER B it self.
Still confused. I downloaded from Server A and tried to upload and these out of scope errors popped up.
Could it be that the XML File was not formatted properly when I downloaded the report, is there any clean way to get the original XML file for the SSRS Report.

Hmm...interesting. I don't think the formatting of the XML is wack...downloading it from the server should be as good as any. Can you try and open the reports in Visual Studio (or BIDS), and deploy from there?

abbysql SSC-Addicted Points: 471 More actions · Answer 5

Yes, I tried that too, its giving me the same errors and not able to deploy the reports due to that errors. .......

Indeed it is interesting. I am also willing to do a webex with some one who wants to have a look at it. ....

Martin Schoombee SSCoach Points: 19128 More actions · Answer 6

abbysql (10/7/2011)
Yes, I tried that too, its giving me the same errors and not able to deploy the reports due to that errors. .......
Indeed it is interesting. I am also willing to do a webex with some one who wants to have a look at it. ....

I could do a webex with you, but only in about a week's time...don't know if that is too late for you.

Before we get there though, please have a look at the following:

1. Are the SSRS versions (including service packs) on both servers the same?

2. The text fields giving the errors seem not be part of a tablix. If so, ensure that the expressions explicitly refer to the datasource. You may have to recreate the expressions.

3. Check your datasources again. Make sure that the names are identical (case is important in the expressions). Also check field names.

4. Replace the expressions of the error fields with some other hard-coded value, and see if you are still unable to deploy the report. Just trying to make sure there are no other errors...

Hope this helps.