BOFocus – Crystal Reports Tips – Tricks – Tutorials

Monthly Archives

How to sort data

The Sort Order allows you to organize the records by specified fields. You can sort the report by any of the fields available in the tables..

March 28, 2012 with 0 Comments

Creating your first formula

When creating formula’s within Crystal Reports, the Formula Editor is used.  The Formula Editor provides access to different..

March 28, 2012 with 0 Comments

Creating your first Crystal Report

To create your first Crystal Report, we are going to use the sample Xtreme Acesss database supplied by SAP. If you need a copy, you can..

March 28, 2012 with 0 Comments

Change an image in the Crystal Report at runtime

So, you have created a great report for one department and another department wants the same report, only with their logo and department..

March 27, 2012 with 3 Comments

Calculating the number of working days

The following will calucalate the number of working days between two dates. Simple replace {start_date} & {end_date} with your date..

March 26, 2012 with 0 Comments

Browsing Field Data within Crystal Reports

One of the more useful features of Crystal Reports is being able to browse data by simply right-clicking on the field name from within the..

March 26, 2012 with 0 Comments

Assign a default value or add another value to a dynamic parameter

Crystal Reports – Dynamic Parameters aren’t very dynamic By design, you can cannot assign a default value or add another value to a..

March 26, 2012 with 0 Comments

Age calculation

The following formula will allow you to calculate a person’s age correctly: WhileReadingRecords; DateTimeVar begindate :=..

March 26, 2012 with 2 Comments

Adding a month/day or months/days to a date

Add months, days, years to a date field.  With the dateadd function, you can use any of the interval types listed below to add/subtact a..

March 26, 2012 with 0 Comments

Add a page header to a sub report

There are a couple a large numbers of items I would like to see added to Crystal Reports.. A sub report with a sub report would be..

March 26, 2012 with 1 Comment

GET SOCIAL

QUICK TIP

Use the Chart Sort Order dialog box to sort and group your chart data. This dialog box appears when you click the Order button on the Data tab of the Chart Expert for a chart with the Advanced layout type.

ADVERTISMENT