Monarch for(ez-pickins logo)ez-pickinsFeatures

Next Steps
Download a Free Trial
Talk to a Product Specialist:
 630-986-0800
Schedule a Live Web Demo
Features
Get Technical Support
 
Product Info
Monarch for EZ-Pickin's
New Features (v10.5)
Version Comparison Table
Getting Started
How It Works
Product Sheet Opens new window
Print Ad Opens new window
Interactive Presentation Opens new window
Proven Software
Case Study
Support
Knowledge Base
Documentation
System Requirements
Feature Request
Technical Support Home

Tech Blog
Feedback
Web Application Development
Report & Document Distribution
Portals & ECM
Business Intelligence
 

New Features Version 7

Experience the new power of EZ-Pickin's V7.

Improved Performance!

EZ-Pickin's V7 now works with huge report files, even larger than 2 GB. Plus, EZ-Pickin's V7's maximum data capacity has more than doubled. Reports that once took several boxes of paper to print are now no match for EZ-Pickin's V7.

NEW Export Wizard

Export all filters and/or all summaries to Excel, Access, etc., at one time. With EZ-Pickin's V7, you can export EZ-Pickin's Table Data, selecting one or all data filters from your model, plus a sort if you wish. Or, choose to export one or all EZ-Pickin's Summary views from your model, with your choice of one or all filters. You can then choose to export your data as separate files in one folder, or as multiple tables within one file. If you have ever struggled to export multiple EZ-Pickin's tables or summaries, EZ-Pickin's V7's new Export Wizard is for you.

NEW Calculated Field Functions

EZ-Pickin's V7 is loaded with 18 new and improved calculated field functions that our users have been asking for - including new Julian dates functions. Take advantage of these new functions to manipulate text, dates and numeric values quickly and easily. Now more than, you can transform your reports to the exact data you with EZ-Pickin's.

Function Name Description
Strip Strips out all instances of one or more characters from a text string
JulianTo Date Converts Julian date string to a date
DateToJulian Converts a date to Julian date string
Hour Returns Hour from a date/time field
Minute Returns Minute from a date/time field
Second Returns Second from a date/time field
Time Returns Time from a date/time field, or can display current time
DayofYear Returns day number (1-366) of date
Ceiling Rounds up a number to nearest multiple of a number of your choice
Floor Rounds down a number to nearest multiple of a number of your choice
Mround Rounds number to nearest multiple of a number of your choice
Proper Forces each word of text string to Proper Case
IsBlank Returns 1 if text string is blank or has only spaces; otherwise, returns 0
Stuff Replaces selected text in a text string with new text of your choice
Ctod Improved: Converts a date/time text string to a date; can now convert the date and/or the time
Str Improved: Converts a number to text; can now "fill" empty spaces to left with a character (i.e., can now convert the number 123 to "000123"
Min Improved: Now computes the minimum of up to four values (previously only two values)
Max Improved: Now computes the maximum of up to four values (previously only two values)

Now Capture Data in Multi-Column Reports

EZ-Pickin's V7 makes it easy to work with all data in multi-column reports, such as name and address lists, customer statements, etc. No need for multiple EZ-Pickin's sessions and different EZ-Pickin's model files to extract one column of report data at a time. It's now a simple, single-session process in EZ-Pickin's V7.

NEW Interactive Report View and Verify

EZ-Pickin's V7's many improvements to the Report View include the new Automatic Preview.as soon as you define a trap, all report lines with that trap display immediately. Define a data field, all fields appear highlighted in the report immediately. See the results of your model interactively, as you build it, with EZ-Pickin's V7.

EZ-Pickin's V7's NEW interactive improvements to the Verify feature make it easier than ever to ensure your model properly captures all of your data. EZ-Pickin's V7 makes the process of model building faster, easier and more accurate than ever.

  • As soon as you enter your trap, EZ-Pickin's immediately highlights all report lines captured by your trap! Then, as soon as you define a data field, EZ-Pickin's immediately highlights all occurrences of that data field within the report.
  • New description of each potential trapping error.
  • Verify now reports non-blank characters to the left or right of a data field separately. Also detects errors based on data type-if a numeric field or date field cannot be converted to a valid value.
  • When using + or - buttons to widen or narrow field width, the data field not appears immediately adjusted on report.
  • NEW Ignore All button will suppress all subsequent Verify errors of the type just reported.

Create Your Own Summary Measures

EZ-Pickin's V7 lets you perform a wide variety of new calculations on summarized EZ-Pickin's data.

EZ-Pickin's V7 lets you create your own summary-level measures, using a wide variety of new Summary Aggregations, plus arithmetic operators, parentheses and numeric values - great for "What-If" analysis, or to produce whatever summarized data fits your unique needs. Simply define your own Summary Measures in EZ-Pickin's V7, save your model file, and you're done. It's that easy!

  • EZ-Pickin's NEW Summary Aggregations include Count Percent of Total and Count Percent of Subtotal
  • Percent of Subtotal
  • Unique value (returns unique value of a summary data field if it is made up of only one value from the EZ-Pickin's Table, otherwise returns null)

Duplicate Value Filtering

Auditors and accountants are sure to love EZ-Pickin's V7 new Advanced Filter feature, designed specifically to work with duplicate values. Use EZ-Pickin's V7 to easily mine duplicate payment amounts from check register reports, duplicate transactions from general journals, and much more. Alternatively, you can identify data for which no duplicates exist. EZ-Pickin's V7's new Advanced Filter makes duplicate searching a fast, programming-free process.

View All EZ-Pickin's and Model Project Information

Load a model and/or project in EZ-Pickin's V7, and use this feature to see all information contained in the model and/or project in one easy view. If you have ever struggled over how to document your EZ-Pickin's model, or if you ever forgot the purpose of an old EZ-Pickin's model, you're sure to enjoy this new feature.

 


e-Server - iSeries edition Magazine Honor Roll Award and Showcase Product Excellence Award Winner

<< Back to EZ-Pickin's Features Main Page