I am using Crystal Reports XI and am having trouble totaling part of a table column.
My parameters are:
{?Calendar_Year} and {?Calendar_Qtr}
My Record Selection Crteria is:
{FEE_STATUS} = "PAID" and
{FEE_TYPE} in ["TS", "PL", "ME", "FS", "FM", "EL", "BM", "BU"]
I am trying to get the:
SUM({FEE__DUE_AMT})
WHERE {FEE_TYPE} in ("TS","PL","ME","FM","EL","BM","BU")
Notice that is all but one of the items in my Record Selection Criteria, but no mater what I write in my formulas using the SUM ({FEE_DUE_AMT}) it still gives me the SUM including "FS" FEE_TYPE.
I can not figure out how I can not get the same information using Crystal as I can writing a plwn SQL statement.
Can someone please help? Thanks.
My parameters are:
{?Calendar_Year} and {?Calendar_Qtr}
My Record Selection Crteria is:
{FEE_STATUS} = "PAID" and
{FEE_TYPE} in ["TS", "PL", "ME", "FS", "FM", "EL", "BM", "BU"]
I am trying to get the:
SUM({FEE__DUE_AMT})
WHERE {FEE_TYPE} in ("TS","PL","ME","FM","EL","BM","BU")
Notice that is all but one of the items in my Record Selection Criteria, but no mater what I write in my formulas using the SUM ({FEE_DUE_AMT}) it still gives me the SUM including "FS" FEE_TYPE.
I can not figure out how I can not get the same information using Crystal as I can writing a plwn SQL statement.
Can someone please help? Thanks.