Solved

Group Footer Variable

Posted on 2011-09-09
2
238 Views
Last Modified: 2012-08-14
OK Now I return the scrap amount in my details section. I need to return that total amount of scrap time in my group footer equation.

How can I just pass the value of my details running total to my footer?
0
Comment
Question by:cmdolcet
2 Comments
 

Accepted Solution

by:
cmdolcet earned 0 total points
ID: 36510366
Never mind I figured out my issue


Shared NumberVar scrapped_Time;
numberVar dur := scrapped_Time;
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs,"0") + ":" + totext(min,"00") + ":"+ totext(sec,"00");
0
 
LVL 34

Expert Comment

by:James0628
ID: 36515932
As you figured out, you just needed to use the scrapped_Time variable.  FWIW, you don't need the dur or hhmmss variables in that formula.  You could just use scrapped_time instead of dur, and you don't need to put the final string in a variable unless you want to use that string somewhere else.  So, you could have:

Shared NumberVar scrapped_Time;
numberVar hrs;
numberVar min;
numberVar sec;

hrs := Truncate(Truncate(scrapped_Time/60)/60);
min := Remainder(Truncate(scrapped_Time/60),60);
sec := Remainder(scrapped_Time,60);

totext(hrs,"0") + ":" + totext(min,"00") + ":"+ totext(sec,"00")


 And if you really want to cut down the formula as much as possible, you could eliminate all of the variables except for scrapped_Time:

Shared NumberVar scrapped_Time;

totext (Truncate (Truncate (scrapped_Time / 60) / 60), "0") + ":" +
 totext (Remainder (Truncate (scrapped_Time / 60), 60), "00") + ":"+
 totext (Remainder (scrapped_Time, 60), "00")


 As far as performance goes, I don't think it makes any difference which formula you use.  It's all about which version you (or anyone else that might look at this report) find easiest to read.  I was just presenting some alternatives, FYI.

 James
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

930 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

10 Experts available now in Live!

Get 1:1 Help Now