BOFocus – Crystal Reports Tips – Tricks – Tutorials

Tag Archives

Display parameter values that where chosen at run time

For string parameters with multiple discrete values: Join(@Your_Parameter, chr(10) & chr(13)); For non-string parameters with multiple..

April 4, 2012 with 0 Comments

Display yesterday date

The following formula, when inserted into your report will display the previous day’s date. 1. Create the following formula and..

April 3, 2012 with 0 Comments

Display only the report file name on the report

1. Create the following formula and place in the report footer: StringVar Array File := Split(filename,”); NumberVar i :=..

April 3, 2012 with 0 Comments

Display every nth record

Create following formula within the Section Expert. Formula: Remainder((recordnumber),25) <> 0; To apply this formula in the Section..

April 3, 2012 with 0 Comments

Display a person’s full name and title correctly

if you happen to have a database where the columns/fields separate our a person’s name into individual fields, the following formula..

April 3, 2012 with 0 Comments

GET SOCIAL

QUICK TIP

Count should be used whenever you want to know the number of records that have the same information.

Distinct Count should be used whenever you want to know the number of records where the records are unique or different.

ADVERTISMENT