Recent content by mmck1964

Thanks. That was it too.

I did not know the ISNULL must be checked first, but that did not work. Is it because the AND statement is from two different tables?

Below is the formula I have in the Record Selection Formula Editor based on a date range. (({AP_VEND_PMT_ACT.AP_PMT_TYPE_CD} = "D") and ({AP_PMT_DTL_VIEW.AP_TRAN_TYPE_CD} = "I")) or ((IsNull({AP_VEND_PMT_ACT.AP_PMT_TYPE_CD}) and ({AP_PMT_DTL_VIEW.AP_TRAN_TYPE_CD}) = "M")) If I use either...

THANK YOU!!! [medal]

I have a shared date variable from a subreport that I am trying to use in a Running Total Fields Evaluate formula. The shared datevar is displaying on the main report fine, but I just cannot figure out how to make it work in the Running Total Fields Evaluate formula. Please advise. Thanks

Thank you!!!

New to the MITEL System. We have a Mitel 3300 and using ACD Express for 10 agents. Also using MCD 6.0 SP1. Is there a way to report on the use of the Make Busy Button for the ACD agents within the MCD? Or, is there another reporting software package available, other that PrairieFyr? I...

I think this is close because I see both "CC" and "XX in the detail section, but I always return the address for address type "XX" in the group footer. Also, I did add WhilePrintingRecords in each formula.

I can see how that would be an option, but I really would like to make the correct choice based in the address_type field.

I hope the subject line helps with my problem. I have a report where I have grouped by customer number. Some customers have multiple address depending on the addresses specific use. Every customer has an address where {address_type}="XX". Not every customer has an address where...

Worked perfectly! Thank you!

I have a report that is grouped by Account_Number. I am trying to return the date for each account when the account balance goes from a credit to a debit amount. It could vary from account to account, or even never. In the example data below, which is in the detail section for the account, I...

Actually all I want to return in the detail section is the year with a negative value and the negative value and the previous year and its value. Below is what I would like to return based on the example: 1983 5.22 1982 -1.05

Sorry the example did not display as I had typed. Below is what I entered based on the reply: GH1 is grouped by Account I added and suppressed {f_Eval} which has: WhilePrintingRecords; Global Booleanvar Year; If sum({CC_PY_BY_TYPE.CC_UNRET_AMT}, {CC_PY_BY_TYPE.CC_YR}) < 0 then year:=true GH2...

I have a report grouped by account number and I am trying to return any years with an amount value less than zero, and return the previous year and value. I can get the the year and value less than zero, but I need help in bringing back the year prior to the year with the negative value and the...