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?

[Back to original message]