George Jensen’s Blog

George Jensen on Reporting, Business Intelligence, Crystal Reports, Visual Analyzer, and more.

Using an Array – SQL vs Crystal.

In data, an Array is used to store multiple values in a single variable.  I often use Arrays to qualify records for the query I am working on in either SQL or Crystal. The problem is the Arrays are formatted differently in each environment and if you are like me, it can be difficult remembering […]

Using a Test Plan

So you have approved the Statement of Work (SOW) for some modifications and are awaiting the delivery of the bundles from Customer FX. The next item you should be working on is a solid test plan. There are several ways to create a test plan and my intent is not to guide you onto any […]

What Do We Do With Those Backup Database Files?

When working with the team at Customer FX, more often than not we are going to ask for a current back copy of your production system and I hope this blog will help you understand why. Using a recent version of the database lowers the risk of Customer FX overwriting any customizations that you have […]

SalesLogix Web Form Designer

New to the Sage SalesLogix v8.0 Web Client is the Web Form Designer. This tool will allow a user, with a proper role assignment, the ability to modify main entity forms in the the web client using existing database fields. Here is a quick introduction to the tool from Customer FX. For this demo I […]

Working with the Picture Object in Crystal

We have had several inquires lately on how to dynamically change images in a report based on report data.   For example you have pictures of products that you want to display in a report.  One way to accomplish this is to add an image with each product in a huge segmented report and have Crystal sort things out through suppression rules.  This […]

CFX Reports Are Updated

I am very happy to back after 19 months of Military leave.  One of my first tasks upon returning to my desk was to clean up my Customer FX email inbox that was full with a about 4,000 new emails, mostly automatic notifications from various resources.  What surprised me the most was the number of download notifications from which […]

Supressing the blank page after “New Page After” Group Footer setting

I've worked with Crystal for some time, but there's always been one little thing that sort of bothered me, and I had never took the time to figure out how to deal with it. If you have a group in your report, and want to start a new page after each grouping, you end up with a blank page at the end of the report. To get rid of this blank page, all you need to do is to add a simple script to the New Page After property of the group footer:

Setting custom date ranges in Crystal

Recently, I had to develop a report which was to return data within a particular date range. Specifically, a user would need to select a date and the report would then return data from a range of Monday of the previous week to Friday of the current week. I was able to accomplish this fairly easily using Global and Local variables and a couple of different date functions.

Leveling out Users Data.

I am four posts into building a drill down report using Sage SalesLogix Visual Analyzer and Dashboard as a my guide.  This series of post starts with a post labeled “Updating the Managed Quota Area for Sage SalesLogix” , if you follow the links on each post you will eventually end up back on this post. In the last […]

Writing the User – Quota vs Actual Crystal Report.

Over the last three posts we have updated the Quota’s are of Sage SalesLogix, we have built SQL views to collect both the Quota data and the Actual Numbers for comparison.  Now we will start writing our report.  I am not going into to much detail on layout.  My goal is to walk you through the common steps: connecting to the […]

Crystal Connection through the SalesLogix OLE DB Provider

The first step in creating a report in Business Object Crystal Reports is always the connection to the database.  In a post labeled “Report Database Connections”, I discuss one method of making a connection to a SQL database.  That post will lead you through how to make the connection using the Microsoft OLE DB Provider for SQL Server using the […]

Gathering the Actual Numbers for Reporting Comparison

I have just started writing a series of posts that will lead the reader of this blog through the creation of a report with the same kind of data break down as you see in the standard Sage SalesLogix Visual Analyzer and the Sage SalesLogix Dash Board.  In the first week I provided a method to effectively establishing quotas […]

Gathering User Quotas for Reporting

If you read last weeks post, you will know I am setting up to build a user based report that will give the reader a lot of the same data you see in the standard Sage SalesLogix Visual Analyzer and the Sage SalesLogix Dash Board.  Last week I provided you the ability to effectively set goals for your users by […]

Updating the Managed Quota Area for Sage SalesLogix

Often, when discussing reporting issues with clients I will bring up the Quota’s area of Sage SalesLogix.  If you do not know where this functionality is located, go to your Tools/Manage/Quota menu and the following screen will appear. On the upper pane you find a place to list the users you want to set a quota […]

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!