Error message in Reporting Services on SQL Server

Tags:
SQL Server errors
SQL Server Reporting Services
I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might this mean?
ASKED: August 21, 2008  3:47 PM
UPDATED: August 22, 2008  7:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check the query in the dataset you are using for the report – it seems like you have a spelling mistake in your query, i.e. the table name is ‘salesexpo1′, but you are trying to reference a table called ‘saleexpo1′ (missing the middle <b>’s'</b>)

I often take my queries and test them in the SQL management studio first. That gives me a little more indication of the error if I have one.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following