When i selected a few project at project name parameter,it is just returning project value of first row.Actualy there are more result at my selected date range.

My SP:

USE [ProjectServer_Reporting_Canli]
GO
/****** Object:  StoredProcedure [dbo].[CSP_PCKCS_ProjectResourceAW]    Script Date: 01/22/2014 01:31:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[CSP_PCKCS_ProjectResourceAW]

@ProjectUID VARCHAR(4000),
@DateStart DATETIME,
@DateEnd DATETIME
AS
BEGIN

SELECT
TimeByDay,
ResourceUID,
ResourceName,
ProjectUID,
ProjectName,
ProjectOwnerResourceUID,
ProjectOwnerName,
(CASE WHEN [Function.Fonksiyon] IS NULL THEN 'Bo' else [Function.Fonksiyon] end) AS [Function.Fonksiyon],
(CASE WHEN [programme.program] IS NULL THEN 'Bo' else [programme.program] end) AS [programme.program],
[irket_],
SUM(AssignmentActualWork) AS ActualWork,
SUM(AssignmentWork) AS AssignmentWork
FROM
(SELECT
ABD.TimeByDay,
RUV.ResourceName,
PUV.ProjectUID,
PUV.ProjectOwnerResourceUID,
PUV.ProjectOwnerName,
PUV.ProjectName,
RUV.ResourceUID,
PUV.[Function.Fonksiyon],
PUV.[programme.program],
PUV.PMO AS irket_,
SUM(ABD.AssignmentWork) AS AssignmentWork,
SUM(ABD.AssignmentActualWork) AS AssignmentActualWork
FROM
dbo.MSP_EpmAssignmentByDay_UserView AS ABD
INNER JOIN
dbo.MSP_EpmAssignment_UserView AS AUV
ON
ABD.AssignmentUID = AUV.AssignmentUID
INNER JOIN
dbo.MSP_EpmProject_UserView AS PUV
ON
PUV.ProjectUID = AUV.ProjectUID
INNER JOIN
   dbo.MSP_EpmResource_UserView AS RUV
ON
RUV.ResourceUID = AUV.ResourceUID
INNER JOIN
(SELECT ObjectUID
FROM dbo.CF_SQLParameterINOperatorInStoreProcedure(CONVERT(uniqueidentifier,@ProjectUID))) As ParamProjectUIDs
ON
PUV.ProjectUID = ParamProjectUIDs.ObjectUID
WHERE
((TimeByDay >= @DateStart AND TimeByDay <= @DateEnd))

--AND
--ABD.AssignmentActualWork <> 0
GROUP BY
ABD.TimeByDay,
PUV.ProjectName,
RUV.ResourceUID,
PUV.ProjectUID,
PUV.ProjectOwnerResourceUID,
PUV.ProjectOwnerName,
PUV.[Function.Fonksiyon],
PUV.[programme.program],
PUV.PMO,
RUV.ResourceName) AS Temp
GROUP BY
TimeByDay,
ResourceName,
ResourceUID,
ProjectName,
ProjectOwnerResourceUID,
ProjectOwnerName,
ProjectUID,
[Function.Fonksiyon],
[programme.program],
[irket_]

END
RETURN 0

Hi Erdi,

Did you use matrix in the report to display these data? The issue is due to values in matrix cells display aggregate values scoped to the intersection of the row and column groups to which the cell belongs.

In order to solve your issue, we can add another row group in the matrix to work around the issue. Suppose we have three fields in the dataset: ProjectName, Details, Date. Please refer to the following steps:

1. Add a matrix in the report with following structure:
   Row Group: ProjectName
   Column Group: Date
   Data: Details
2. Add a child row group (Details) based on ProjectName row group.
3. Right click the Details column which add above, select Delete columns only.

Alternatively, we can use table replace matrix to display data to resolve the issue.

If there are any misunderstanding, please elaborate the issue for further investigation.

Regards,
Alisa Tang

Hi Alisa,

Firstly,thank you for see about my issue.

I used to table for my report.after you sent to me that answer,i tried that make this report with matrix.but it gave me same result.There are seven parameter in my report.it has two row group by project name and resource name.there is no column group in my report.when i just selected one project name as parameter,everything is fine.But If i selected more project name,it is just giving result of first selected project name.

My original report design:

Although i marked the select all option,it gave result of first selection named of "Work Station Projesi".Because i know that there are results of other projects in this date range.for example "VERSYON PROJES-TEMMUZ"