Combine 2 collections into Clustered Bar Chart using Report Builder

Question

I am new to Report Building and am plannng to use Report Builder 3 with SCCM 2008 R3 to combine 2 collections into a single clustered bar chart instead of manual import to Excel.

Encrypted Laptops:

Select DISTINCT
   R.Name0,
   R.User_Name0,
   R.AD_Site_Name0
from
   v_R_System R
join
 v_FullCollectionMembership fcm on R.ResourceID=fcm.ResourceID
where
 fcm.CollectionID = 'PR1002A8'
ORDER BY R.AD_Site_Name0

ALL Laptops:

Select DISTINCT
   R.Name0,
   R.User_Name0,
   R.AD_Site_Name0,
from
   v_R_System R
join
 v_FullCollectionMembership fcm on R.ResourceID=fcm.ResourceID
where
 fcm.CollectionID = 'PR100260'

Site 1

All Laptops

Encrypted Laptops

Site 2

All Laptops

Encrypted Laptops

Answer 1

Hi Geek Sikh,

Thank you for your question. 

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Thanks,
Eileen

If you have any feedback on our support, please click here

---

Eileen Zhao
TechNet Community Support

Answer 2

Hi Geek Sikh,

From your description, you can combine the queries and use the following WHERE clause:

Where fcm.CollectionID = 'PR1002A8' and fcm.CollectionID = 'PR100260'

Then, in the Report Builder 3.0, you can drag the CollectionID field into the Series Groups area of the 3-D Clustered Bar Chart.

Hope this helps.

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support