Cannot preview SCCM Reports using SQL Server Data Tools (SSDT)

[Malte]

Hello everyone,

 

I started creating my own SQL reports for SCCM and want to make them RBA capable.

To get this work, I started creating a new report from the SCCM console, downloaded it and added it to my new SSDT project.

 

Now there are two things I cant figure out:

1) The report refers to a shared data source on the reporting services website, using the build-in report builder I can simply preview the report using this shared data source, is there a way to use this data source also with SSDT, or do I have only the option, to create a new data source and use this instead?

 

2) If I modify the data source and add the SrsResources.dll to the references of the report (as explained here: http://be.enhansoft.com/post/2013/10/23/How-To-Preview-SCCM-2012-R2-SSRS-Reports-in-BIDS.aspx)I still can't preview the report in SSDT, I get the following error:

The DefaultValue expression for the report parameter 'UserTokenSIDs' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

 

 

Is there a way to get this working with SSDT?

 

Cheers

Malte

[GarthMJ]

1) Don't try, the CM DS name is not a valid DS. Only use the DS once you upload you report to SSRS site. Then it works.

 

2) When you followed this blog post http://www.enhansoft.com/blog/how-to-preview-sccm-2012-r2-ssrs-reports-in-bids ; exactly which directly did you place the dll in?

[Malte]

Hi Garth,

 

I placed the dll in C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies.

Btw. I'm using SQL Server data tools from the SQL Server 2012 SP2 installation medium.

 

 

 

Warm Regards

 

Malte

[GarthMJ]

That is the wrong directory, it should be something like "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies"

[Malte]

The only Visual Studio Directory is "Microsoft Visual Studio 10.0" on the machine.

I'm using the SQL Server Data Tools from the SQL Server 2012 SP2 Installation Medium.

 

Which Version do you use?

 

 

Warm Regards

Malte