Error when accessing report - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Error when accessing report

Author

Topic

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2011-10-24 : 09:31:22

Hi I am getting the following error message when accessing the report from web browser.

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'Cardbalance'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

How to identify the issue?

Thanks,
Sandesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-24 : 09:37:26

run the report in local machine in business intelligence studio and see what error you're getting for dataset Cardbalance

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2011-10-24 : 10:26:24

Thanks. Solved the issue.

Thanks,
Sandesh

ssdeveloper
Starting Member

37 Posts

Posted - 2011-10-24 : 10:27:03

I think you need to check if the datasources in the reportserver are of same connection as the visual studio.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-24 : 11:15:33

quote:
Originally posted by sandesh.ravi

Thanks. Solved the issue.

Thanks,
Sandesh

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources