Archive for July, 2008



Take my 3-day “Accelerated” class in September

Tuesday 29 July 2008 @ 9:09 pm

My public classes have always been offered as a 2-day Intro or a 2-day Advanced class. In September I am going to see how many students would be interested in taking a 3-day combined class.  This 3-day class, which covers the same material as both of my 4-day public classes, is my most requested class for on-site training, so it may prove popular in the classroom as well. It is ideal for:

1) Self taught students who want advanced material while “filling in the gaps” of their basic training
2) Students who already understand database concepts or have worked with another reporting tool.
3) Student who like a faster pace

This first class is going to be held September 3-5 and will cost $1,720 per student. This costs the same amount as taking the 4-days of my normal class, however the class size will be limited to 3 students. If more than 3 people are interested or if those dates don’t work for some students, I may offer another accelerated class in October.

Drop me a line if you are interested.




CR 2008 parameter features added to the “Experts Guide”

Tuesday 29 July 2008 @ 4:51 pm

Crystal Reports 2008 (v12) has a handful of new features that affect parameters. There is now an Interactive parameters panel that allows the user to change parameter choices interactively, without requiring the user to refresh the data. There are also sort controls that allow the sorting and grouping order to be changed by the user in preview mode.

I have just updated the Expert’s Guide to Subreports, Parameters and Alerts with a short addendum that explains how to use these new features. If you recelty purchased the guide and you are using CR 2008 (v12) drop me a note and I will send you a copy of the addendum at no charge.




Temporarily ignoring the grid and guidelines

Wednesday 23 July 2008 @ 10:48 am

I probably use the “Guidelines” feature of Crystal Reports more than most people. Guidelines are the invisible (or visible) lines that project out from those tabs on the rulers. They are similar to “Snap to Grid” in that you can ‘snap’ objects to these guidelines to keep rows and columns aligned. You can then slide the tabs to adjust the position of the row or column.

The problem comes when you need an object to be close to a guideline but not attached. As soon as you get close to a guideline Crystal wants to snap the object into place. I just rediscovered today that if you hold down your ALT key while you are dragging an object, then the guidelines are no longer “sticky” and the objects won’t try to snap to them. It is as if the guidelines are temporarily removed. And it works for “Snap to Grid” as well, so you can position objects between the dots if needed.

This feature is only available in versions 10 and later.




Updates to Third Party Products

Tuesday 22 July 2008 @ 3:53 pm

As of March, Logicity 1.6 is available. Logicity is a combined viewer and scheduler. It now features CR 2008 compatibility. Logicity has a free version and a paid (supported) version.

As of July, DataLink Viewer 2008 is available.  DataLink Viewer now features CR 2008 compatibility

CR Chart 3.5 is now available.  CR Chart enhances the charting capabilities of Crystal Reports and is made by the folks who create the charting feature for Crystal Reports.  CR Chart 3.5 is CR 2008 compatible and has 30 new macro features to enhance your charts.

As of June Easy View 2.0 is available.  Easy view is a combined viewer and scheduler.  It now supports CRXI along wth several other improvements. It runs $39 for a single copy.

See my LINKS page for more info on these products.




Crystal Reports Server 2008 (& prices)

Monday 21 July 2008 @ 11:31 pm

As I mentioned last month, the promotional price of Crystal Reports Server XI was a clear indication that CR Server 2008 was about to be released. The official release of Crystal Reports Server 2008 came on 7/16 and there is a 30 day free trial now available on the Business Objects web site.

The main improvement Continue Reading »
Crystal Reports Server 2008 (& prices)




Adding Business Hours/Minutes to a Start DateTime

Saturday 12 July 2008 @ 2:34 pm

A customer recently asked me to adapt formula 17 on my site so that they could add business hours or minutes instead of just business days. In their example they wanted to add 90 minutes to a DateTime value when a case was opened. If the DateTime was within 90 minutes of the end of the workday, they wanted to skip time when the shop was closed and pick up the 90 minutes the next business morning. So a case the opened at 4pm on Friday would be due 90 “work minutes” later, at 9:30 am on Monday. They had a 9-5 workday. They also wanted to skip holidays.

So below is my adaptation of formula 17 Continue Reading »
Adding Business Hours/Minutes to a Start DateTime




Crystal Reports Knowledge Base moved to SAP support

Saturday 12 July 2008 @ 2:00 pm

If you are used to searching the Business objects KB for CR technical info you will need to look in a new place. SAP, the new owners of Business objects, has incorporated the BO Support information (including Crystal Reports) into the SAP Support system. All links to the old support pages are forwarded to the new system’s front page, so if you have links to specific documents or KB articles, these will have to be updated.

The new location has forums, a Wiki, and other things that I haven’t really looked at yet. If you check it out and find anything interesting, let me know.

Update – according to this article, it isn’t just the KB that was moved, but the entire BO Support system, (including all support tickets) has been moved. The author of the article says that transition isn’t going very smoothly.




Jeff-Net

Recrystallize Pro

The Expert Series