where in the query are you adding the join and the where? Can you post the whole query (unedited and then with the what you think should work); for people here to critique? maybe it's just location in the query, or you have two where clauses (and that don't work) or maybe you are putting the join after the order by or something (and that's bogus, too)
Sherry Kissinger On Monday, July 14, 2014 11:38 AM, Griffin Craig <[email protected]> wrote: 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 J 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]] On Behalf Of Griffin Craig Sent: Friday, July 11, 2014 9:24 AM To: [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
