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
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.