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

The Crystal Reports Underground News:


Individual Instruction by Ken Hamady

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 2021.09
  • Comparison of Crystal Reports viewers (2021)
  • My Crystal Reports Expert Series released as free downloads
  • Adding an “All” option to a dynamic parameter
  • Hot-swapping fields
  • “Column mode” in the Crystal formula editor
  • Matching colors in your reports
  • Using reserved characters in formula names
  • Gems from the Archives
Volume 2021.07
  • RPT management utilities for 2021
  • Download my advanced course materials
  • Anyone want to recompile this free dll to be 64-bit?
  • U2lwin32 recompiled for 64-bit, available to test
  • Transitioning from 32-bit Crystal Reports to Crystal Reports 2020
  • Using HTML interpretation
  • Crystal Reports 2016 date formatting issue
  • Undocumented limit on the ExtractString() function
  • Gems from the Archives  
Volume 2021.05
  • Comparison of server-based schedulers (2021)
  • Crystal Reports course materials – free download
  • The wrong way to design a report
  • Improved formula for elapsed business hours
  • Arial 10 text objects get “squished”
  • More uses for the Report Explorer
  • I finally found a use for the Crystal Reports Workbench
  • One way to exceed the table limits in MS Access
  • Gems from the Archives  
Volume 2021.03 Volume 2021.01
  • Web based deployment options compared (2021)
  • SQL to create data dictionary reports
  • New Web Widget features of Visual Cut
  • Missing the recent file list
  • IF THEN vs SELECT CASE
  • Update to my SQL functions “cheat sheet”
  • “Convert Null to Default” breaks the selection formula
  • How to retrieve your Crystal Reports license key
  • Gems from the Archives
Volume 2020.11 Volume 2020.09
  • Updated comparison of Crystal Reports viewers (2020)
  • How to remove the SAP BW toolbar in Crystal Reports 2020
  • Converting a character date to a true date
  • Converting String and Numeric Dates to DateValues (part 2)
  • Get distinct count subtotals to add up to the grand total
  • Why would you “Perform grouping on server”?
  • Fields that change format when moved to a different environment
  • rePORTAL v6.5 released
  • Gems from the Archives
Volume 2020.07
  • RPT management utilities for 2020
  • Are you ready for Crystal Reports 2020?
  • Crystal Dispatch site license for $5
  • Updating a database table from a Crystal Reports formula
  • Giving the database what it needs
  • Objects highlighted, but only in design view
  • Free lesson in Cross-tab grid functions
  • Fun with looping logic
  • Gems from the Archives
Volume 2020.05 Volume 2020.03
  • Comparison of desktop-based schedulers (2020 update)
  • The number of business hours between two DateTimes (updated)
  • Cross-tabs can total formulas that you can't normally total
  • Charting based on a parameter value
  • "New Page After" on group 2 orphans Group Footer 1
  • Using the "parent" section in the Section Expert
  • The humble beginning
  • Trouble installing CR 2016
  • Gems from the Archives

 

Volume 2020.01
  • Web based deployment options compared (2020)
  • Script errors on the start page and how to customize it
  • Grouping times into half hour periods
  • Save money on rePORTAL
  • Column breaks in a multi-column report
  • Deleting fields without losing (linked) column headings
  • PDF problems with Viewpoint's Spectrum Software
  • Sage 50 GetPeach() functions in Windows 10
  • Gems from the Archives

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