The Crystal Reports Underground News:

 Back Issues:

Volume 2012.01

• Server based deployment options compared (2012 update)
• Another Free Viewer for Crystal Reports
• A total of a formula instead of a formula of totals
• Controlling the color of many objects from one formula
• Case sensitivity in Crystal Reports
• Find it EZ adds support for Dashboards and SQL
• Strange printer behavior at runtime
• Dynamic parameter limit on "list of values"
• Other recent blog articles:
• Running v8.5 reports in later versions of CR
• Five intangible metrics

Volume 2011.11

• Crystal Reports formula function libraries (2011 update)
• CR 2008 service pack 4
• Find it EZ offers a 30 % discount
• ReCrystallize Pro v14 is released
• Grouping transactions by season
• Why distinct count subtotals don't add up to the distinct count grand totals
• Mystery line in PDFs
• Resetting the toolbars and the 'explorer' panels
• Null values and the selection formula

Volume 2011.09

• Comparison of Crystal Reports Viewers (2011 update)
• Helpful features of the linking window
• Using CRLogger.dll to troubleshoot database issues
• Resetting SQL Errors
• Why does CR sometimes add '1' to a table name?
• CUT Light UFL provides distance calculation
• Ninite.com installs and updates free software applications.
• Other recent blog articles:
• Free copy of Report Runner by Jeff-Net
• CR XI dynamic parameters in CR Server 2008 

Volume 2011.07

• Comparison of RPT Management Utilities (2011 update)
• New Crystal Server 2011 and BO Edge 4.0 for Small/Medium Businesses
• CR 2011 free developer features vs full developer features
• SAP discontinues most prior versions
• Generating an Excel pivot table from a Crystal Report
• Price drop on cViewMANAGER
• Exporting to RPT format
• DataLink Viewer now available with the CR 2011 runtime 
• Other recent blog articles:
• Date parameter prompt errors
• Free printer drivers solve issue with Zebra printers
• Doing a "distinct count" in Excel 

Volume 2011.05

• New features in Crystal Reports 2011 
• License changes in Crystal Reports 2011 
• Comparison of server-based schedulers (2011 Update)
• Tools for troubleshooting
• Case study for UNION of daily files 
• New Crystal Reports licensing overview 
• Formatting chart dates (part 2) 
• Mysterious blank pages 
• Other recent blog articles: 
• Crystal Reports 2011 release notes 
• Evaluate CR Server "in the cloud" (or maybe not) 
• Odd error using ODBC to IBM U2 
• Classic VB runtime and PDF exports

Volume 2011.03

• Comparison of desktop-based schedulers (2011 Update)
• Crystal Reports suggestion box
• Drawing tables in a Crystal Report
• Generating a UNION from the Linking window
• Formatting chart dates
• Number formats in the legend of a pie chart 
• Other recent blog articles:
• Row Level Security in CR Server
• Dynamic parameters stop working with CR 2008 SP3?

Volume 2011.01

• Crystal Reports 2011 (coming soon)
• Take my new Crystal Reports test
• Export to a PDF that allows for drill-down
• Server based deployment Options compared (2011 update)
• Using Approximate Joins
• Does IsNull() let you filter a Left Outer Join?
• Other recent blog articles:
• Sample "Time Master" Report from SAP
• Missing export formats in an application
• Grey background when printing an image

Volume 2010.11

• Crystal Reports Function Libraries Compared
• Shortcut Keys in Crystal Reports
• Using Autosave in Crystal Reports
• Exports to ODBC and null dates
• When Crystal is too helpful
• Other recent blog articles:
• Restore Characters Per Inch prompt in text exports
• Crystal Reports Service Pack 3 and saved data problems

Volume 2010.09

• Crystal Reports Viewers
• Free download of Xcelsius
• Crystal Reports on Windows 7, 64-bit
• Fixed length text exports using Cut Light
• Setting the RGB color of multiple fields at the same time
• Mixing single values and ranges in the select expert
• Other recent blog posts:
• Reportapalooza
• Embedding an XSD into an XML file

Volume 2010.07

• RPT Management Tools
• Reporting on XML data
• Numeric parameters without commas
• Percentages in Crystal Reports vs Excel
• Preventing Drill-Down
• Other recent blog posts
      Dealing with data types that change at runtime
      Modification date/time bug
      CR rebranded as SAP Crystal Reports, v13 in 2011
      Unlocking the chart "marker size" property

Volume 2010.05

• Server Based Scheduling Engines
• Placing a group of fields onto the report in a column
• Setting a Crystal Report to Any Datasource
• Crystal Reports and barcodes
• The history of Crystal Reports SDKs
• Dynamic images in .NET applications
  

Volume 2010.03

• Desktop Based Scheduling Engines (Review)
• Changes coming for the SAP/BO certification exams
• Advertising on Ken Hamady.com
• Finding all uses of a variable
• Reporting on the Database Schema
• Superscript numbers in a Crystal Report
• Vanishing data in Btrieve
• Screen Problems in the Standard Report Wizard

Volume 2010.01

• Server based options for Deploying Crystal Reports (Review)
• Advertising on KenHamady.com
• Crystal Reports 2010?
• Buying older versions of Crystal Reports
• Using unlinked tables (cross joins)
• "ALT" key temporarily releases guidelines and grid
• Using negative subscripts
• Using the parameter "batch" interface toolbar

Volume 2009.12

• Surfing Gecko offers "all you can eat" viewer for $129
• Selecting multiple objects (to copy or align)
• Formula editor window disappears
• Formula field tree that won't dock
• Calculating a Distinct Sum at the top of the report (or) 
• Building arrays WhileReadingRecords
• Using Crystal Reports in VB.NET Express Edition
• Other recent blog articles:
• The Joel Test: 12 Steps to Better Code
• New prices for mapping layers (zip/county)

Volume 2009.10

• Master topic index for my guides and course books
• Customizing Crystal Reports Start or Splash screen
• Rounding bug mimics 'banker' rounding
• Crystal Reports and the color orange
• Merge, Split and Rotate PDF Files (for free)
• Formula for todays date in contract format
• Other recent blog articles:
• SAP solves the Zebra printer issue?
• CR 2008 Web viewers lose text rotation
• Crystal Reports 2008 Service Pack list
• Clarion/Topspeed ODBC fails (and is solved) in XI/2008

Volume 2009.09

• Do-It-Yourself license audit from SAP
• Master topic index for my guides
• Rundown on 3rd party products
• Save 25% on CR Chart
• PeachTree finally allows SQL (OLEDB)
• Cross-Tabs with multiple initial columns
• Date parameters in a Command with DateTime fields
• Other recent blog articles:
• The 8-minute Crystal Reports program startup
• Using Business Objects Query Builder
• VB Express editions don't support CR integrationTroubleshooting Duplicate Records

Volume 2009.07

• NEW - Expert Techniques Volume 4
• Troubleshooting Duplicate Records
• Converting seconds (Universal Time) to a DateTime value
• IT World Canada weighs in on CR licensing
• SAP/BO 2009 User Conference
• Refreshing reports hosted on CrystalReports.com
• Other recent blog articles
• Formula trouble using "Integer Divide" (the backslash)
• SAP users experiencing "performance" problems
• Lawson structure documentation on the web
• Changes in the BOCP registration process
• CR2008 SP1 is incompatible with SP0

Volume 2009.05

• Free DLL with new Crystal formula functions
• Expert's Guide to Formulas updated for CR 2008
• Make your Crystal Reports Pornography before you upgrade!
• On-Demand Subreports that use saved data (no refresh needed)
• Reporting on data that isn't there Part 2
• Other recent blog articles:
• Moving values backward in a report (Wormhole)
• Showing wide cross-tabs in a subreport
• Calculate your share of a billion dollar expenditure (US taxpayers)
  

Volume 2009.03

• New license restrictions for Crystal Reports
• Expert Techniques vol. 2 updated for CR 2008
• New options for Web app developers
• Finding old (and new) downloads on the SAP site
• Reporting on data that isn't there Part 1 
• Other recent blog articles
• Mapping versions to Service Packs
• Gag orders in software contracts?
• Founder of Business Objects goes open source
• Free DataDirect ODBC drivers v5.3 for CR 2008
• CR 2008 SP1 is released
• SAP 'fully integrates' Business Objects sales

Volume 2009.01

• SAP resurrects the "screenshots" issue
• Expert Techniques vol. 1 update for CR 2008
• Using AutoComplete in Crystal Reports formulas
• Shared variables from a suppressed subreport
• Ranking based on a ratio
• Other recent blog articles
• Global variables fail in multi-page cross-tabs
• Converting text to date or datetime
• The original creators of Crystal Reports try again
• More label printer problems

Volume 2008.11

• Changes to CrossLoop TOS
• Email hoaxes
• Extra rows and columns in Excel export
• Checking Dependencies
• InnoScript/Inno Setup handle Crystal Reports dependencies
• Overridden Qualified Table Names
• Grouping by a non-calendar week

Volume 2008.09

• Problems with SAP/BO support changes
• Crystal Reports Server 2008
• New viewer for Crystal Reports
• Training and courseware on CR 2008
• CR 2008 parameter features added to the "Experts Guide"
• Temporarily ignoring the grid and guidelines
• Using the Report Explorer
• The effect of dashes on the VAL() function
• Other recent BLOG topics
• Updates to third party products
• Crystal Reports Viewer 2008
• CR 2008 doesn't like Zebra label printers?
• Public classes using my 3-day accelerated format
• Adding business hours/minutes to a start DateTime

Volume 2008.07

• Article comparing the big BI vendors
• Crystal Reports knowledge base moved to SAP support
• Listing of free trials from Business Objects
• Associate available for Business Objects Enterprise and CR Server
• Cascading page breaks (page breaks on interior groups)
• Multi-value parameters for commands and stored procedures
• "Sticky" buttons for the Format Painter and other controls
• Free PDF generators

Volume 2008.05

• Article comparing the big BI vendors
• CR Server XI for $2,495 (CR Server 2008 coming?)
• Displaying chosen parameter values with descriptions
• Moving/sizing objects with Shift-Arrow and Ctrl-Arrow (and crashing CR)
• Conditional page footer
• Expert's Guide to Cross-tabs (CR 2008 Update)
• Recent Blog Articles:
  
• Actuate Migration (written by Actuate)
• Adding the Euro symbol to reports
• SAP retiring overlapping products
• "Free" vendor compliance management
• CR 2008 Service Pack 0 breaks Xbase Connector
• Field names containing dashes add nodes to the Field Tree
• Prevent Crystal from requesting an Internet connection at startup

Volume 2008.03

• BO refuses to fund UG meetings based on the speaker
• PeachTree 2008 table changes
• Cascading parameters that lose values
• Cascading parameters with duplicate field names
• Converting a decimal to a fraction
• Recent Blog Articles:
  
• Convert Nulls and Selecting Nulls
• Appending Strings in v8.5 when going over 256 Chars
• Trouble with Business Objects ESD licensing system
• Mystery calendar for date parameters in v10 on Vista
• Business Objects releases Viewer XI for Linux
• Recent Upgrades for third party utilities

Volume 2008.01

• NEW - The Expert's Guide to SQL Expressions, Options and Commands
• Things you wont find in Crystal Reports 2008:
• RDC (COM) integration  
• Xtreme sample MDB
• VB UFL functions
• BO price increases
  
• The index that ate my data
• Getting vertical lines to stop at the bottom of a group
• Suppressing vertical lines based on a condition
  

Volume 2007.11

• Crystal Reports 2008 (Version 12)
• SAP purchases BO/IBM Purchases Cognos
• Free Crystal Reports Viewer with scheduling and Email (Logicity)
• Free Trial of "Mass Verify"
• PDF eXPLODE fails on Vista
• Coming - The Expert's Guide to SQL Expressions, Options and Commands
• Create a formula library in Phrase Express
• Free MICR font turns blank security paper into check stock (GnuMICR)
• Store a value today and use it in a different report tomorrow (CUT Light/Share DLL)

Volume 2007.09

• Understanding "named user" licensing for Crystal Reports 
• The new Authorized Consulting Partner (ACP) designation
• Spell check or "verify database" for a batch of reports
• Don't rouse sleeping tables
• Multi-page cross-tabs missing page numbers
• Blog highlights:
      Crystal Reports admin position in Richmond
      Crystal Reports v8.x and Vista
      Crystal Reports Viewer XI officially released
      An Introduction to Eclipse for Visual Studio users
      Calculating periods in 5-4-4
      Printing check marks and other symbols from formulas
  
  
  

Volume 2007.07

• Expert Techniques for Crystal Reports Volume III
• User Group takeover attempt in the Detroit area
• BO updates the Offline viewer
• My favorite utilities 
• Canadian holidays formula
• New - Certified associates to teach your on-site classes
• Free options for desktop sharing
• Finding a stray formula or parameter in your report
• ToNumber ()  vs Val ()

Volume 2007.05

• Expert Techniques for Crystal Reports Volume III
• User Group takeover attempt in the Detroit area
• Launching reports from MS Access (VBA)
• BO settles with Michigan former partner
• $99 XI Upgrade offer extended
• Independent Cognos instructor available
• Using table inflation to generate multiple labels
• Recent BLOG articles
• Creating a Bill of Materials with Crystal Reports
• Installing Crystal 7 on Vista
• Creating VERY wide Crystal Reports
• Help Beta test 2 new Crystal Reports utilities
• New features of Visual Cut
  

Volume 2007.03

• Expert Techniques for Crystal Reports Volume III 
• Upgrade to Crystal Reports XI for only $99
• Convert Crystal Reports to SSRS XML files
• Recent BLOG articles
  
  • Daylight Saving Time this weekend!
  • Are you LinkedIn?
  • Oracle buys Hyperion
  • Crystal Decisions is back - BO Enterprise 'lite'
  • Crystal Reports Web App licensing & throughput clarified
  • Business Objects XIr2 wins a "prestigious" CODiE award
• Help Beta test a new viewer
• Side by Side running Totals give different values

Volume 2007.01

• Email reports and other documents by "printing" them
• Stop struggling with your reports, let me help
• BO cuts off support for an independent consulting firm
• I am now Ken Hamady, LLC
• Business Objects acquires Nsite Software
• My Library of Crystal Reports Guides
• Linking tables vs Appending tables
• Correction for Holidays formula
  

Volume 2006.11

• Visit the Crystal Reports Underground BLOG
• New Data Dictionary builder (MyDataDictionary) is released
• Keep up with my BLOG via Email
• New Associate Trainers in Vancouver/Seattle and Detroit
• BO partners with IBM 
• Recover a corrupted RPT File
• Best FREE utilities recommended by Ian "Gizmo" Richards
• Formula naming tips

Volume 2006.09

• Visit the Crystal Reports Underground BLOG
• Deploy Crystal on the Web using RippleStone
• New Associate Trainers in Boston, Phoenix and Indianapolis:
• Crystal Reports for Eclipse Update:
• "Official" v8.5 support scheduled to end this month
• A line that grows based on a condition
• When "Repeat Group Header" won't repeat

Volume 2006.07

• NEW - The Expert's Guide to Cross-Tabs
• Depositions start this week in the BO commissions lawsuit
• BO loses SAP as on OEM Reseller
• Associate Trainers for Boston, NYC, Philly, Chicago, L.A. and Toronto:
• BO starts to look at 'mid-size' business.
• BO (finally) announces plans for Google OneBox partnership
• Build a Data Dictionary, automatically from your reports
• Printing "Continued on Next Page"
• Date parameters in a command with DateTime Fields
• One parameter for 2 different commands

Volume 2006.05

• BO hosts free Crystal Reports portal
• Google OneBox partners with Cognos, SAS, Oracle and FINALLY BO
• Associate Trainers for NYC, Philly, Chicago, L.A. and Toronto
• Former partner sues BO over commissions
• Crystal extends support for older versions
• New viewer adds scheduling and email distribution
• Viewer that allows "in-place" drill-down and one-click resort
• Setting section height numerically
• Can't copy parameters in XI
  

Volume 2006.03

• Crystal Reports XI and Cold Fusion
• Update to my "Don't Pay Twice" Campaign
• Buying Older Versions of Crystal
• Mapping by County or Zip Code
• Copying Objects Within a Report
• Copying Objects to Another Report
  

Volume 2006.01

• Crystal Reports Plug-In for Eclipse (released)
  
• DC Area User Group Meeting
• Crystal Reports for Eclipse preview release
• BO Leasing Software
• Crystal Excelsius
• CUT and CUT Light now prompt for comments after the report is run
• Crystal Translator 3.01
• Conditional Drill-Down
• Cross-tab percentages simplified

Volume 2005.11

• Crystal Reports Plug-In for Eclipse
• Course Books Available
• An Independent Crystal Instructor in Canada
• Crystal Reports for Eclipse
• Updates on the "Don't Pay Twice" campaign:
• BO Conference in November
• Data Link Viewer 5.1001 with print scheduling
• How to format a paragraph with a "hanging indent"
• Online Faxing solutions
  

Volume 2005.09

• Crystal Reports Plug-In for Eclipse
• BO Loses Patent Lawsuit against Microstrategy
• Updates on the "Don't Pay Twice" campaign:
• BO Conference in November
• Using Formulas that rely on Subtotals in your Cross-tabs
• Chart on a Parameter Value

Volume 2005.08

• The Expert's Guide to Totals in Crystal Reports
• Crystal Reports Server XI for Linux
• Security Vulnerability for XI Web Deployments
• Updates on the "Don't Pay Twice" campaign
• BO official response contradicts Dan Klein's letter
• Article in ITBusiness.ca
• OEM classes to be targeted next
• Crystal Experts weigh in at Tek-Tips.com
• Free Mailing Label templates from WorldLabel
• Business Objects conference in November
• No way to default TODAY for XI date parameters
• Formula for finding the first and last day of a month

Volume 2005.07

• Updates on the "Don't Pay Twice" campaign
• Why I fight a policy that could increase my own revenue
• DC Users Group responds in writing to BO's new policies   
  
• Companies that have decided to ignore BO's new license fees
• BO refuses to clarify the existing Crystal license   
  
• Court ruling allows use of Screenshots without permission
• Article in ITBusiness.CA about BO's new policy
  
• Watch out for overpriced training manuals
• Inexpensive Web Deployment using Reportal CR
• A New MS Access Report Converter
• Force groups to start on the odd page number
• Suppress column headings on the last page when there are no details
• New Page After" on group 2 orphans group footer 1

Volume 2005.06

• BO attempts to restrict user group speakers
• The "Don't Pay Twice" campaign to educate Crystal and Enterprise users
• Business Objects Enterprise XI configurations and prices
• Crystal Reports Server vs building your own application
• Crystal Wizard official download
• New XI features added to the Expert's Guide to Subreports, Parameters and Alerts
• Eliminating extra rows and columns in Excel exports
• Copying and pasting cross-tabs to Excel

Volume 2005.05

• Are independent training and consulting license violations?
• CDUGNA is no more
• CrystalWizard was gone in v11, but is available again
• Enhanced ODBC export in Visual Cut
• More complaints about v11 parameters
• Some tricks I learned from my students
  

Volume 2005.03

• Crystal Reports Server
• BO Enterprise XI
• No Broadcast License?
• Another complaint about CR XI
• Another comparison of SSRS and CR
• A formula that finds Easter for any year
• An improved formula for getting the report file name

Volume 2005.02

• Detailed list of new features in CR XI
• Is CR/CE too expensive for small/medium size businesses?
• Are independent courses/courseware a violation of BO's license?
• A new comparison of CE and SSRS
• Another free Bar-Code Font
• .rpt Inspector 3 Enterprise Suite, and 25% off for my readers
• Getting reports from spreadsheet data

Volume 2005.01

• Highlights of Crystal Reports 11
• The end of concurrent licenses
  
• Expert's Guide to Subreports, Parameters and Alerts (New)
• Selecting an ODBC Connection at runtime
• Data Link Viewer 4.5001 Released
  

Volume 2004.11

• Class Action Suit Against Business Objects
• The end of concurrent licenses?
• Security issue with JPEG files
• Reportal v3
• SQL Expressions that do Correlated Subqueries
• When using a Command can Slow Things Down
  

Volume 2004.10

• Distinct Sum when the duplicates are not consecutive
• Registry key to turn off auto linking in v9
• Free and Simple Bar Code Fonts
• Tricks to using the Mailing Label Wizard
• Finding the First or Last Friday of the Month (or any weekday)
• How many Mondays in a date range
  

Volume 2004.09

• Spam Filters and this Newsletter
• When Crystal tries to be "helpful" (and how to avoid it)
• A New Access Report Converter
  
• A New Report Translation Management Tool
• Improved Rounding to the nearest 5 cents
• Alternate Method for Splitting a Section

Volume 2004.08

• Actuate offers a Crystal 'converter' service
• Using the Performance Info in v9 and v10
• Finding groups where the last record meets a criteria
• Export to a secured PDF (no Printing, Changing, etc w/o password)
• Rounding to the nearest 5 cents
  

Volume 2004.07

• Free Support for Crystal Reports
• Crystal ends free support for v8.5
• Putting Percentages in a cross-tab
• Aligning Text objects with Fields in v10
• Experiences with Crystal Support

Volume 2004.06

• Security Flaw in Crystal Enterprise
  
• SQL Server Native Client and syntax changes
• Other reasons to keep a copy v8.5 around 
• Parameter for ALL including Nulls (Improved)
• Export to PDF and color code the PDF Bookmarks
• Changing a command causes CRv10 to shut down
• PrintDate vs DataDate (and another bug in v10)

Volume 2004.05

• Broadcast License restrictions removed from CRv10
• New shareware viewer/manager "Crystal Delivery"
• Why you should turn off "Field Clipping" in any version of Crystal
• How to use "OR" and still pass a WHERE clause to your SQL statement
•  Visual Cut Exports to specific Excel tabs
• "Keep Group Together" in v10

Volume 2004.04

•  Lose your Repository when you 'upgrade' to CRv10
•  Running Crystal Enterprise and Crystal Reports in Linux
• Getting CR and CE Certifications from BO for $450
• Crystal v11 to be released in late 2004?
• CRv9 and CRv10 report files are already 'zipped'
• Shutting of Smart Linking in CRv10
• CRv9 and CRv10 can't use SQL Server native client
• CRV9 Service Pack 3 released
  

Volume 2004.03

• Summary of Crystal Enterprise v10 Options and Pricing
• New "Business Days" Formulas:
• Special Offer on SPL 2 and rpt Inspector 2
• Visual Cut 3.0
• Parameter remembers last choice in v10
• Locking the size of a Box by going past the margin
• New formula for 6-digit number to date.
• Changing the Btrieve DAT file used by a report

Volume 2004.02

• Summary of Crystal Reports v10 Editions
• Comparison of Crystal to SQL Server Reporting Services
• Free ODBC driver/Data Schema for QuickBooks
• PeachTree SalesRep field moved 
• OLE image objects glitch
• Visual FoxPro file Name glitch
• CDUGNA 2004 Conference
• British Columbia Users Group Meeting
• Dallas/Ft. Worth Users Group Meeting

Volume 2004.01

• Review of Crystal Reports v10
• License Changes in CRv10 
• New Certification options for CR/CE v10
• Bug in HTML Text Interpretation (v9)
• Who might switch to SQL Server Reporting Services
• CDUGNA 2004 Conference
• Business Objects makes it official

Volume 2003.12

• Using Bar Code Fonts in Crystal:
• A description of SQL Server Reporting Services
• Find a date based on Year and ISO Standard Date
• Doing a SELECT in a SQL Expression field
• Automatically Updating Repository Objects in Reports
• Reinstall fixes bug?

Volume 2003.11

• Crystal Reports v10
• Business Objects User Conference
• Discount on ICB Reports
• Change Paper Tray / Orientation with DataLink Viewer 
• Crystal Info looses support in 2004
• The chart changes based on parameter values chosen?
• Column Heading bug in v9
• Some Functions not allowed when writing custom Functions
• Custom Functions update only when you change File Options

Volume 2003.10

• NEW! Quick Reference to Crystal Reports in VB.NET 
• User Contributions:
•     > RAS sample code
•     > Displaying Multiple Range Parameters
• Octoburst and OctoPDF
• Crystal Command 
• User Name Security in DataLink Viewer 
• When "Select Distinct" doesn't work
• "Convert Null to Default" is disabled?
• Specifying Chart Colors by Group
• Email Delays from Verio

Volume 2003.09

• NEW! Expert Techniques for Crystal Reports Vol II - (more favorite Tips and Tricks)
• Free copy of Crystal Enterprise 9 Professional
• Encrypting RPT files (protect your source code)
• Enhancements to Crystal Ease
• An "Open Source" version of a Crystal Reports viewer
• Bugs in v9 with .NET
• Adding repository folders for Custom Functions
• New PDFs on Crystal object models
• Business Objects user Conference
• Getting Column Breaks in a multi-column report
• Discourage Identity Theft for 7 years (for free)
  

Volume 2003.08

• NEW! Expert Techniques for Crystal Reports Vol I - (my favorite Tips and Tricks)
• Some new details about SQL Server Reporting Services
• Crystal Decisions bought by Business Objects
• Crystal Enterprise Add-In for Microsoft Excel
• Visual Cut now exports to PDF with Bookmarks
• New Search feature on Crystal's website
• Chart bug when using "Side by Side" install of Crystal
• Mozilla - the browser without Pop-Up windows

Volume 2003.07

• CR Advanced Free Trial 
• Shopping Around for Crystal Services and Software
• Crystal Passage includes Email
• Charting Enhancements by 3D Graphics
• Crystal Ease 3  
• Using "Unlisted" Functions in SQL Expressions

Volume 2003.06

• Response from CD to Broadcast Scenarios 
• Microsoft Reporting Services Beta program
• Crystal Decisions Going Public?
• Parameter Fields with an Up-To-Date Pick List
• CView Pick
• DataLink Viewer
  
• RAS ePortfolio parameter limits
• BC Users Group
• Report File Name without the path in v7

Volume 2003.05

• Surprise Change in Crystal v9 Licensing
• Broadcast Scenarios Update
• Microsoft Gets Into Reporting?
• Third Party Product Updates
• Visual Cut
• Cut Light
• Reportal
• Fax Distribution Tools
• Crystal Partners Opt Out

Volume 2003.04

• Crystal Broadcast License now $100,000
• Crystal Broadcast scenarios
• Preventing Unwanted Drill-Down
• Section Background Color that fades gradually.
• Third Party Product Update
• Crystal Reports Distributor 3.0
• rptViewer
• DataLink Viewer
• A New 3rd Party Report Distribution System

Volume 2003.03

• My list of 3rd Party Products for Crystal Reports
• Folder and Row level security for Crystal Enterprise Standard
• Report Shield
• ICB Viewer
• Row Level Security for Crystal Enterprise Professional
• APOS
• Crystal Enterprise Prices
• February Case Study Follow Up - CE9 RAS Advanced Edition
• Using Currency Symbol Codes (Euro,Pounds Yen) in your Reports

Volume 2003.02

• Crystal Enterprise v9 is Released
• Free Download of VB.NET Book
• User Group Meetings in British Columbia
• National CDUGNA conference in British Columbia
• Report on User Group meeting in DC
• February Case Study - CE9 RAS Advanced Edition
• Free Download of Crystal Passage Scheduler
• Special Offer on Crystal Desk Report Scheduler Pro v9 
• The Complete Reference for Crystal Reports v9 

Volume 2003.01

• User Group meetings in DC and Central Virginia
• Test your self with my Crystal Reports Skills Test
• New Service Pack for Crystal Reports v8.5 
• Report directly from COBOL data files, without ODBC drivers (Data2CR) 
• Choose an Ascending or Descending sort with a parameter 
• CRv8.5 Help files don't install on PCs with IEv6 
• Bug in the Reimport Subreport feature

Volume 2002.12

• NEW! The Expert's Guide to Crystal Reports Formulas
• Download a complete list of all of Crystal's Technical Briefs
• Converting MS Access Reports to Crystal Reports, automatically
• Crystal Desk 3.0 Scheduler and a New Report Viewer
• Using Cross-tabs to Increment Running Totals
• A New Formula Debug/Trace Window in Crystal v9 
• Warning! Crystal v9 Commands can now Read and Write

Volume 2002.11

• First Hot Fix for v9
• Stripping all punctuation from a string
• Useful PDF files from Crystal Decisions
• New Third-Party Products
• Missing License Information
• Displaying Range Parameters with "No Lower/Upper Bound"

Volume 2002.10

• Web Deployment Options for CRv9 and RAS
• Download the SQL designer and the Dictionary Editor for CRv9
• Broadcast License clarified (some good news)
• "Cloaking" a group in a report
• New third-party products
• Timberline incompatible with Crystal v9
• Goldmine and Crystal v9 Standard

Volume 2002.09

• Crystal Reports Version 9 New Features (Good and Bad)
• Important License Changes in v9
• Other small improvements in v9
• Recommended improvements NOT made in v9
• Features removed or made worse in v9
  
• Washington DC Area User Group Meeting
• Does your User Group Board Represent You?
• Dallas-Fort Worth User Group Meeting

Volume 2002.08

• Evaluating your Crystal Instructor
• New Utility to Search/Modify an entire batch of Crystal Reports in one step
• Reporting on Data that Isn't There
• Additional CALs now affect Broadcast License
• CUT Utility goes visual
• Is there a subreport hidden in this report 

Volume 2002.07

• Update of the VB Quick Reference Guide
• Crystal and Actuate settle lawsuit
• Why can't I total this formula?
• Reading an external logo file at runtime
• Mysterious shifting objects
• Taking the owner out of a SQL server database connection
• v8 Hot fix affects compiled reports

Volume 2002.06

• Sneak Peek at Crystal Reports Version 9
• Summary of Crystal Enterprise configuration options
• Crystal Reports user groups
• New version of Crystal Desk scheduler
• CUT Email UFL does electronic bursting
• How to move values from the last record to the Report Header
• Carving a memo field into smaller pieces

Volume 2002.05

• A new report viewer for only $35
• A new "Hot Fix" for Crystal v8.5
• Crystal presents evidence in lawsuit against Actuate
• Using PeachTree UFL functions for Crystal Reports
  
• Formula for adding a specific number of business days to a date
• Formula for finding the last Friday (or any day) of month

Volume 2002.04

• Distributing reports via Email
• How to print "continued on NEXT page"
• New tech articles on CD web-site
• Converting IF-THEN criteria to a WHERE clause
• CRv9 and Unicode support
• How to improve the resolution when exporting to PDF
• Printing check boxes and other symbols from formulas

Volume 2002.03

• Crystal v9 going into Beta testing
• Adding Functions to Crystal with UFLs
• Checking your SQL statements against the ISO standard
• Crystal Decisions Sues Actuate for false advertising
• New add-on products for Crystal Reports
• Page numbers for Cross-tabs
• The effect of dashes on the VAL() function

Volume 2002.02  

• Questions to ask while planning a Crystal Reports deployment
• Understanding the Crystal Reports licenses and fees
• Options for deploying Crystal Reports to multiple users
• An even *better* place to buy Crystal on the Web
• Washington DC Area User's Group Meeting in February
• Finding a stray formula so that it can be deleted
• Compile feature is now only for Developer's Edition

Volume 2002.01

• Where to buy Crystal Reports on the Web
• CR Upgrade Policy
• Buying Crystal Reports on Ebay
• Expanding the design area of Crystal Reports
• Calculating the Quartile from the percentile

Volume 2001.12

• The new Protege program
• The Crystal Reports "HotFix" update for v8.5
• Crystal, the Registry and INI files
• Formula for finding the first Monday of the current month
• Using "OR" for selection when you may have Null values

Volume 2001.11

• Crystal Authorization vs. Certification
• Email support from Crystal Decisions
• Active DLLs
• Forcing Table Inflation to create duplicate records
• The Stealth Subreport

Volume 2001.10

• Bugs in v8.5
• CrystalDesk
• Default Settings
• Mystery DLL names in CR
• DateTime fields in QRY Files

Volume 2001.09  

• Support from Crystal, Tek-Tips and other resources
• Putting a Title onto a Cross-tab
• The Saved Data trap
• Calculating the number of "Work Days" between two dates
• Using the Compile feature in Versions 8 and 8.5