Subscribe: The Crystal Reports Underground
Added By: Feedage Forager Feedage Grade A rated
Language: English
based  crystal reports  crystal  date range  date  failure  field  numbers  order  prompt change  report  reports  subreport  subreports  values 
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: Wed, 26 Jul 2017 23:16:21 +0000


A switch to turn “stealth” subreports on and off

Wed, 26 Jul 2017 03:28:05 +0000

I wrote a long time ago about the “Stealth” subreport. This is an invisible subreport that runs in the background and provides a value to the main report as a shared variable. But if you have a few of these subreports in the same container report it can be difficult to do troubleshooting. To see […]

Refresh prompt when you change pages?

Sun, 16 Jul 2017 18:03:05 +0000

This strange behavior has nagged at me for a while. I refresh a report that has subreports and preview the first page. When I move to the next page I get a prompt that says: “Change in record selection formula” and the choices are “Use Saved Data” or “Refresh Data”. Now it is obvious that […]

Sorting numbers that come after letters

Mon, 10 Jul 2017 23:01:26 +0000

I recently had a customer ask if I could help him sort part numbers. The problem was that the part numbers start with one or more letters followed by 2 to 7 digit number and sometimes a dash in between. Since the field is a string, and since the numbers vary in length, the sort […]

Crystal Reports versions over time (2017)

Wed, 28 Jun 2017 22:43:11 +0000

I do this chart each year based on my newsletter subscribers. It shows the version of Crystal Reports that they were using when they signed up for the newsletter. Over time, it shows which versions have staying power and how quickly new versions take hold. I have included numbers for 2017, even though the year […]

Caution when using “Select Distinct”

Mon, 19 Jun 2017 23:56:23 +0000

There is one thing you have to watch out for when you use the “Select Distinct Records” setting to eliminate duplicate records. There is often a difference between what you consider a duplicate and what SQL considers a duplicate. When you activate this feature (Database > Select Distinct Records) Crystal changes the first line of […]

Date range parameters for dates stored as strings

Fri, 16 Jun 2017 01:45:42 +0000

A few years ago I wrote a blog post about creating a date range parameter when your date field was stored in numeric values (eg. 20170614). I found that the best approach was to create a normal date range parameter, write formulas to convert the begin and end dates into numeric values and then use […]

Possible solution the cascading subreport failure

Thu, 08 Jun 2017 19:10:56 +0000

After my newsletter went out I heard from a user who had the “cascading” failure problem and received a solution from SAP. She was told to go into each subreport and open “File > Report Options”.  There she was told to take out the check mark for the feature “Show Preview Panel”.  She started doing […]

Server-based scheduler comparison (2017)

Mon, 29 May 2017 20:28:20 +0000

I have just updated my comparison of server-based scheduling tools for 2017. These tools are similar to the desktop-based scheduling tools I write about every March, but these are designed to be run on server. This allows multiple people to schedule reports for automated delivery by Email, FTP or network folder. There are 11 products […]

Recurring subreports cause “cascading” failure

Tue, 23 May 2017 17:49:03 +0000

I have seen a specific Crystal Reports failure with three different customers in the past few months and several other times before that. It happens whenever Crystal has to run “too many” recurring subreports instances. This results in a slow cascading failure. The most obvious symptom is the status bar along the bottom of the […]

How to “break” specified order grouping

Tue, 16 May 2017 18:00:48 +0000

The “specified order” feature in Crystal is useful when you need to group on a field, but you don’t want the values in normal ascending or descending order. With specified order you can place some or all the values for a field into the exact order that you want them to appear. Specified order is […]