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

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