Hii,, Scenario: Windows 2008 R2 SCCM 2007SP2R3 - Virtual Server SCOM 2007 R2 - Virtual Server SCSM2010 with SP1 - Virtual Server SQL 2008 SP2 - Virtual Server Description: Before Installating the SCSM 2010, I wan able to generate SCOM reports. As per the requirement of SCSM 2010 SP1 installation, I replaced the Microsoft.EnterpriseManagement.Reporting.Code.Dll located in C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin with the provided dll file in SCSM media. Issue: SCOM and SCSM reporting is not working and giving below error but SCCM reporting is working fine. Error: Cannot initialize report. Failed to load expression host assembly. Details: Note: The following information was gathered when the operation was attempted. The information may appear cryptic but provides context for the error. The application will continue to run. Microsoft.Reporting.WinForms.ReportServerException: Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (rsErrorLoadingExprHostAssembly) at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WinForms.ServerReport.GetParameters() at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args) Regards, Syed Fahad Ali

Please suggest!!Regards, Syed Fahad Ali

Please suggest!!Regards, Syed Fahad Ali

Can anyone suggest for the solution?Regards, Syed Fahad Ali

Just resolved my issue. 1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx) 2. Click on the Folder in which u have reports 3. U will be directed into contents tab where u will find Show Details at the right top corner 4. Click on Show Details 5. Check in the particular report and click the edit button corresponding to it 6. Go to the properties tab and click on it 7. U will find a menu on left hand side, click on Data Sources link 8. There u will find radio button selected for A share data source(by default) and a browse button. 9. Click on the browse button u will find the tree structure of the datasource and the reports folder. 10. select the datasource in the datasource folder and select OK. by this way u will be able to point the report to the datasource.Regards, Syed Fahad Ali