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?
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?