question

I could use a sanity check please. I am working on a report to display the status of DR testing across the enterprise. When I run the code below in a Query Analyzer it returns 238 rows (which is what I would expect. but when it is run from the Report Server I get a single row. I have tried adding/modifying/deleting GROUP BY statements with no change in the result set. Would someone be able to eyeball this and let me know wht the heck is missing? I appreciate your anticipated assistance and support. SELECT z.ServerName, v.Environment, z.DiskName, z.DskTotalSizeInGB, a.Project, a.Status FROM (SELECT y.ServerName, y.DiskName, y.Label,y.DskTotalSizeInGB,y.DateAdded FROM (SELECT ServerName, MAX(DateAdded) AS Rundate FROM Svr.DiskInfo GROUP BY ServerName) AS x INNER JOIN CentralDB.Svr.DiskInfo AS y ON x.Rundate = y.DateAdded AND x.ServerName = y.ServerName)z INNER JOIN (SELECT ServerName, InstanceName, Environment, [Description], BusinessOwner FROM CentralDB.Svr.ServerList) v ON z.ServerName = v.ServerName JOIN CentralDB.dbo.Disaster_Recovery a ON z.ServerName = a.ServerName WHERE a.Project IN(@Project) AND z.DiskName IN (@DiskName) AND z.ServerName IN (@ServerName) AND v.Environment IN (@Environment) ORDER BY ServerName