Search results for query: *

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

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.

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

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

Hi, I am using version nine. I have the following formula and would like the result to be a percent. {#0-5}/Count ({@BACKLOG TIME}, {CUSTPROB.RESP}) This formula is in the group footer. Thank you for your help

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

HI, I have a standard report which I would like to count each record that has a null value in the LASTNAME field. This report is grouped by company name. The report has a count of the total records in the group. Thanks for your help

Hi I have a crosstab that was created using the crosstab wizard in version 9. Is it possible to suppress the crosstab values that are zero. Thank You

Hi, I have a text field in my database formated "32 . 32" I would like to remove the space, period and space and have the result "3232" Can someone help me Thank you for your help in advance.

I would like the difference to be the total number of days with a decimal point. In my report I am using this formula datediff("d",{CUSTPROB.PROBDTTM},{CUSTPROB.RESDTTM}); It returns a whole number with out the partial hours. For example instead of 10.00 days the result should be...

Hi, I have two date time fields 1) problem_date 01/03/04 07:15 am 2) resolved_date 01/04/04 09:30 am I would like the difference to be the total number of hours the remainder not in minutes but with a decimal point. In this example the result would be 26.25 hours .25 represent 15 minutes...

Hi. I have a database with a numberic field. I would like to only extract the numbers before the decimal point. For example 7.15 would be .15 Thank you for your help

elapsed time in minutes. I have two datetime fields one startdate the other enddate. What would be the formula for the amount of time in minutes. elapsed time in hours and minutes. and elapsed time in days, hours and minutes. thank you