Search results for query: *

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.

crystal reports version 9 read a access 2003 database I have two fields in access both are Date Time Fields one Water Shut Off date - ex 11/9/1996 two Water Shut Off time - ex 16:50 Is it possible to write a formula or use a function to combine both fields to one date time field...

Hi, I am using version 9 connected to a oracle data base. We have a field called hydtid. I would like to extract all the records that are in this format. J12-1223 In other words the field starts with a letter (J) then 2 digits (12) then a dash (-) then four digits (1223). thank you

hi, I'm a little confused. I tried the first example and it did not work in version 11 it worked in version 9. Where do I place INSTR(UPPER(out_val),'INTERENAL')) and please define (out_val). if I understand right {%MySQLExpression} > 0 would be placed in the select statement. Thank YOu .

database used is oracle. Thanks for your help

Hi, using version 11. I would like to view all records that have the word INTERNAL in upper and/or lower case in a comments field. The word INTERNAL can be anywhere in the comments.