Search results for query: *

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

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

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

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

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

I am trying to export a report into a Tab separated format, but I do not want the double quotes around the text. I had this fixed once with a registry edit change, but I now have a new PC with a clean version of Crystal 11 installed. Does anyone know of a way to create the tab separated export...

I am having trouble summing a summed group. Group 1 is based on a Reading Route, Group 2 is based on the Meter Number, The Detail section has the Meter Readings for the Group 2 Meter Number. The GF2 sum is working fine, but I also would like to sum all of the GF2's in GF1. The answer I get in...

I have report grouped by ID number and pulled in a date range of data into the detail section of the report. Below is an example of the data: {date} and {reading} 9/01/2011 18900 9/02/2011 18991 9/03/2011 19025 and so on until--- 9/30/2011 20528 10/1/2011 20575 I would like to...

I have a report that has colored fields and when I print the report, it prints in gray scale, adn yes I am printing on a color printer. Thanks.

I have field called [LOCATION] that varies in length. I need to remove any alpha characters at the end, if there are any. Listed are some examples. [LOCATION] [NEEDED] PA 109S 55W 2N 1A PA 109S 55W 2N 1 WC 155A WC 155 PB4 68N 1UNH PB4 68N 1 B 3E 1P...

I need help with trying to use a RIGHT or TRIM function in a QUERY. I have a a LOCATION field with utility pole numbers on them and I want to remove the letters on the right back to the first space. Here are some examples of the data. [LOCATION] [NEEDED] PA 109S 55W 2N 1A PA...

I have a database where the date is a text string. [Date] [Would like it to be] 112904 11/29/2004 91807 09/18/2007 12206 01/22/2006 101305 10/13/2005 1/15/98 01/15/1998 I am trying to do this in a query. Thanks!

I have a table that has 2 fields Account Number and Extension. I am trying to make a query to give me the account number with the largest Extension number. [Account Number] [Extension] 1 15 1 18 1 55 1 76...

I want to do a report on a database that records company internet use. The URL field has the comlete link like.. http://www.msn.com/ http://www.msn.com/picture/tree.1278 http://www/yahoo/com/music/thirdday.1233 And so on. I only want to display the web site in my report like...

I import a date that is 104 that represents January 2004.A 204 would be February 2004 and so on to 1204 for December 2004. Is there a way to convert the 104 to display as 01/04 up to 1204 to display as 12/04? Thanks!

I import a date field from outr billing system that seems to be in a format that Excel cannot convert. From our system a January 2004 date looks like 104. A December 2003 date looks like 1203. Is there a way to get 104 to look like 01/2004 and 1203 to look like 12/03 in Excel? Thanks!