Thanks this helped alot. However i made some changes to it for it to work perfectly fine. Is there any other way to have a formulae to give in the final result as such instead to run to formulae and combining it in the text field?
I would ideally like to have the result in date time format?
Thanks for your reply. However, what is the formulae to get the difference between two records? Also i am trying to use this formulae right now {AgentStateDetail.eventDateTime} - previous ({AgentStateDetail.eventDateTime}) but this is giving me the result as 0.00 where as the difference between...
Hi thanks yes i will get in touch with him and check on this. Another question i had was that much before this i was told that the reason i cannot connect to the ACD DB directly was it affects the performance of the ACD system. Is that true?
Hello,
I am trying to subtract records in a table which are in two different rows. It might be an easy one however i cant seem to do it the right way i guess.
Eg: I have a column called EventDateTime which has multiple values in it
EventDateTime
9/19/2012 5:11:07AM
9/19/2012 5:11:55AM...
Hello,
We use Cisco ACD system for our Helpdesk and use Crystal reports 2011 desktop and server to design reports and automate them throught the server. My problem is that i cant connect to the ACD system DB directly and run reports. I know there are some custom build crystal reports in the...
Hello,
I am new to this forum and to crystal reports. I have an issue that i encountered this morning and need to solve as soon as possible as i need to be able to run these reports quickly for the senior management.
I have two DateTime fields: Create_Date and End_Time. My service level...
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.