Someone please put me out of my misery!!!
Ok i have a report where i have a group for projects and then inside that group is the interaction types for each project. Each row then has a value called actionid which is the type of action and duration the length. All i want to do is get the average duration first by interaction type, then project, and finally all. The select statement looks as follows:
I thought by putting "= Avg(Fields!TalkTime.Value)" in the footers of my groups would give me the total for those groups but it just totals it for the whole report!!!
All ideas are greatly appreciated!
Ok i have a report where i have a group for projects and then inside that group is the interaction types for each project. Each row then has a value called actionid which is the type of action and duration the length. All i want to do is get the average duration first by interaction type, then project, and finally all. The select statement looks as follows:
Code:
SELECT dbo.historyactions.companyid, dbo.historyactions.actionid, dbo.historyactions.interactiontype, dbo.historyactions.projectid,
dbo.historyactions.duration, dbo.projects.name, (CASE dbo.historyactions.actionid WHEN 70001 THEN Duration ELSE NULL END) AS TalkTime,
(CASE dbo.historyactions.actionid WHEN 90007 THEN Duration ELSE NULL END) AS WrapTime
FROM dbo.historyactions INNER JOIN
dbo.projects ON dbo.historyactions.companyid = dbo.projects.companyid AND dbo.historyactions.projectid = dbo.projects.projectid
WHERE (dbo.historyactions.companyid = 156)
GROUP BY dbo.historyactions.companyid, dbo.historyactions.projectid, dbo.historyactions.interactiontype, dbo.historyactions.duration, dbo.projects.name,
dbo.historyactions.actionid
ORDER BY dbo.historyactions.companyid, dbo.historyactions.projectid, dbo.historyactions.interactiontype, dbo.historyactions.duration, dbo.projects.name,
dbo.historyactions.actionid
I thought by putting "= Avg(Fields!TalkTime.Value)" in the footers of my groups would give me the total for those groups but it just totals it for the whole report!!!
All ideas are greatly appreciated!