Solved

Using Crystal Reports to display a Timespan field

Posted on 2014-04-11
6
298 Views
Last Modified: 2014-11-24
I have a client who is using Crystal Reports 11 to create reports from an MS SQL database.  One of the tables contains some timespan fields, which just display as long integers when dropped onto a crystal report.

How does he (or I) format a timespan in Crystal so that is appears as HH:mm:ss format?
0
Comment
Question by:WestcountryBusiness
  • 2
  • 2
6 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 250 total points
ID: 39994018
check elapsed_time function here .. this could be of help

http://www.cogniza.com/wordpress/2005/11/29/crystal-reports-elapsedtime-function/
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39994066
DO you know what the numbers represent?

If it is the number of seconds the above formulas will work.  If they represent something else then a different formula is required.

mlmcc
0
 
LVL 1

Author Comment

by:WestcountryBusiness
ID: 39994082
Its a timespan field, created in VB.Net, coverted to ticks and saved as a System.Int64, so I think that formula will work.  I'll test it.  Thanks.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40461624
I've requested that this question be closed as follows:

Accepted answer: 250 points for Wasim Akram Shaik's comment #a39994018

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
LVL 1

Author Comment

by:WestcountryBusiness
ID: 40461622
Sorry I completely forgot about this.  Yes, that solution worked.  Happy to close and award points to wasimibm.  Thanks everyone for the help.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now