Tuesday, June 19, 2012

Using Microsoft SQL Report Builder 3 to create custom SCOM 2007 R2 reports

In SCOM 2007 R2 if you click "Design a new report" from the Reporting tab you will notice that Report Builder version 1 runs, even if you have version 3 installed because SCOM still opens the old link.
To use 3 instead navigate to the C:\Program Files\Microsoft SQL Server\MSRS10_50.SCOM\Reporting Services\ReportServer\ReportBuilder

Make a copy of "ReportBuilder_3_0_0_0.application"

Rename "ReportBuilder.application"

Rename the copy of version 3 to "ReportBuilder.application"

Now when you "Design a new report", SCOM will run Report Builder 3.

1 comment: