How to calculate # of occurrance days in Report Builder

Posted on 2006-04-26
Medium Priority
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

Eddie Shipman earned 2000 total points
ID: 16554604
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

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

809 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