Using Parameters in Reporting services 2005

  • 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

  • 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.

  • 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