Error message in Reporting Services on SQL Server
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 21, 2008 3:47 PM
UPDATED:
August 22, 2008 7:10 PM
RELATED QUESTIONS
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
