Cannot run SCCM reports from locally installed console

866

Recently we deployed configuration manager console for IT guys. The console was installed on laptops running Windows 7/10 OS. The IT users were located in remote locations. While most of the things were working fine, IT users had issues in running reports. Users mentioned that they cannot run SCCM reports from the console installed on their systems. Right-click report and click Run did nothing. The users had permissions to run and view the reports. However “Run in Browser” option worked fine for the users. The reports were accessible from the browser.

Cannot run SCCM reports

On one of the machine I could access the reports from browser. So this confirmed that the reporting was working fine.

Cannot run SCCM reports

Cannot run SCCM reports from locally installed console

Almost all the issues with the Configuration Manager console can be traced in the SMSAdminUI.log file. This file is located in C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole folder. Opening the smsadminui.log file using cmtrace tool revealed the following.

System.IO.FileNotFoundException\r\nCould not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies.The system cannot find the file specified.

Seems like the Microsoft report viewer package was missing. As a result the reports were not displayed at all. To install report viewer download it from here. You could also install the report viewer located under C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin folder.

What is Microsoft Report Viewer
Microsoft Report Viewer control enables applications that run on the .NET Framework to display reports designed using Microsoft reporting technology. This redistributable package contains Windows and Web versions of the Report Viewer.

Cannot run SCCM reports

Most of all, before you install report viewer,  close the configuration manager console . Right click ReportViewer package and install it. Hit Next on setup window.

Cannot run SCCM reports

Tick the box I have read and accept the license terms and click Install.

Cannot run SCCM reports

Finally click Finish once the installation is complete.

Cannot run SCCM reports

Launch the console and access the reports, it should work now.

Cannot run SCCM reports

Here is a video tutorial that explains the issue.

LEAVE A REPLY

Please enter your comment!
Please enter your name here