Defining Parameters

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jayphi

    Defining Parameters

    Hello- I need help, badly! I'm trying to define parameters that
    within my first Reporting Services project.

    SELECT DISTINCT
    dbo._ProjectPos itionViewStaff. OwnerPool,
    dbo._ProjectPos itionViewStaff. ProjectName,
    CASE WHEN dbo._ProjectPos itionViewStaff. Status
    = '1' THEN 'Active' WHEN dbo._ProjectPos itionViewStaff. Status = '0'
    THEN 'Prospective' END AS EPM_Status,
    dbo._ProjectPos itionViewStaff. Status,
    dbo.PROJECTTASK .sdr_StartDate AS [Start Date],
    dbo.PROJECTTASK .sdr_EndDate AS [End Date],
    dbo._ProjectPos itionViewStaff. valueValue AS
    Value
    FROM dbo._ProjectVie w INNER JOIN
    dbo._ProjectPos itionViewStaff ON
    dbo._ProjectVie w.ProjectName =
    dbo._ProjectPos itionViewStaff. ProjectName INNER JOIN
    dbo.PROJECTTASK ON
    dbo._ProjectPos itionViewStaff. ProjectOID = dbo.PROJECTTASK .projectOID
    WHERE (dbo._ProjectPo sitionViewStaff .Status = '1') OR
    (dbo._ProjectPo sitionViewStaff .Status = '0')

    What i would like to to is to add a parameter that would sort the
    projects by the project pool chosen. I'm at a loss can anyone point
    me in the right direction?

Working...