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 2005 Forums  Analysis Server and Reporting Services (2005)  Report error after deployment

Author  Topic  joshker Starting Member 6 Posts Posted - 2007-03-27 : 16:39:57 I have created a report on my local machine and deployed it on a server. As I am the administrator of the server, I can access the reports with servername\Reports. The report has got three data sets. Out of these three one is a Stored procedure and other two data sets have sql queries. The user selects the 'Business year' and 'sales type' from list box. This report works perfect from my local machine as well as from teh server when I am running it I have some other users who wish to access these reports. I did the following steps: Created a new role and assigned it at the Data Source Folder and Reports Folder I also made the user a Database user on the server. After doing these steps, the user can access the Reports site by servername\Reports. The user then can go into the Reports folder. But when the user tries to run the report, he gets an error with: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'BusinessYear'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors Can anyone help me with this? Is htere something to do with setting up of the datasource? I have tried to search, but could not find relevant info. Any help/Pointers will be really appreciated. regards Joshker