<div>
It was a permission issue. &nbsp;I found the error as I drilled down through the access/mapping/role permissions. &nbsp;Thank you for your help, it was staring me right in the face.
</div>


It was a permission issue.  I found the error as I drilled down through the access/mapping/role permissions.  Thank you for your help, it was staring me right in the face.

<div>
<div class="content wysiwyg-content">
I have a SQL report that is built with Visual Studio 2010, the report was built for in house reporting and looks to several views in our dbase. It runs fine when I do so from visual studio, but I now would like to automate this and pulled the report into SSRS and tried to subscribe it out. The report will not run in SSRS because it doesn't recognize the views, only the actual tables. It's a fairly lengthy and complex report written by someone much smarter than I, so fooling around with the report code is a last resort. I tried adding a dataset and made a simple SQL statement SELECT * FROM AA_SalesGRP and it sees the fields ok, but the actual report still chokes when run on SSRS.<br />
<br />
the error I get when trying to run the report from SSRS<br />
<br />
An error has occurred during report processing. (rsProcessingAborted)<br />
Query execution failed for dataset 'AA_SalesGRP'. (rsErrorExecutingCommand)<br />
Invalid object name 'AA_SalesGRP'.
</div>
</div>


I have a SQL report that is built with Visual Studio 2010, the report was built for in house reporting and looks to several views in our dbase. It runs fine when I do so from visual studio, but I now would like to automate this and pulled the report into SSRS and tried to subscribe it out. The report will not run in SSRS because it doesn't recognize the views, only the actual tables. It's a fairly lengthy and complex report written by someone much smarter than I, so fooling around with the report code is a last resort. I tried adding a dataset and made a simple SQL statement SELECT * FROM AA_SalesGRP and it sees the fields ok, but the actual report still chokes when run on SSRS.

the error I get when trying to run the report from SSRS

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'AA_SalesGRP'. (rsErrorExecutingCommand)
Invalid object name 'AA_SalesGRP'.

SSRS wont run because of view

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.