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

When in the formula editor, Start out by typing the first charter of the function, press Ctrl-Space. The keyword auto complete will than show a list of the functions available beginning with the charter you typed in.

ADVERTISMENT