Webucator's Blog

|

Crystal Reports: Using the Highlighting Expert

Have you ever used the Highlighting Expert in Crystal Reports? Chances are your response is no, and you are wondering what it is. The Highlighting Expert is a button on the Experts Toolbar. The button looks like this: .

The Highlighting Expert is also on the shortcut menu of the right-click. Once you choose this Expert, this dialog box opens: Continue Reading »

|

Crystal Reports Drill Down

Drill Down is one of the great features in Crystal Reports.  You have to group the report and hide the Detail Section. Now only the Group Names (the Group Header) are showing with any Summary information in the Group Footer. Double clicking on a Group Name generates a separate tab and a sheet will be created on only that Group. Continue Reading »

|

Report Distribution Options in Crystal Reports

There are various ways you can distribute the reports you designed in Crystal Reports even if you aren’t using Crystal Reports Server or any other Enterprise Servers. Some of the ways are the old standby methods such as PDF and MSWord. These methods work fine, as they definitively meet the needs of the organizations report readers. Continue Reading »

|

Changing Default Field Settings in Crystal Reports

When you design your reports in Crystal Reports, Crystal Reports uses the database format for the database fields.  It also uses the database fonts as I discussed in Setting Default Fonts in Crystal Reports. This, again, requires that you format these fields every time you want to use them in you report.

I recommend you take the time upfront to change these default settings in Crystal Report so that you won’t have to change the settings on each new report you create. Here’s how you change the default field settings in Crystal Reports: Continue Reading »

|

Crystal Reports Rounding Function

Formatting using the Rounding Function

In general, Crystal Reports users set up the default formatting to display the data in the way it is to be used most often. However, when it is necessary to be able to switch quickly to another format – right-clicking to format the field is usually the solution.

If the data field comes down to Crystal Reports with several decimal points, one solution would be to use the remove decimal places button on the tool formatting bar. That button actually rounds up on decimal place numbers greater than 5 and rounds down on decimal place numbers less than 5.

If that data is included in a formula, the Round function could be used on the number to be formatted. To give the report designer more control there are actually two functions for rounding numbers: Round and RoundUp. Each of these rounding functions have two sub-functions, which we will see below. Continue Reading »

|

Setting Default Fonts in Crystal Reports

Tired of constantly formatting your fields in Crystal Reports?  Frustrated because you  have to do it for every report?  Crystal Reports uses default fonts provided in the database and they are not usually what you would consider attractive for your report.  You can change the default fonts so that when you design a new report, Crystal will use your preferred fonts in the new report. Continue Reading »

|

Xcelsius and the Object Browser

The Object Browser

In Xcelsius, the Object Browser is your new best friend.  It stores and displays all of the components that are on the canvas and allows you to hide them and/or lock them into position.  Xcelsius allows you to design a dashboard  by placing components on the canvas.  It adds exciting visualization to Excel data– trends, what-if, projections and much more.

Continue Reading »