September 3, 2012 at 8:22 am
Hi ,
i am trying to generate a report based on resource name. I have already added the @Res in my where clause and then in report parameters i am defining Res as string,multi value and available values i select from query and add ResourceName as value and Label field and select my dataset. Still i am having an error that report parameter Res has a default or valid value that depends on the report parameter Res. Forward dependencies are not valid.
PLEASE HELP... SEE MY QUERY BELOW IF NEEDED. Thanks
SELECT
epmr.ResourceName,
epmp.ProjectName,
epmad.AssignmentWork,
epma.AssignmentStartDate,
epma.AssignmentFinishDate,
epmad.TimeByDay,
--added for week display
convert(varchar(10),DATEADD(d,8 - DATEPART(dw, epmad.TimeByDay), epmad.TimeByDay),101) as [Week Ending],
DATENAME(m,epmad.TimeByDay) as [Month]
FROM
MSP_EpmAssignmentByDay_UserView epmad,
MSP_EpmAssignment_UserView epma,
MSP_EpmProject_UserView epmp,
MSP_EpmResource_UserView epmr,
MSP_EpmTask_UserView epmt
WHERE
epma.AssignmentUid = epmad.AssignmentUID
AND
epmp.ProjectUID = epma.ProjectUID
AND
epmr.ResourceUID = epma.ResourceUID
AND
epmt.TaskUID = epma.TaskUID
AND
epmad.TimeByDay BETWEEN (@Start_Date) AND (@End_Date)
AND
epmr.ResourceName = @Res
ORDER BY
epmr.ResourceName
September 3, 2012 at 8:38 am
Is the query used to populate the the available / default values for the @Res parameter?
If not please provide the query which is used to populate @Res.
September 4, 2012 at 12:09 am
Hi Anthony,
i have been able to perform the operation. I added a sub query where it retrieves all data from Resource table and i have used it in the where clause of my main query.
Thanks for your reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply