Search results for query: *

Thank you very much!!! Worked perfectly... I apologize for the double post; did not realize I posted under someone elses question.

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

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

I have tried to do as you suggest and I am getting an error message: incorrect syntax near ''' I tried changing a few things to figure out what is causing the error, without any luck. Any ideas? -A

Yes. The IDMaster table holds all the codes / data for ID codes in the database. So rather than have IDMASTER and IDMASTER_1, I have just renamed the tables as such. -A

Not yet, but yes I will. I will probably add both Date Range and IdentityID parameters.

Here you go... SELECT FMTRIPHEADER.CREATIONDATETIME, IDMASTER_Carrier.IDENTITYID, IDMASTER_Consignee.IDENTITYID, FMTRIPDETAIL.DELSTOPNO, --stop FMTRIPHEADER.TRIPNO, --invoice number IDADDRESS.CITY --city FROM (((( FMTRIPHEADER INNER JOIN FMTRIPDETAIL ON...

I am not certain I know how to do what you are suggesting. And I am not sure what you mean by... A.`invoice` = table.`invoice`

LB - Here is the sample you requested Sample data (as seen in the detail section): Invoice City Stop 1234567 Chicago 1 1234567 Oswego 2 1234567 Pontiac 3 (last delivery) 8765432 Booneville 1 8765432 Corinth 2 (last delivery)...

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

Perfect... Thank you!

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

Thanks for the advice but I ended up getting this resolved. First of all I created command (sql) statements, and used the "Add Command" feature in Crystal to set up the various sub-reports. My problem with the date thing, was that I was linking the reports by the "?Pm-?1 -Start_Date". I...

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

So, from what you are saying Union is not what I need here? When I tried to add the second Select statement / query as a subreport and then linked them by the Start and End date parameters, the report made me input the date range twice, once for the main report and once for the subreport. I...

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

Thank you lbass. That did the trick!

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