Archive for April, 2009
One of my readers tipped me off to a web site that has a handy Crystal Reports DLL that you can download for free. This DLL adds several custom functions to your formula editor that allow your formulas to do all sorts of new things (and some I don’t recommend that you try).
There are about 40 functions in the DLL that allow your formulas to interact with the operating system. Here are some examples: Continue Reading »
Handy custom functions in a free DLL
I recently finished updating the three volumes of my Expert Techniques guides and turned my attention to the The Expert’s Guide to Crystal Reports Formulas. I found a handful of improvements to make and decided to include two new functions that I find myself using more and more. They are Split() and DrillDownGroupLevel.
I have sent the update to those of you who purchased this volume in April 2009. If you purchased this guide in an earlier month, please let me know (along with the Email address that you used) and I will send you the update link.
This article isn’t about Crystal Reports, but instead is for all of you who are doing your taxes this week. I have a simple exercise you can do while you have your tax forms out. And then the next time you read about a federal outlay in the billions or trillions, you will be able to calculate your exact share as easily as calculating a tip on a dinner check.
All you need to know is how much your tax bill was for last year. It doesn’t matter if you got a refund or had to Continue Reading »
Calculate your share of a billion dollar expenditure
For those of you who have been putting off making that pornographic film featuring Crystal Reports, you had better do it before you upgrade to Crystal Reports 2008 Release 2. After that point you will be restricted from using Crystal Reports images in your pornography. You don’t believe me? Well read the new license for yourself. SAP has told several of my readers that the license for Eclipse is identical to the one for CR 2008 R2. (The page says “Log-in required” but at least today it works without a log-in.) Read the restrictions in section 4.3 item b). If the first ‘license’ link moves, use the link on the ‘Eclipse’ page.
Besides restricting your cinematic options, the part most of you should be complaining about is section 4.3 item a). As I mentioned in my earlier post, this is aimed directly at removing the last independent courseware vendor, Vision Harvest, from the market. If Vision Harvest stops producing Crystal Reports course books, and if everyone else becomes convinced that they have to get SAP’s permission to use their screenshots, then SAP will be able to charge any fee they want for the “right” to publish a coursebook. I predict course books costing $150 -$200 per book, if they succeed.
It will surprise some of you to learn that this license change has no direct effect on me at all. As many of you know, I have never used screenshots in my materials. My concern is that this hidden attempt to fleece users will backfire and damage the Crystal Reports brand in the long term. So do yourself a favor and let the folks at SAP/BO know what you think before this license takes affect. Send an Email to Beth Christopher (first name , period, last name @SAP.com).
And if you do make that film let me know.
Here is a technique I have named the “wormhole”, because it lets Crystal go back in time. It allows you to take one or several database values from the last record of a report, and then display them or use them in formulas that occur earlier in the report. Likewise, it can take the last record of a group and print it’s values anywhere in the group, including the group header. Variables can’t do this because they can only be used ‘downstream’, and subreports can slow things down significantly, so this method has some advantages. Your report must be sorted, and the values you want to move have to be database values or formulas that can be totaled. Unfortunately, PrintTime formulas can’t be moved using this method. For that you would need a subreport.
Lets say that you have 300 orders sorted by a DateTime field in ascending order. You are not allowed to change the sort of the report. But, you need to start the first page of the report with the Date, Amount and Shipping method of the last order on the last page:
First you create the WormHole formula. You do this by Continue Reading »
Moving values backward in a report