BOFocus – Crystal Reports Tips – Tricks – Tutorials

Tag Archives

How to pass a date range to a subreport using a parameter

Displaying data from a subreport based on a date range can be a bit tricky.  Many people choose to simply hardcode the date range within..

April 4, 2012 with 8 Comments

Formatting dates in Crystal Reports

If you place a datetime within your report,  chances are when you place drop it within your report it will be displayed as 11/02/2003..

April 3, 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

Converting numbers to dates

Some applications store dates as eight-digit integer in the following format: YYYYMMDD For example, March 1, 2002 would be stored as..

April 3, 2012 with 0 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

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