Hello Everyone
Sorry but my English is very littel.
In my application I use Crystal Reports. On report I have (in one row) to
dateTime. How in 3th column calculate difftime beetwen this value and
dispaly in format (hh:mm:ss).
Now a use DateDiff functiona but I have wrong format.
Thx for yours help
PawelR 4 2585
Pawel,
You'll have to program a bit using Crystal Reports formula language. First
use DateDiff to obtain the difference between the two dates IN SECONDS, then
use arithmetic formulas in order to obtain the number of days, hours,
minutes and seconds in the difference, and finally build a string in the
format "20 04:15:05" with the temporary variables obtained.
Regards - Octavio
"PawelR" <pa************ @poczta.onet.pl > escribió en el mensaje
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Hello Everyone Sorry but my English is very littel. In my application I use Crystal Reports. On report I have (in one row) to dateTime. How in 3th column calculate difftime beetwen this value and dispaly in format (hh:mm:ss). Now a use DateDiff functiona but I have wrong format.
Thx for yours help PawelR
Thx Octavio,
but I don't quite shure that this is good way. If I use your solution I have
in 3th column string value. If I have string I propabylity can't use
agregate function sum().
Ever rows in first column have start time, second end time and 3th diff
time. On the end my reports I must show total time in job.
Użytkownik "Octavio Hernandez" <do****@danysof t.com> napisał w wiadomo¶ci
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Pawel,
You'll have to program a bit using Crystal Reports formula language. First use DateDiff to obtain the difference between the two dates IN SECONDS, then use arithmetic formulas in order to obtain the number of days, hours, minutes and seconds in the difference, and finally build a string in the format "20 04:15:05" with the temporary variables obtained.
Regards - Octavio
"PawelR" <pa************ @poczta.onet.pl > escribió en el mensaje news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Hello Everyone Sorry but my English is very littel. In my application I use Crystal Reports. On report I have (in one row) to dateTime. How in 3th column calculate difftime beetwen this value and dispaly in format (hh:mm:ss). Now a use DateDiff functiona but I have wrong format.
Thx for yours help PawelR
Pawel,
Make the 3rd column with the difference in seconds, and make it invisible
(Supress). You can sum that column easily. And then at the end of the report
use the formula to present the sum as a string " hh:mm:ss", right below the
4th column, which shows the "hh:mm:ss" for every job..
Regards - Octavio
"PawelR" <pa************ @poczta.onet.pl > escribió en el mensaje
news:eB******** ******@TK2MSFTN GP15.phx.gbl... Thx Octavio, but I don't quite shure that this is good way. If I use your solution I have in 3th column string value. If I have string I propabylity can't use agregate function sum(). Ever rows in first column have start time, second end time and 3th diff time. On the end my reports I must show total time in job.
Użytkownik "Octavio Hernandez" <do****@danysof t.com> napisał w wiadomo¶ci news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Pawel,
You'll have to program a bit using Crystal Reports formula language. First use DateDiff to obtain the difference between the two dates IN SECONDS, then use arithmetic formulas in order to obtain the number of days, hours, minutes and seconds in the difference, and finally build a string in the format "20 04:15:05" with the temporary variables obtained.
Regards - Octavio
"PawelR" <pa************ @poczta.onet.pl > escribió en el mensaje news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Hello Everyone Sorry but my English is very littel. In my application I use Crystal Reports. On report I have (in one row) to dateTime. How in 3th column calculate difftime beetwen this value and dispaly in format (hh:mm:ss). Now a use DateDiff functiona but I have wrong format.
Thx for yours help PawelR
Thx Octavio,
Could you help me? I don't know how present the sum as string "hh:mm:ss".
Pawel
Użytkownik "Octavio Hernandez" <do****@danysof t.com> napisał w wiadomo¶ci
news:OH******** *****@TK2MSFTNG P15.phx.gbl... Pawel,
Make the 3rd column with the difference in seconds, and make it invisible (Supress). You can sum that column easily. And then at the end of the report use the formula to present the sum as a string " hh:mm:ss", right below the 4th column, which shows the "hh:mm:ss" for every job..
Regards - Octavio
"PawelR" <pa************ @poczta.onet.pl > escribió en el mensaje news:eB******** ******@TK2MSFTN GP15.phx.gbl... Thx Octavio, but I don't quite shure that this is good way. If I use your solution I have in 3th column string value. If I have string I propabylity can't use agregate function sum(). Ever rows in first column have start time, second end time and 3th diff time. On the end my reports I must show total time in job.
Użytkownik "Octavio Hernandez" <do****@danysof t.com> napisał w wiadomo¶ci news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Pawel,
You'll have to program a bit using Crystal Reports formula language. First use DateDiff to obtain the difference between the two dates IN SECONDS, then use arithmetic formulas in order to obtain the number of days, hours, minutes and seconds in the difference, and finally build a string in the format "20 04:15:05" with the temporary variables obtained.
Regards - Octavio
"PawelR" <pa************ @poczta.onet.pl > escribió en el mensaje news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Hello Everyone Sorry but my English is very littel. In my application I use Crystal Reports. On report I have (in one row) to dateTime. How in 3th column calculate difftime beetwen this value and dispaly in format (hh:mm:ss). Now a use DateDiff functiona but I have wrong format.
Thx for yours help PawelR
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: NotGiven |
last post by:
Below is a good elapsed time function I found. However, I'd like to return
total seconds instead of broken down into days, hours, minutes & seconds.
In other words, I want "125" instead of "2 minutes 5 seconds".
Any ideas? Thanks very much!
function calcElapsedTime($time)
{ // calculate elapsed time (in seconds!)
$diff = time()-$time;
|
by: Alberto Santini |
last post by:
I ported a Jos Stam's demo about Fluid mech to check
the difference of speed between C implementation and
Python. I think I achieved good results with Python
and there is space to improve, without to extend the
program with C routine, I mean.
--
Good hack,
Alberto Santini
(http://www.albertosantini.it/)
|
by: s-galit |
last post by:
hi,
i have a formula parameter in my crystalReport
how can i initalize the parameter so that in every line in the
crystalReport the parameter will have a different string?
how to get to line in crystalReport?
thanks
thats what i have wrote till now but im getting in my field only "-" (in
every line)
For i = 0 To 9
|
by: Vlatko |
last post by:
I have made a simple application in C# that prints a txt file using
CrystalReport. On my PC everything works fine but when I run my app on
another PC it collapses. I get message: "Cannot find KeycodeV2.dll, or
invalid keycode." What is keycode? I created setup program to install my app
on another computer using VS .NET. I even have copied manually the
KeycodeV2.dll file into WINDOWS/System32 folder so I am sure this file is on
the target...
|
by: redneon |
last post by:
I've populated a DataSet in my C# program and verified that it contains the
data I passed it. I've then created a blank CrystalReport and set it's
DataSource to my DataSet. Then I created a CrystalReportViewer and set it's
ReportSource to my CrystalReport. When I run the program though nothing get's
shown in my viewer. The following is how I did it...
OdbcConnection dbConn = new OdbcConnection();
OdbcCommand dbCommand = new...
| |
by: Don Wash |
last post by:
Hi All!
I've been searching everywhere for a simple sample of producing a bar graph
using CrystalReport by specifying SQL Query, and I've found none of it! I
find so many complex samples with so many features buried in the sample but
all I want to know is a very simple thing, how to create bar charts with
CrystalReport in VS.NET using SQL Query.
Could anyone provide me a sample showing how to produce a simple bar chart
using SQL Query...
|
by: agcabutotan |
last post by:
Hi to everyone.
I am new in this thread, please help me.
I'm having difficulty with CrystalReport.Net. I have a completed project written and compiled in VB.Net (and I used CrystalReport.Net in all of my reports). I used to connect in our SQL server using ADO datasets and It worked. Long after I created a new SQL server (not a member from the original server, a new server so-to-speak), with the same project, I am creating a new report but...
|
by: Jeremy Sanders |
last post by:
Hi - I need to add support to a program for dates and times. The built-in
Python library seems to be okay for many purposes, but what I would like
would be Unix epoch style times (seconds relative to some date), covering a
large period from the past to the future. What would be nice would be a
library which can take floating point seconds from an epoch.
Does anyone know of a library which can convert from human style dates and
times to a...
|
by: Ron Adam |
last post by:
I'm having some cross platform issues with timing loops. It seems
time.time is better for some computers/platforms and time.clock others, but
it's not always clear which, so I came up with the following to try to
determine which.
import time
# Determine if time.time is better than time.clock
# The one with better resolution should be lower.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |