First off this isn't how I'd write the query to count all OS's. Secondly to do the drill downs you just create a second report and link the first to the second and pass through a value to a variable.
________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Chandler, Garrett W Sent: Tuesday, November 19, 2013 11:01 AM To: [email protected] Subject: [mssms] SSRS query design help - count of OS version by collection I'm trying to create report that I can run that will show a count of OS by specified collection. Then, similar to the built in Count OS version report, I want to be able to click on the OS version in the initial report and find the clients that meet that criteria. Essentially, I just want to prompt for a collection with the built in report rather than it just running. Here is the query I was attempting to use: SELECT OPSYS.Caption0 as 'OS', COUNT(*) AS 'Count' FROM fn_rbac_GS_OPERATING_SYSTEM(@UserSIDs) OPSYS inner join fn_rbac_R_System(@UserSIDs) sys on OPSYS.ResourceID=sys.ResourceID inner join v_FullCollectionMembership As FCM On SYS.ResourceID=FCM.ResourceID where FCM.CollectionID = @COLLID GROUP BY OPSYS.Caption0 ORDER BY OPSYS.Caption0 It now prompts for the collection, but I cannot expand the OS version categories to view the clients that meet the criteria. Has anyone accomplished this, or can see what I am doing wrong? Thanks, Garrett Chandler Desktop Support Specialist Denton ISD Technology 940-369-0120 [email protected]<mailto:[email protected]> ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
