I have a whole pile of blog posts about SSRS and RBA and the various errors you can get them. Here are a few of them.
http://be.enhansoft.com/post/2013/12/17/SCCM-2007-Built-in-Reports-Do-NOT-Open-in-Report-Builder-10.aspx http://be.enhansoft.com/post/2013/10/29/SrsResources-is-Not-Declared-Wrong-DLL.aspx http://be.enhansoft.com/post/2013/10/28/SrsResources-is-Not-Declared-Missing-DLL.aspx http://be.enhansoft.com/post/2013/10/24/Test-Your-Role-Based-Administration-(RBA)-Queries-in-SQL-Server-Management-Studio-(SSMS).aspx http://be.enhansoft.com/post/2013/10/23/How-To-Preview-SCCM-2012-R2-SSRS-Reports-in-BIDS.aspx Garth Jones Chief Architect <http://www.enhansoft.com/> www.Enhansoft.com <http://www.enhansoft.com/> Description: Description: cid:image001.jpg@01CC63FB.974F4EC0 Enhancing Your Business <http://be.enhansoft.com/> Description: Description: Description: Description: Description: Description: Description: cid:image004.png@01CD5E19.F3C3A110 <https://twitter.com/enhansoft> Description: Description: Description: Description: Description: Description: Description: cid:image005.png@01CD5E19.F3C3A110 <http://www.facebook.com/EnhansoftInc> Description: Description: Description: Description: Description: Description: Description: cid:image006.jpg@01CD5E19.F3C3A110 <http://www.youtube.com/user/Enhansoft/videos> Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page <http://myitforum.com/myitforumwp/community/groups/enhansoft/> Description: Description: Description: Description: Description: Description: Description: cid:image007.png@01CD5E19.F3C3A110 From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Friday, January 31, 2014 9:39 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] Customizing default reports in SCCM 2012 I could have sworn it was Garth that posted it, but I couldn’t find it online. I did find this though, and it’s basically the same explanation. http://blogs.technet.com/b/smartinez/archive/2013/11/28/how-to-create-a-rba-capable-report-for-configmgr-r2.aspx Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Nick Sent: Friday, January 31, 2014 9:31 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] Customizing default reports in SCCM 2012 I saw the posts around changing the graphics in the default reports to show your company logo, but I’ve not seen anything regarding updating them. Yes, it’s using the rbac functions in the report. Here’s what I don’t want to have to do, but would work for the needs – is that I could create a collection of non-compliant computers and provide the custom data on those based on collection membership, but I don’t want to get in the business of creating collections just so I can report against computers that meet my simple criteria of “compliant or not compliant”. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Thursday, January 30, 2014 9:03 PM To: 'mssms@lists.myitforum.com'; 'mssms@lists.myitforum.com' Subject: RE: [mssms] Customizing default reports in SCCM 2012 Does it use any functions for RBAC? Check out Garth Jones posts about modifying those reports, they are a bear. I usually recreate the report and queries from scratch. -Daniel Ratliff -----Original Message----- From: Nick [nick.aqu...@hotmail.com] Sent: Thursday, January 30, 2014 08:56 PM Eastern Standard Time To: mssms@lists.myitforum.com Subject: [mssms] Customizing default reports in SCCM 2012 Hi all, Been a while since I’ve been active on the forum. I’ve copied the default report “List of assets by compliance state for a configuration item in a configuration baseline.” I need to add a few columns from the v_r_user view and maybe some additional computer information to the report so that it is more useful for the end-users. I’ve tried a few things like adding a simple JOIN to the main select statement and even editing the temp table that is created in the report but no matter what, I continue to be prompted to “Define Query Parameters”. No matter what I do from this point on, either most of the fields in the data set disappear, or if I select the check boxes next to all of the fields in the “Define query parameters” dialog, click OK, then Cancel to the prompt, the report eventually errors out with: “Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand)” Any ideas? Should it be this hard to add a column to the default reports? I feel like I’m making huge strides in reporting with 2012 but this has me stumped. -Nick- The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
<<image001.jpg>>
<<image002.png>>
<<image003.png>>
<<image004.jpg>>
<<image005.png>>
<<image006.png>>
