FYI – I was able to resolve my issue.
It seems the little query window inside report builder’s dataset properties is picky. I was copying the default report query for the data set, modifying it in SQL Management Studio, then pasting it back in. That didn’t work, but if I manually opened the little query window inside the data set and manually pasted the joins I needed and the columns I required, it worked. It would be nice to still have ASP reporting as a complimentary service to the much more powerful SSRS. Simple reports take me that much longer as I have to navigate through SSRS website to create the report, then launch report builder, create my data sets, add the fields, etc…. I like it, but I also like being able to cut and paste SQL and it just works. From: [email protected] [mailto:[email protected]] On Behalf Of Garth Jones Sent: Friday, January 31, 2014 10:13 AM To: [email protected] Subject: RE: [mssms] Customizing default reports in SCCM 2012 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:[email protected] Enhancing Your Business <http://be.enhansoft.com/> Description: Description: Description: Description: Description: Description: Description: cid:[email protected] <https://twitter.com/enhansoft> Description: Description: Description: Description: Description: Description: Description: cid:[email protected] <http://www.facebook.com/EnhansoftInc> Description: Description: Description: Description: Description: Description: Description: cid:[email protected] <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:[email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Friday, January 31, 2014 9:39 AM To: [email protected] 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: [email protected] [mailto:[email protected]] On Behalf Of Nick Sent: Friday, January 31, 2014 9:31 AM To: [email protected] 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: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Thursday, January 30, 2014 9:03 PM To: '[email protected]'; '[email protected]' 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 [[email protected]] Sent: Thursday, January 30, 2014 08:56 PM Eastern Standard Time To: [email protected] 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>>
