0 Replies Latest reply on Jun 17, 2014 2:17 PM by basil_free

    How can I chart the group member availability in the web report?

    basil_free

        I posted this as a discussion as well in the report GURU.

      I am attempting to chart the availability of members of group. I was able to
      duplicate the group member availability table report from the report writer on
      the server to the web piece by using the sql method.  It was the only way
      to get the group availability column. Apparently I need a time column
      defined to align with the datasource and under the more option I don’t have
      that column available for the group.  My question is how can I add
      that option, is there something I can add to the sql query below?  I am not a SQL guy.  Any help would be appreciated.

       

      Text of the sql query :

      Select Group_Name,
      Group_Member_Name,  Cast(Group_Member_Status As nvarchar(250)) as
      Group_Member_Status, Group_Member_Availability From ( SELECT

       

      Containers_AlertsAndReportsData.GroupName
      AS Group_Name, Containers_AlertsAndReportsData.GroupMemberName AS
      Group_Member_Name, Containers_AlertsAndReportsData.GroupMemberStatusDescription
      AS Group_Member_Status,
      Containers_AlertsAndReportsData.GroupMemberPercentAvailability AS
      Group_Member_Availability

       

      FROM

       

      Containers_AlertsAndReportsData

       

      WHERE 

       

      (

       
      (Containers_AlertsAndReportsData.GroupName LIKE '%Tier-1-Windows%')

       

      )

       

       

       

      ) As r ORDER BY 1 ASC, 2 ASC

       

       

      webreport1.jpg

      webreport2.jpg

      webreport3.jpg