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 :
Group_Member_Name, Cast(Group_Member_Status As nvarchar(250)) as
Group_Member_Status, Group_Member_Availability From ( SELECT
AS Group_Name, Containers_AlertsAndReportsData.GroupMemberName AS
(Containers_AlertsAndReportsData.GroupName LIKE '%Tier-1-Windows%')
) As r ORDER BY 1 ASC, 2 ASC