Subscribe: The Crystal Reports Underground
Added By: Feedage Forager Feedage Grade A rated
Language: English
crystal reports  crystal  field  find  formula  formulas  management utilities  month  related commands  report  reports  rpt management  rpt 
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: Sat, 24 Sep 2016 13:21:52 +0000


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

Adding a ratio calculation to a cross-tab

Wed, 17 Aug 2016 02:42:48 +0000

Twice in the past 2 weeks I have had to take two different summary fields in a cross-tab and calculate a ratio of one to the other.  The most common example would be when one summary is “Sales” and the other is “Cost of Goods” and you want to calculate a Gross Profit Percent from […]

Questions related to commands

Thu, 11 Aug 2016 03:56:55 +0000

I answered two questions this week related to commands and thought the answers would make a good blog post. 1) Is it bad to link a command to other tables using the Database Expert? In general it is more efficient to build all of the tables into the command when possible. This allows the database […]

RPT management utilities for 2016

Wed, 27 Jul 2016 03:51:47 +0000

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