Subscribe: The Crystal Reports Underground
Added By: Feedage Forager Feedage Grade A rated
Language: English
clear  copying  crystal reports  crystal  formula editor  formula  formulas  function libraries  holidays  pdf  report  reports  server  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: Thu, 18 Jan 2018 05:00:01 +0000


Web based deployment options compared (2018)

Thu, 18 Jan 2018 02:59:37 +0000

There are many ways to deploy Crystal Reports to users. I normally lean toward the simpler and less expensive options, like locally installed viewers, or scheduled delivery of PDF output. But there are environments where a web based option is necessary. The “official” options from SAP are Crystal (Reports) Server and BO Enterprise. But there […]

The power of a double click.

Tue, 09 Jan 2018 03:23:39 +0000

I do lots of work using GoToMeeting and often the screen I see is reduced in size, making things hard to read. It can be frustrating when trying to highlight a word without including characters on either side. So I have developed the habit of using double-clicks to select words. I find that not everyone […]

Handy copy tricks in Crystal Reports

Fri, 29 Dec 2017 02:34:03 +0000

I have written before about copying objects, both within a single report or from one report to another. Below are some new tips for copying values instead of objects. Copying literal values from preview mode: Often when validating or troubleshooting a report I want to take a specific item from the preview screen (an invoice […]

Renaming formulas in the Formula Editor vs the Field Explorer

Sun, 24 Dec 2017 04:48:38 +0000

I write many formulas, and the more formulas there are in a report the more import it is to name them well. About 10 years ago I wrote an article with tips for naming formulas. I will often come back and rename formulas when I find that the original names aren’t clear enough. One of […]

How to fix the error “A loop was evaluated more than the maximum number of times allowed”

Sun, 17 Dec 2017 15:17:07 +0000

A customer recently asked for help with a formula. She was creating an index at the end of a report to show page numbers for each item within the report. Her formula used nested FOR loops to put the elements of the array in alphabetical order. It was similar to this handy formula that I […]

i-Net Crystal Clear Reports

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 […]