Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
crystal reports  crystal  date range  date  dates  failure  field  inflation  master  order  read  report  reports  server based  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: Mon, 19 Jun 2017 23:56:23 +0000

 



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



Creating a master “dates” table on the fly.

Tue, 09 May 2017 14:32:06 +0000

In some environments, developers have to maintain a master “dates” table with a complete list of dates. If used correctly, it can allow a report to fill in date gaps where there are no transactions. You would have the report start with the master dates table and then link to the date field in your […]



Adding an inflation table (Part 2)

Fri, 28 Apr 2017 21:16:38 +0000

My last post was about inflation tables and included a quick and dirty method for deploying one using a spreadsheet.  I started with that method because anyone can use it and it should work in any report.  But there are better methods you can use most of the time.  The ideal method is to create […]



Adding an inflation table (Part 1)

Sat, 22 Apr 2017 14:23:04 +0000

I have a couple of really handy calendar report templates that I have sold to several of my customers. They are mostly simple to deploy but there is one tricky part, and that is that they require an “inflation table”.  This is a table that is added to the report to force each record in […]



Using OLEDB to read MS Excel or MS Access files

Fri, 14 Apr 2017 01:20:05 +0000

Occasionally I have customers that need to query MS Excel or MS Access files for their Reports. Crystal Reports has always provided a DAO connector that allows you to read the classic XLS and MDB files directly. But starting in 2007 Microsoft introduced the XLSX and ACCDB formats and these can’t be read using the […]