Using Crystal Reports to display a Timespan field

Posted on 2014-04-11
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?
Question by:WestcountryBusiness
  • 2
  • 2
LVL 16

Accepted Solution

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

Expert Comment

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.


Author Comment

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

Expert Comment

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.

Author Comment

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.

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

707 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

15 Experts available now in Live!

Get 1:1 Help Now