Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Combine 2 collections into Clustered Bar Chart using Report Builder

Beantwortet Combine 2 collections into Clustered Bar Chart using Report Builder

  • Wednesday, February 13, 2013 7:41 PM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Friday, February 15, 2013 1:36 PM
    Moderator
     
     
    Sign In to Vote
    0
    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

     
  • Monday, February 18, 2013 2:34 AM
    Moderator
     
     Answered Has Code
    Sign In to Vote
    0

    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