Can anyone help with store procedures ?

See more:

SQL-Server

Hi guys
I made this store procedure to create a crystal report

ALTER PROCEDURE [dbo].[Stat]  
@city nvarchar(50),
@company nvarchar(50),
@lastname nvarchar(50)
AS SELECT DISTINCT s.Lastname, s.Firstname, s.Fathername + ' ' + s.Lastname AS Fname, s.Birthday, s.City, s.Phone, s.Cellphone, s.Company, s.Mothername + ' ' + s.Mlname AS Mname, s.ID, s.Cbirth , i.TK , i.Name FROM Staff s INNER JOIN dbo.Settings i on s.StaffID=i.ID 
WHERE (((s.City)=@city) AND ((s.Company)=@company)) AND ((s.Lastname)=@lastname) 
Return

The problem is that the report does not show any data.

Can anyone help please!

Thanks in advance