Millet Software
Home Visual CUT DataLink Viewer CUT Light ActionQ Contact Me

 

OverView Key Benefits Testimonials User Manual Test It Buy it

Key Benefits                                                        Video Demo/Tutorial

bullet Export the report as a whole or Burst each Group Level-1 to a variety of file formats, save the results to dynamically named disk files/folders and include them as attachments to email messages: Video Demo of Bursting and Emailing a Crystal Report

bullet Email a dynamic-content message for the report as a whole or for each Group Level-1.

Messages can be queued to provide faster (or deliberately slower) throughput, resiliency against network outages, archiving, and testing.

Message bodies and options (subject, From, To, attachments, ...) can incorporate dynamic content from fields/formulas in the report (via drag & drop tokens) and can be formatted as HTML.
Insert Emoji into the email subject depending on dynamic conditions: Video Demo Insert Dynamic Emojis into Email Subject Lines
Embed HTML tables with report information inside an email message: Video Demo Advanced Email Options
Auto-Generate HTML Tables to email Report/Group Data: Video Demo of Auto-Generating HTML Tables for Emailing Report/Group Data
Embed the report as image(s) inside the message body: Video Demo Embed Report in Email
bullet

Schedule exporting, emailing, and printing of reports based on parameters and options you specify (and save) during an interactive session. Note: logon information is saved using strong encryption.

A command line interface allows calls from batch files, schedulers (including the free Windows Task Scheduler), desktop shortcuts, or any other program.

Integrated dialogs allow you to: a) Generate a command line, insert into a batch file, and create a scheduled task (see demo image), and b) Manage and monitor scheduled tasks (see demo image). See: Video Demo Scheduling GUI

bullet Email Alerts & Exception Reports by scheduling Crystal reports with an option that aborts processing when the report has zero selected records. This supports BAM (Business Activity Monitoring) functionality by alerting managers to exception conditions related to quality, productivity, inventory, expenses, order processing, accounts receivable, product returns, complaints, delays, budgets, discounts, pricing, etc.

bullet Generate Auto-Refreshing Web Dashboards:  Web Reporting via Visual CUT
see password-protected web dashboard (use demo as user id & password).
see live web dashboard with multi-level drill-down created using the auto-refreshing web dashboard wizard.

bullet Generate Web Grids, Web Pivot Tables/Charts and Web Schedules:
for online data access/analysis via browsers and mobile devices.
See Web Grid example and video demo:
 Export Crystal Report to Interactive Web Grid
See Web Pivot with Saved Layouts example and video demo:
 Web Reporting via Visual CUT
See Web Schedule example.

bullet Document, Find & Replace Text/Expressions, and Update Report Designs
see video demo #1: Search & Update Crystal Reports Designs
see video demo #2 (importing formula definitions from Excel):   Generate and Import Formulas From Excel
see video demo #3 (mass update data sources):   Mass Update Data Sources
see video demo #4 (mass update fonts):   Mass Update Font Names/Sizes
see video demo #5 (re-import subreports):   Re-Import Subreports

bullet Excel Features include:
bullet

Use Excel data to Generate auto-refreshing Web Schedule, Web Grid, or Web Pivot/Charts.
See video demo:video demo of converting Excel data to interactive web schedules, grids, and pivot tables/charts

bullet

Use Excel workbooks to email groups of rows and embed them as HTML tables in the message body: video demo of bursting and emailing Excel data

bullet

Excel bursting exports can generate either a separate excel workbook file for each Group or multiple sheets (tabs) within a single workbook. The process can convert the data to formatted tables with filtering and sorting options: video demo of bursting to excel tabs with formatted tables

bullet

Excel exports can be inserted as tabs in a specified excel file to create briefing books.

bullet

Excel data can be grouped and mail-merged into MS Word templates. The process can populate individual tokens and even tables. The resulting dynamically named files can be converted to PDF and can be emailed to dynamic destinations based on the excel data.
See video demo:video demo of mail-merging excel data into an MS Word template

bullet

Excel exports can be converted to .xlsx files. Multi-tab excel export (due to 65,536 row limitation) can be merged and converted into a single-tab .xlsx file

bullet

Excel exports can automatically refresh excel dashboards with pivot charts, pivot tables, and slicers: video demo of generating excel dashboard

bullet

Excel exports can automatically generate Pivot Tables: Video Demo Generating Excep Pivot Tables

bullet

Excel exports can be password-protected against unauthorized viewing and/or editing.

bullet

Excel exports can be inserted into templates while cloning formats, formulas, icons, and sparklines and applying Table sort/filter options from the template. See sample image.

bullet

Excel files can be manipulated by running macros, fitting column widths, displaying auto filters, freezing panes, setting print properties, transferring tabs, saving as pdf, filling ranges with Crystal formula values or with file exports. See sample image1 & image2.

bullet

Export to Excel tables video demo of bursting a Crystal report to Excel tables with filtering and sorting options

bullet

Upload Excel data to new/existing Google Sheets video demo of uploading Excel data to new/existing Google Sheets

bullet

Data from Excel and CSV files can be bulk loaded (very fast process) to append/replace/update data in SQL Server tables: video demo of bulk loading Excel data to SQL Server

bullet PDF Features include:
bullet

PDF exports can include Color-Coded Bookmarks & Table of Contents for easy online & hardcopy navigation.

bullet

PDF exports can be password protected (128 or 256-bit AES encryption) and restricted (for example, prevent editing).

bullet

Add Digital Signatures.

bullet

Highlight or Redact Text in PDF files: Video Demo PDF Redaction

bullet

PDF files can be Merged to create mixed page layouts, combine & staple output. 

bullet

PDF files can be Split based on bookmarks or based on embedded hidden text formulas

bullet

PDF files can be Split and emailed based on embedded text tokens: Video Demo of splitting and emailing portions of a pdf file based on embedded text tags

bullet

PDF files can be Linearized (web-enabled) for faster opening via web links.

bullet

Export/Burst to BMP, JPEG, WMF, EMF, EPS, PNG, TIF or GIF Image Files (via an option to convert PDF files to image files). 

bullet

PDF Forms can be Filled using Crystal formula values. 

bullet

PDF exports can generate Form Fields, including digital signatures, for user input based on Crystal formulas.  This means that you can use Crystal Reports to design pdf forms, and Visual CUT to generate and distribute these forms.

bullet

PDF files with embedded files and Drill-Down links can be created: Video Demo PDF DrillDowns

bullet

PDF invoices following the ZUGFeRD electronic data exchange standard can be generated.

bullet

PDF files can be Merged to create multiple Layers inside a single pdf file.
Within Acrobat reader, users can then turn the visibility of each layer on or off.
This is particularly useful for map layers. You can control the naming and initial visibility of each layer.

bullet

Add web, email, or file links (hotspots) with optional text to PDF files.

bullet

Add an image with an optional hotspot to PDF files.

bullet

Split the printout of a PDF file to different printer trays.

bullet Other Special Capabilities include:
bullet

MS Word template documents can be filled (mail merged) with Crystal field/formula values and saved/emailed to dynamic destinations. See sample image. Video demo: video demo of mail-merging excel data into an MS Word template

bullet

ODBC Exports can replace or append to existing tables. This provides ETL (Extract, Transform, Load) and scheduled data snapshot functionality.

bullet

Print to multiple printers in a single pass.

bullet

Print Burst so each Group Level-1 becomes a separate print job (useful for separate stapling).

bullet

Split the printout of a PDF file to different printer trays.

bullet

Add dynamic watermarks (e.g. 'Copy 1 of 4') while printing. See sample image.

bullet

Export to multiple file formats in a single pass.

bullet

Text exports or files can be merged into new or existing files.

bullet

Text exports can be embedded in email message bodies.

bullet

FTP/SFTP files to dynamically named web server folders using simple or secure connection.

bullet

Zip and password protect files for secure single-file emailing of report exports.

bullet

Trigger dynamic calls to Web Services (e.g. EzTexting for SMS).

bullet Capture incoming emails into a database and use them to trigger reports and database updates.