Thank you. I was able to get the collection prompt working, but like you did, I am having a problem getting the results to actually filter by collection.
I am modifying the built-in States 1 report, which already has DataSet0 and DataSet1. I've added the new DataSet for the collection prompt but wherever I put the "JOIN v_FullCollectionMembership fcm on fcm.resourceid=v_r_system.resourceid WHERE fcm.Collectionid= @Collection" it says invalid syntax. I've tried adding it to both datasets to no avail. -Craig From: [email protected] [mailto:[email protected]] On Behalf Of Art Flores Sent: Friday, July 11, 2014 6:35 PM To: [email protected] Subject: RE: [mssms] ConfigMgr 2012 R2 Enforcement Report I just recently got my first prompt for a collection to work :) The first link below was a good learning exercise for me since it was my first time using Report Builder 3.0, and it worked, but when I tried to build my own custom report, it didn't. The 2nd link got my new custom report working, thanks to Sherry Kissinger. When I have more time, I want to try and do the dashboard described in the 3rd link. http://asithadesilva.wordpress.com/2013/04/01/how-to-prompt-collection-to-a-report-in-sccm-2012/ http://www.myitforum.com/forums/Reporting-Prompt-for-collection-m238953.aspx http://blogs.technet.com/b/gary_simmons_mcs/archive/2013/12/09/creating-a-custom-report-for-system-center-2012-r2-configuration-manager-part-1.aspx From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Griffin Craig Sent: Friday, July 11, 2014 9:24 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] ConfigMgr 2012 R2 Enforcement Report Hi All, I've been trying to customize the built-in "States 1 - Enforcement states for a deployment" report to add a collection prompt. Our update groups are based on OS and would like to view the status per collection so we can get a clear picture. Anyone good with SRS reporting have a template or any idea where I can start? Much appreciated! -Craig Griffin
