Category Archives: Microsoft SQL Server Reports Service (SSRS)

Modify default AX Payroll Reports

One of our clients is currently asking to change the default Dynamics AX Payroll Reports—PayrollRegisterSummary as it counts twice in the Total Amount if employee has two same payment methods in the data (e.g. Direct Deposit). If we open the … Continue reading

Posted in Microsoft SQL Server Reports Service (SSRS) | Leave a comment

Only specific user cannot view report manager and report server site from one server (blank page without errors)

***Scope*** When some users run http://SSRSserver/reports and …./reportserver in one server, they get the blank page in IE. But other users can run it in the same server. Also all users can run the reports in IE in other servers (e.g. … Continue reading

Posted in Microsoft SQL Server Reports Service (SSRS) | Leave a comment

Dynamics AX SSRS database in Suspect status

[Scope] The SSRS reports stop running in Dynamics AX Enterprise Portal with the error ReportServerTempDB Database is Suspect.   [Environment] Build/Detailed Version: 5.0.1000.52 Database: SQL Server 2005   [Action]   1. Stop SQL Server Service 2. copy the ReportServerTempDB database … Continue reading

Posted in Microsoft SQL Server Reports Service (SSRS) | Leave a comment

The ReportServerVirtualDirectory element is missing.

[Bankground] When I open the Reporting Service website, I got the issue:The ReportServerVirtualDirectory element is missing.  An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing. Description: An unhandled exception occurred during the execution of the current web … Continue reading

Posted in Microsoft SQL Server Reports Service (SSRS) | 3 Comments

Web Service Methods Return “System.InvalidOperationException: Unable to Generate a Temporary Class”

Issue:   Once I configure the SQL Server 2005 Reporting Service, I used to configure the SSRS report server application pool run under the Microsoft Dynamics AX 2009 .Net Business Connector account.   But once I configured it on our … Continue reading

Posted in Microsoft SQL Server Reports Service (SSRS) | Leave a comment

SSRS 2008 website keep asking to enter username and password

Our client has got an issue hat SSRS keeps asking the username and password when they access the SSRS websites. We have checked all the SSRS configuration settings and found all the configurations is correct. Finally, we have found the … Continue reading

Posted in Microsoft SQL Server Reports Service (SSRS) | Leave a comment