Search results for query: *

Average datediff for Report Footer: Crystal XI SQL 2005 I am running into a roadblock trying to calculate the average datediff in the report footer. And am hoping for some assistance to do so. I am successful calculating the average datediff in Group Footer 1 using the following.... I am...

Crystal XI and SQL I need my report to only look at the data for all active employees between their "original hire date" and "original hire date plus 90 days". The user should not be prompted for any parameters. I have made several unsuccessful attempts.... Any suggestions? I prefer to...

Crystal XI - SQL 2005 I have several hundred invoice records and under each invoice record is a listing of deliveries in numerical order (1,2,3,etc). I need to pull the last delivery for each invoice, but ultimately I need to sort the report by delivery location (city). The final result is to...

Crystal XI I need to calculate hours past midnight on Friday. Normally I just do a DateDiff formula. My question is, do you know of a way to 'hard-code' midnight into a formula? Usually I would do something like this... if dayofweek ({Dispatch.ACTUALFINISH}) > 5 and {Dispatch.Consignee_ID}...

I am using Crystal XI and working with a SQL database. I have one report that includes 4 subreports. The report's purpose is to be a "snapshot" of production. The reason for the many subreports is because I am pulling data from different transaction types (i.e. Receipts, Shipments...

I am using Crystal XI and am trying to redo a report by writing a SQL statement and using the Command feature. I am fairly new to doing this. The biggest problem I am having is when I am trying to re-work reports that have several sub-reports within the main. The reason I have so many...

I am working with Crystal XI. I have a main report which pulls Shipment data. I have a subreport, which main purpose is to pull from the Receipt data the date/time of arrival. The subreport is linked by a keysequence field. (The subreport contains the Receipt date/time and the Keysequence...

Crystal XI I am trying to calculate an average time. I am sharing a datetimevar from a subreport to the main, called {@MainYardDate}: WhilePrintingRecords; Shared DateTimeVar SubYardDate ; SubYardDate Using the shared variable, I have created the following formula to calculate the datediff...

Crystal XI Data Entry Process Times Report I have created a data entry process times report that is grouped by day ,by shift, and then by transaction #. There are two types of record actions: 1. An "Inserted" (I) record 2. An "Updated" (U) record These actions are tied to the User ID. All...

Crystal XI I have a string field that returns a result of ######-##. (i.e.: 123456-06) I need a formula to suppress the '-06' and return a result of only '123456'. I then need another formula to suppress the '123456', and return a vaule of '-06'. Any help would be very much appreciated. This...

I have created a delivery manifest report in Crystal XI. I have a range parameter selection of bill of lading number to allow the user to print multiple bills of lading. For instance bol #'s 101720 through 101723. For each bill of lading there is detail. When the range values are inputted...

I am using Crystal XI. I have the following table set up... PH Carrier Quantity Add/Subtract NewTotal GH1 ALVP 200 (100) 100 GH1 RDWY 100 0 100 I need to use the the "Add/Subtract" value (100) from the ALVP row and add this to the RDWY...

Hi! I am working with Crystal IX and am working with the following formula.... NumberVar nbrTime := {@test}; NumberVar nbrHour := Truncate(nbrTime); NumberVar nbrHold := (nbrTime-nbrHour)*100; nbrHold := (60*nbrHold)/100; NumberVar nbrMinute := Truncate(nbrHold); nbrHold:=...