Formatting a crosstab summary from seconds to MM:SS

Posted on 2009-02-20
Last Modified: 2012-05-06
I have a crosstab set up based on a formula that determines the number of seconds between two dates, and then finds the median. It works correctly using the seconds value.

Cross-Tab Summarized Fields:
Median of @DateDiffSeconds

However, I would like it to display in MM:SS format.

If I use the formula to create a CTime, Median isn't an allowed summary type.

I can't find a way to change the way it's displayed based on the calculations. (Like Group names, having a formula for calculating as well as a seperate one for displaying.)
Question by:jb25
    LVL 10

    Accepted Solution

    Right click on your summary field in the cross tab.
    Select Format Field.
    Click on the formula icon next to Display String on the Common Tab.

    Insert the following Formula:

    numbervar hours := Truncate(CurrentFieldValue/60);

    numbervar seconds := remainder(CurrentFieldValue, 60);


    Author Closing Comment

    Worked perfectly. I didn't realize that there was an option to change the display string under Format Field.

    Thank you.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    732 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

    20 Experts available now in Live!

    Get 1:1 Help Now