Search results for query: *

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...

I had a similar issue with a Crystal Report viewer software, and the problem ended up being the name of the report was too many characters and I had a period in the name. Example: Report_Name_v.1 Not sure this will help you or not.

Except the formula field {@f_PresRd_kWhT}+{@f_G3Footer} is not an option to select in the Running Total Fields list. I even created a separate field that looks at the formula field {@f_PresRd_kWhT}+{@f_G3Footer} and it is not in the Running Total Fields list either.

I am trying to sum grouped values to no avail. I've searched the threads for the answer, but I am missing something. Please advise. Group 2 Header: whileprintingrecords; numbervar G4Total; if not inrepeatedgroupheader then G4Total := 0; Group 4 Footer: numbervar G4Total; numbervar G4Total :=...

I have a report that has as a group {customer_number} and each account that is associated with the customer number is in the detail section. What do i need to do to count the number of customer numbers, and not the details? I have searched the posts and cannot find anything??? Thanks.

I am trying to sum two charge amounts that are grouped by their charge code in a report. Group Header 2 is for the Account Group Header 3 is for the Charge Codes In GH3, the charge for Charge Code 71 and the charge for Charge Code 11 are displaying properly, but I want to sum Charge Code 71...