Subscribe: The Crystal Reports Underground
Added By: Feedage Forager Feedage Grade A rated
Language: English
crystal reports  crystal  field  find field  formula  formulas  full years  month marks  month  report  reports  run reports  unused formulas 
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: Tue, 25 Oct 2016 16:09:07 +0000


Slope, intercept and correlation of x-y coordinates

Tue, 25 Oct 2016 14:45:28 +0000

I was recently asked to convert an Excel spreadsheet into a Crystal Report. I found that the spreadsheet used some Excel statistical functions that don’t exist in Crystal, so I had to replicate those in Crystal syntax. The functions calculated the slope, intercept and correlation of a series x-y coordinates. Once I had them working […]

Sorting on a memo field.

Sun, 16 Oct 2016 21:28:32 +0000

A customer wanted to sort on one of the fields in his report. But when he went into the Record Sort Expert that field was not shown. So he sent me the report to troubleshoot. I noticed that the data type of that fields was Memo, which is a data type that has an unlimited […]

Custom date format in charts

Fri, 07 Oct 2016 02:16:34 +0000

I periodically hear from Adam Butt of APB reports (Norway), usually when he stumbles on a neat Crystal Reports trick. This month he wrote to share a method for controlling the format of dates in charts. When you do a “group” chart, Crystal creates a bar for each group in the report. The label under […]

Updated comparison of Crystal Reports viewers (2016)

Sat, 24 Sep 2016 13:20:34 +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. […]

Field is in use? The last resort

Mon, 19 Sep 2016 12:53:54 +0000

I wrote two posts last month about finding where a field is used. I got to test these methods recently while helping a customer clean up a report. There were a handful of formulas shown as “in use” that we needed to delete. So I thought this would make a good demo of the new […]

Deleting all unused formulas at once

Fri, 16 Sep 2016 12:03:24 +0000

Sometimes when overhauling a report I will have a long list of formulas with many of them no longer needed. You can tell which formulas CR is actually using by the check mark next to each field in the Field Explorer. You can delete these unused formulas individually. If there are groups of them listed […]

Mixing (AND and OR) or (AND and IF THEN ELSE)

Fri, 09 Sep 2016 13:39:40 +0000

One common problem, especially in selection formulas, is when you have both AND and OR but no parentheses to clarify which should come first.   Take the following example: {Orders.Order Amount} > 5000 and {Customer.Country} <> "USA" or {Customer.Region} = "CA" If there is a CA order for $2,500, will it meet the criteria?  Using the […]


Sun, 28 Aug 2016 02:44:39 +0000

When I first started this blog I wondered how long it would be before I ran out of things to write about. The Internet is littered with abandoned blogs. But this month marks 10 full years of The Crystal Reports Underground. And, next month marks 15 full years of my newsletter. Thanks for reading! If […]

A very old way to find where a field is in use

Tue, 23 Aug 2016 04:16:27 +0000

Sometimes the location of a formula can change the way things work, especially with variables. So I sometimes spend a few minutes trying to find where a formula was placed within a crowded report. My last resort has been to export the report to a “Report Definition” file and then do a text search for […]

More ways to find where a field is in use

Tue, 23 Aug 2016 02:50:17 +0000

Since CR 2008(v12) we have been able to right-click on a field and check to see if it is used in any formula in the report. This is helpful if you are trying to delete a formula or drop a table from the report. It lets you see where the field is used and modify […]