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