Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
based  crystal reports  crystal  data  date range  date  numbers  parameter  refresh  report  reports  subreport  tools  values  versions 
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: Mon, 14 Aug 2017 03:42:39 +0000

 



Additional parameter values are needed ….

Mon, 14 Aug 2017 03:42:39 +0000

If you refresh certain reports and then try to save the report with data you may get the following error: “Additional parameter values are needed before this report can be saved or viewed with data….” The error seems to occur only in certain versions of Crystal.  If you see this message and want to save […]



RPT management utilities for 2017

Sun, 30 Jul 2017 18:19:36 +0000

I have just updated my comparison of RPT management utilities for 2017. These are tools that allow you to scan, document, compare and in some cases batch update RPT files.  The list now includes 9 tools: Report Runner Documentor by Jeff-Net R-Tag Documentation and Search by R-Tag CR Data Source by R-Tag Visual CUT and […]



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