Unable to run the report in report manager for couple of times...?

Question

I am getting the following error..when I run the report in report manager

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'Rank_Prior'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

When I am running the report in Visual Studio in report viewer ,Report is working fine without any errors. Where as when I am running the report in Report mnager I couldn't execute.After refreshing or going back to home page of report and again clicking on the report makes me to view the report.I have tried al the options so far what i get in my mind..like redeploying the report in the report manager,Checked to make sure the store procs runs perfectly in SSMS etc..But still I am facing this issue...

Please help me guys in this factor...

Answer 1

Hi,

check your settings on Reports:

first click details view, then click drop down on report and mange, review your settings for data source and security.

Answer 2

Hi deepak_cool,

The issue may occur if the it doesn't have sufficient permssion to execute the stored procedure that is used to generate the dataset when we run the report in the report manager. To check whether it is the case, you can configure the data source to use "Windows Integrated Security" for the credentials option. On the stored procedure side, we can grant the "Execute" permission for public database role referring to the following steps:

1. Open SSMS, connect to the database server, and navigate to the target database.
2. Expand the target database node -> Programmability -> Stored Procedures.
3. Right click on the target stored procedure, and open the Properties dialog box.
4. Click the Permissions tab, click Search -> Browser, select [public] and click OK twice.
5. Click the newly added public role, and check the Execute item in the Grant column, click OK. 

If the issue persists, please post the related error message in the Reporting Services Log file for further analysis. In SSRS 2008 R2, the Reporting Services log file is located in the <Drive>:\Program Files\Microsoft SQL Server\MSRS10_50.<Instance Name>\Reporting Services\LogFiles folder.

Regards,

---

Mike Yin
TechNet Community Support

Answer 3

Deepak,

First enable remote errors of the reporting services.

Connect to the reporting services using management studio and check the properties of the server: and make sure enable remote errors property is true!

              

Regards,Eshawr

---

--Please use Marked as Answer if my post solved your problem and use Vote As Helpful if the post was useful.