Previewing SCCM 2012 R2 SSRS Reports in BIDS

By Garth Jones

Taking only 5 minutes to set-up, you can preview CM12 R2 SSRS reports in SQL Server Business Intelligence Development Studio (BIDS) instead of uploading reports to the CM12 R2 SSRS site to preview and test each time. Doing this now will save you all those extra time-consuming steps later!

I worked on this for a while (days actually) and sent out emails to different teams trying to figure out how to get this to work. Ultimately I found a forum post that talked about private assemblies.

Let me save you days of headaches with only 5 minutes of work!

1. On your Report Services point, locate the SMS_SRSRP folder.

2. Copy the SrsResources.dll to your private assemblies directory on your BIDS workstation.

a. Visual Studio 2005 = C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

b. Visual Studio 2008 = C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies

c. Visual Studio 2010 = C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies

In my case it is C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

3. Open your BIDS Solution and for each report within your solution:

a. While on the layout tab, select the Report menu and click Report Properties.

Setup BIDS-ReportProperties

b. Click the References tab.

c. Click the … button.

Setup BIDS-Click Button

d. Click the Browse tab and select the SrsResources.dll and click Add.

Setup BIDS-SrsResourcesDLL

e. Click OK.

4. You’re done!

Tip: When you complete step 3d once, the DLL will show up within the Recent tab and you will no longer need to browse for it.

Setup BIDS-RecentTab

By doing this simple task you will save yourself a ton of time and headaches. Now you can preview Role-Based Administration (RBA) reports in BIDS and create them too!

Setup BIDS-PreviewReport

email

Written by , Posted .