How to calculate # of occurrance days in Report Builder

Posted on 2006-04-26
Last Modified: 2010-04-05
I am using Digital Metaphors' Report Builder for calculating equipment downtime.  I would like to count the number of days that a particular machine had downtime occurences.  I have the report set up to list the work order, the date of the downtime, the hours, and the reason.  It summarizes by totalling the # of work orders and the # of hours for each machine.  All I need now is to summarize the number of days that had downtime occurences for a particular machine.  I am not a programmer, but I am usually good at following instructions!  Anyone out there that can help me?
Question by:pattihill
    LVL 26

    Accepted Solution

    Just create a new query and use the data returned from it to populate a DBText.

    SELECT       count(distinct downdate)
    FROM       downtime
    WHERE      machineno = :MachineNo


    Author Comment

    Thanks, Eddie!  Makes sense; I'll give that a shot!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
    Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    733 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

    19 Experts available now in Live!

    Get 1:1 Help Now