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..
Crystal Reports – Formulas
Using the picture function
The Picture Function can be used within a formula to print a string “2065555555″ in a telephone number format “(206)..
Shading every other line of the detail section
To shade every other line of the detail section of the report 1. Start by opening up the Section Expert by clicking on Go to Report,..
Repeating Group Headers
In Crystal Reports there is a feature to force group headers to repeat on each page. This can be done by checking the box next to..
Print “Cointinued on Next Page”
When a group will go beyond one page, you can print a messageat the bottom of the page using the following three formulas: 1. Open the..
Print a checkbox / bullet for a boolean column
Within Crystal Reports, you simply cannot create a checkbox for Boolean operators. WIth the use of a formula and the Wing Ding font, this..
Add page numbers
If you would like to have your page number start with a high number, the following formula with accomplish this task. The following formula..
Listing employees length of service in months
The end result to the following formula will show the the length of service in months for an employee. 1. Create the following formulas and..
Limit the number of records per page
Create the following formula and place in the page header: WhilePrintingRecords; NumberVar counter := 0 Create the following formula and..
Finding the first friday of the month
Create the following formula and place in the detail section, the results wil return the first Friday of the month: WhileReadingRecords;..
RECENT COMMENTS
View Post
View Post
View Post
View Post
View Post