Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
crystal reports  crystal  formula  function libraries  function  holidays  new  pdf  report  reportal  reports  run  server  time  web 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: The Crystal Reports Underground

The Crystal Reports® Underground



Independent news, tips and thoughts from a Crystal Reports expert



Last Build Date: Sat, 09 Dec 2017 14:52:28 +0000

 




Sat, 09 Dec 2017 14:52:28 +0000

I received a call this week from a potential customer who said he wanted me to help him modify some reports. But then he started talking about iNet Clear Reports. I told him that I did Crystal Reports and had never heard of Clear. He said that Clear was “just like” Crystal and he was […]



Crystal Reports formula function libraries (2017)

Mon, 27 Nov 2017 22:31:07 +0000

It is time for my annual comparison of formula function libraries. If you aren’t familiar with User Function Libraries (or UFLs) they are DLL files that add new formula functions to your Crystal Reports formula editor. With these functions your formulas can do some pretty amazing things like: 1) Carry values from today’s report to […]



Report hyperlinks that export to a PDF

Wed, 22 Nov 2017 21:02:08 +0000

I recently learned several things about passing hyperlinks from a Crystal report to a PDF while working on a customer project. The goal of the project was for every line of the report (each invoice) to have a clickable hyperlink. Clicking that hyperlink would open the corresponding PDF image for that invoice. The pdf files […]



Save money on reportal

Mon, 13 Nov 2017 19:26:28 +0000

reportal Software has just released reportal 6.2, a new version of their web portal for Crystal Reports.  They are offering a 10% discount on all server license fees through November 30, 2017.  I don’t see the server price on their web site but the price was $3,000 per server in January when I did my […]



Formula that calculates all US federal holidays

Tue, 07 Nov 2017 20:33:31 +0000

I have several formulas that relate to “business days” or “business hours“. Most allow you to exclude holidays as long as you maintain a list (array) of holidays in a formula in the report. Years ago, one of my readers took the time to write a formula that would automatically load the holidays into an […]



New Crystal Reports viewer

Wed, 25 Oct 2017 03:38:10 +0000

APB Reports has released a new viewer called CR Dispatch. CR Dispatch takes a different approach to viewing your reports, since it has a minimal user interface that only appears the first time you run a report. After that it provides a secure way to run a specific RPT with one click. The first time […]



Microsoft updates break spreadsheet driver (and a possible workaround)

Wed, 18 Oct 2017 02:26:37 +0000

Two customers contacted me in the past few days about the following Microsoft updates. KB4041676 for Windows 10 KB4041681 for Windows 7/8 These updates broke reports that use the ‘classic’ Microsoft JET drivers to read ‘classic’ xls spreadsheets. ‘Classic’ here is a euphemism for ‘ancient but still working’, like my workhorse Office XP from 2002. […]



Find it EZ partners with rePORTAL

Mon, 16 Oct 2017 02:52:54 +0000

Find it EZ (search and documentation) has recently partnered with rePORTAL (scheduling and distribution), which means some new Find it EZ features and some discounts for rePORTAL customers. Find it EZ now directly integrates with the rePORTAL scheduling database. This allows rePORTAL users to extract scheduling information (run times, recipients, destinations, etc.) into user-friendly spreadsheets […]



SQL Function “cheat sheet” for writing commands

Sun, 08 Oct 2017 21:44:11 +0000

In recent years, I have been doing lots of SQL command-based reports, which means writing lots of queries in every imaginable flavor of SQL. It was initially frustrating trying to keep the syntax changes straight and I got tired of doing web searches for the same functions over and over. My solution was to create […]



Updated comparison of Crystal Reports viewers (2017)

Tue, 26 Sep 2017 21:08:48 +0000

You use Crystal Reports to create, change and run reports. But what if you have users who just need to refresh/view/print/export? Do they need copies of Crystal Reports? Do you need to configure an expensive web server? The most cost effective method for letting a user run reports is to install a third-party client-based viewer. […]