I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDesktop Data...Paradox & Ob...Paradox for DOS   Print This     
  From the February 2012 Issue of Prestwood eMag
 
Aggregators and their Scope: A Paradox for DOS Perspective
 
Posted 16 years ago on 3/19/2003 and updated 6/9/2008
Take Away: Discussion of aggregators in Paradox for Windows reports as they relate to Paradox for DOS.
 Tags: Paradox , Windows , DOS , reports

KB100176



You may have heard the summary fields in Paradox for Windows referred to as aggregators. This is because there are now new ways to aggregate, or combine, values in fields. Some differences in this area between Paradox for Windows and earlier versions of Paradox include the addition of Standard Deviation, Variance, First, Last, and Previous to the expected Count, Sum, Max, Min, and Average; the ability to place aggregator fields in headers as well as footers; and the addition of Unique as an option alongside the standard Per Group and Overall (more appropriately renamed Normal and Cumulative).

The scoping rules have also changed a little due to the increased power of the report generator and underlying data model. By scoping I mean the scope, or range, of records to include when calculating a summary; in other words, which records should be used when combining, or aggregating, values.

The scoping rules are basically the same as Paradox Dos' report generator in Report footers, Page footers, and Group footers except that placing a summary field in a header will give the same result as its corresponding footer. Anything you would expect to normally work in a footer can also be placed in a header.

In the Record Band (formerly the Table Band or Form Band), the scope of an aggregate on a field in the master table would be the whole table, while the scope of an aggregator on a field in a detail table would be the restricted view (group) for that master record.


Comments

0 Comments.
Share a thought or comment...
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1182A1
Enter key:
KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #100176 Counter
7362
Since 4/2/2008
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,072 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech