Solved

finding minimum value <> 0

Posted on 2004-08-14
7
400 Views
Last Modified: 2011-08-18
Im sure this is a easy one but i cannot figure it out....

how do I find the minimum value of a field not equal to zero?

Thanks
0
Comment
Question by:cwagner17
  • 4
  • 3
7 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 11800922
You can't use the min() summary because this will return the minimum whether or not it's equal to zero.  Instead you'll have to create a couple of formulas.

In the report header create this formula:

     shared numberVar SmallestFound := 99999;


In the details section create this formula:

     if {table.field} > 0 and {table.field} < shared numberVar SmallestFound then
          shared numberVar SmallestFound := {table.field};

Finally wherever you want to know the smallest value (report footer?) simply create this formula:

     shared numberVar SmallestFound;


HTH

frodoman
0
 
LVL 1

Author Comment

by:cwagner17
ID: 11801063
ok that helped a little bit....

for every incident I track which trucks responded. I want to find out which truck responded first based on time. the time is stored as a number. When i use the above formula it finds all the vehicles and adds the time together. when i view it in the details section it shows each truck.

I don't know why it is showing all of them.

i created a group incapps.idnumber

my tables are as follows:

in5basic.incidentnumber
incapps.alarmtime
incapps.enroutetime
they are linked by in5basic.idnumber--->incapps.reportidnumber

Thanks
0
 
LVL 42

Accepted Solution

by:
frodoman earned 50 total points
ID: 11802609
So what you want is the lowest value within each group, right?  In that case do this:

In the report header create this formula:

     shared numberVar SmallestFound;

In the group header create this formula (just use a value larger than anything you'll see in your report):

     shared numberVar SmallestFound := 99999;

In the details section create this formula:

     if {table.field} > 0 and {table.field} < shared numberVar SmallestFound then shared numberVar SmallestFound := {table.field};

In the group footer put this formula:

    shared numberVar SmallestFound;


You can suppress any of these formula so they aren't visible on the report.

HTH

frodoman
0
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
LVL 1

Author Comment

by:cwagner17
ID: 11802686
Thanks alot, i've been banging my head against the keyboard for awhile on this one.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11805000
Glad I could help.
0
 
LVL 1

Author Comment

by:cwagner17
ID: 11817255
one more thing......

how do i have it ignore the field if there is nothing in it. it seems to be causing a problem if every one doesn't have a time in it.

thanks
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11820055
check for isNull({field}) first...

if not isNull({table.field}) then
(
if {table.field} > 0 and {table.field} < shared numberVar SmallestFound then shared numberVar SmallestFound := {table.field};
)
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 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