I have several databases with the store procedure identified below. When I connect to all but one I get the value for the gross field, but in one of the location I get zeros for the gross field in Crystal Report. Can anyone shed some light?
ALTER PROCEDURE [dbo].[USP_CorporateDealsPaidByMember]
SELECT C.Employer, C.Old_Contract_Id, C.First_Name, C.Last_Name,
C.Monthly_Dues, MS.Status, C.Date, Option_Name, ISNULL(C.Initiation,0) + (ISNULL(C.Term, 0) * ISNULL(C.Monthly_Dues,0)) AS Gross
FROM Customers AS C JOIN
Member_Status AS MS ON MS.Status_Id = C.Status
WHERE (Option_Name LIKE '%20[%]%' OR Option_Name LIKE '%30[%]%' ) AND
Debit_Method <> 'PDC' AND
C.Date BETWEEN @sDate AND @eDate AND
C.Employer <> ''