phone: (540)338-0194
email: ken@kenhamady.com

The Crystal Reports Underground News:


Report Miner

Archive for years 2018 and later
Archive for years 2010 - 2017 (48 issues)
Archive for years 2005 - 2009 (34 issues)
Archive for years 2001 - 2004 (38 issues)

"I've been reading your posts for years, and feel I owe you a debt of gratitude because I would not be nearly as skilled a Crystal developer as I am without the benefit of your willingness to share your vast experience."
Jennifer C. - Springfield, MO. 

 Archives for years 2018 and later:

Volume 2019.11
  • Crystal Reports formula function libraries (2019)
  • Creating a "Distinct Sum" when the duplicates not grouped together
  • No column headings on the last page (v2.0)
  • Correction to "elapsed time string" formula
  • Table filters in the database expert
  • Converting an Excel column from Characters to Numbers
  • Literal values that include quotes
  • Crystal crashes with no error message
  • Gems from the Archives
Volume 2019.09 Volume 2019.07
  • RPT management utilities for 2019
  • Preventing the "division by zero" error
  • How to make sure you are on the last day of the month
  • How to reorder tables to improve performance
  • Finding groups where the last record meets a criteria
  • Moving cross-tab numbers to Excel
  • SQL Syntax for several common date ranges
  • The last resort when you need an extra pass
  • Gems from the Archives
Volume 2019.05

Volume 2019.03
  • Comparison of desktop-based schedulers (2019 update)
  • Applying a formatting condition to multiple fields
  • Add an address block without blank lines
  • A simpler approach to address blocks
  • How link direction can affect performance
  • Another option for selecting ALL in a parameter
  • Carriage returns in a formula that will survive a text export
  • Windows update breaks Raiser's Edge reports
  • Gems from the Archives
Volume 2019.01
  • Web based deployment options compared (2019)
  • Connecting to QuickBooks data from Crystal Reports
  • Setting section height to a specific number
  • Using an asterisk for ALL in a parameter
  • Downloading the Xtreme sample data
  • Minor changes can have a major impact on performance
  • Better SQL for showing the last record
  • Even Better SQL for showing the last record
  • Gems from the Archives   
Volume 2018.11
  • Crystal Reports formula function libraries (2018)
  • New functions in Cut Light
  • Selecting ALL with a parameter field
  • SQL Server dates show up as strings
  • Setting default export options for a report
  • Improving report performance with a subreport?
  • Date formulas in Accpac without pwFormatDate()
  • Flaw in XML Exports
  • Gems from the Archives   
Volume 2018.09
  • Updated comparison of Crystal Reports viewers (2018)
  • Service Pack 3 for Crystal Reports 2016
  • Crystal Reports versions over time (2018)
  • Crystal Reports FAQ on the SAP website
  • Selection based on two different records in the same group
  • A temporary formula change that expires automatically
  • Why is the group tree ODD sometimes?
  • Numbers that touch operator words
  • Gems from the Archives:

Volume 2018.07
Volume 2018.05
  • Server-based scheduler comparison (2018)
  • Formula to group into 2-month periods.
  • Adding static and dynamic images to Crystal Reports.
  • Listing all formula changes with Notepad++
  • Column headings for cross-tabs
  • Using a "display string" turns off HTML interpretation
  • No current Crystal Reports certifications
  • New SQL Server OLEDB provider supports TLS 1.2
  • Gems from the Archives:

Volume 2018.03
  • Comparison of desktop-based schedulers (2018 update)
  • Lasso multiple objects without selecting lines and boxes.
  • Using "Order Links" to improve performance
  • Adding info to dynamic parameters
  • Printing "group continues on next page"
  • Trouble with the suppress condition for a line
  • Blocking drill-down based on a condition
  • Titles for Cross-tabs that spill onto horizontal pages
  • Gems from the Archives

Volume 2018.01