Report Parameters

hi there

I am using Reporting Services 2005.

I have 3 report parameters: startdate, enddate, callstatus

My problem is that once I added callstatus to the parameter list my dates were ignored?

What do I need to do to correct it?


My select code is as below:

SELECT Ticket.TicketNumber, Application.ApplicationName, Status.StatusName, Ticket.LastModifiedBy, CONVERT(datetime, Ticket.CreatedDate),
Company.CompanyName
FROM Ticket INNER JOIN
Application ON Ticket.ApplicationID = Application.ApplicationID INNER JOIN
Status ON Ticket.StatusID = Status.StatusID INNER JOIN
Company ON Application.CompanyID = Company.CompanyID
WHERE (CONVERT(datetime, Ticket.CreatedDate) >= @StartDate) AND (CONVERT(datetime, Ticket.CreatedDate) <= @EndDate) AND
(Status.StatusName IN (@CallStatus)) OR
('SELECT ALL' IN (@CallStatus))

My report Parameters have the values listed in the Non-queried part on report parameters

thanks
Dianne