SCCM ConfigMgr How to Resolve Optional Fields Act as Mandatory in Default Report in SSRS

Let’s discuss SCCM ConfigMgr How to Resolve Optional Fields Act as Mandatory in Default Report in SSRS. In this post I will talk about how to resolve Optional fields are mandatory in SSRS’s default report.

SQL Server Reporting Services (SSRS) is one of the requirements for the SCCM CB reporting services point. The SQL reporting service is part of SQL Server installation.

SQL Server Reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality. The SCCM has tight integration with SCCM reporting services point this integration helps SSRS to produce SCCM default reports.

Steps to resolve the issue of optional fields in the SCCM ConfigMgr SSRS default report.

SCCM ConfigMgr How to Resolve Optional Fields Act as Mandatory in Default Report in SSRS

Right-click the report in the console and select “Properties”, Then Click the “Edit SQL Statement” button;

• Click the “Prompts” button;
• Right-click the “ChannelCode” prompt and select “Properties”;
• Clear the “Provide a SQL statement” option;
• Click the “OK” button in all open dialogs to confirm the changes.

• ConfigMgr Reports Power Management | Default | SCCM
• How To Disable SCCM Application Deployment | ConfigMgr | MEMCM
• Install ConfigMgr SSRS Reporting Services Point | SCCM | Configuration Manager | Endpoint Manager HTMD Blog (anoopcnair.com)
• Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager
• Upgrade SSRS SQL Server Reporting Services to 2019 for SCCM Infrastructure

This will allow you to run the report without specifying a value for the Channel Code. If you’d instead not modify the original report, you can create a copy by right-clicking the report, selecting “Clone”, and then changing the copied report.

Either way, you must copy the modified report to your SQL Reporting Services Point by right-clicking the associated object and selecting “Copy Reports to Reporting Services.”

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.