|
|
Posted by Jayphi on 11/09/07 13:10
Hello- I need help, badly! I'm trying to define parameters that
within my first Reporting Services project.
SELECT DISTINCT
dbo._ProjectPositionViewStaff.OwnerPool,
dbo._ProjectPositionViewStaff.ProjectName,
CASE WHEN dbo._ProjectPositionViewStaff.Status
= '1' THEN 'Active' WHEN dbo._ProjectPositionViewStaff.Status = '0'
THEN 'Prospective' END AS EPM_Status,
dbo._ProjectPositionViewStaff.Status,
dbo.PROJECTTASK.sdr_StartDate AS [Start Date],
dbo.PROJECTTASK.sdr_EndDate AS [End Date],
dbo._ProjectPositionViewStaff.valueValue AS
Value
FROM dbo._ProjectView INNER JOIN
dbo._ProjectPositionViewStaff ON
dbo._ProjectView.ProjectName =
dbo._ProjectPositionViewStaff.ProjectName INNER JOIN
dbo.PROJECTTASK ON
dbo._ProjectPositionViewStaff.ProjectOID = dbo.PROJECTTASK.projectOID
WHERE (dbo._ProjectPositionViewStaff.Status = '1') OR
(dbo._ProjectPositionViewStaff.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?
Navigation:
[Reply to this message]
|