Recent content by jobillborf

Thank you for your response. We have another question? how do we calculate the average time for the number of records and show the results in the same format of days, hours, min and seconds. Thanks Jobillborf

Thanks for your help. I tried to find the DLL to download and could not find it. Please help me find the exact location to download the datetimediff DLL. thanks JOBILLBORF

Thanks for the reply. I still need help from someone who knows where on the SAP website I could download the DLL we Need. Thanks jobillborf

Hi, currently using version 9 connected to a microsoft SQL database. We need to down load the following DLL - u2ldtdif.dll it is part of the file UFLDTDIF.exe This file installs a function DateTimeDiff (x,y). The file adds the ability to calculate the difference between to date/time...

Crystal reports 9 connected to sql server In the details section of a report we have a list of completed work orders with completed dates. I would like to extract the newest date and place it in the group header. see example below 11/20/2009 10/11/2009...

Good morning. Here is my problem. Using Crystal V9 Connected to SQL server database. Two tables 1) CUSTPROB table where citizens call in complaints. A service number (SERVNO) is recorded for each Call. When a SERVNO is completed a date is placed in the Resolved DATE (RESDTTM) 2). HISTORY...

Thank you. I forgot to include one thing. Some complaints do not have a link to the logtable link logkey. We would like to include all records that do not have records in the log table. In our database if there is no link to the log table the logkey in the complaint table will have a 1 in the...

Crystal Report Version 9 MICROSOFT SQL SERVER DATABASE. For this problem we have two tables. Table 1 - Complaint table link - logkey table 2 - Log table. link - logkey field question of LogType the tables are linked by logkey. The field in the log table my question is about is logtype. I...

Ver. 2003 I am designing a form in excel and i will like to insert a calendar popup field as well as a text box formated for a time field.

Thank you I will try this out. If possible could you show me how to perform this in a formula. Sincerely jobillborf

Hi, using version 9, oracle data base. I am using two date time parameters. {?START DATE} and {?END DATE} I would like the user to input the dates only and hardocode the times as follows. {?START DATE} TIME 00,00,01 AND {?END DATE} AS TIME 23,59,59 The current select statement is below...

Using version 9 connecting to a oracle database We have a crosstab where there are 18 districts in the columns. If there is no data for the distict the district number does not appear. I would like the district labels for all districts to appear even though there is no data. The districts...

Currently using version 11. the SQL in the report is as follows: SELECT `301data`.`SegmentID`, `301data`.`PC`, `301data`.`PROBDTTM`, `301data`.`RESCODE` FROM `QUEENSJOINFINAL` `301data` WHERE (`301data`.`PC`='SA' OR `301data`.`PC`='SA1') ORDER BY `301data`.`SegmentID`...

Thank you for spending some time on this thread. Its a great feeling knowing we can come to this site and obtain expert help. God Bless, sincerely JOBILLBORF

In access the field type is datetime for both fields even though field one is a date and field two is a time. Hope this helps. Thank you for your time.