Crystal Calendar for Crystal Reports

Crystal Calendar for Crystal Reports

Crystal Calendar for Crystal Reports

Price: $199.99

Quantity in Cart: None


Summary

For Crystal Reports 8.5 and later, Crystal Calendar is a fast, simple way to generate a set of records based on a date or time, or as a series of numbers.

Why Buy

Sometimes you need a table of dates in your report, or a set of numbers to generate labels or as a record multiplier. This product gives you the ability to do that.

Key Facts

  • Works with Crystal reports 8.5 and later.
  • Requires the COM data driver. This may require an additional install.
  • Fast and easy to add to your reports.

Operation

Inside Crystal Reports, create a new report or subreport that uses a COM data source. Select COM connectivity.

The Screen Shots are from Crystal Reports 2008. If you are using a different version, the COM driver might be listed slightly differently.

Crystal calendar info shot 1

Click Image to Enlarge

Tables

If you select Date Table, you will get the following parameter screen. Enter values for all the parameters as follows:

StartDate – The first start date/time in the series of records. Although the screen shot is in European format, if you use US formatted dates you will be instructed to enter the dates in that format.

EndDate – Enter the final date/time in the series of records. If this date is prior to the Start Date, then you will only get one record in your record set. If you require a descending sequence of records, enter the dates with a StartDate before the EndDate and then use the Record Sort Expert inside the report designer to sort the records after they are generated by CrystalCalendar.

Crystal calendar info shot 2

Click Image to Enlarge



Frequency – Enter a valid frequency for the values. The following frequencies are supported (if you require other frequencies let us know and we may add that in a future release): D for Daily, M for Monthly, H for Hourly.

Step – Enter a multiplier for the frequency. For example, a frequency of H and a step of two will create records with 2 hour intervals.

LicenseCode – If you are using a trial version, then leave this blank. On purchase we will send you an activation code that removes the trial version limitations.


 
Crystal calendar info shot 3

Click Image to Enlarge

If you select Integer Table, you will get the following parameter screen. Enter values for all the parameters as follows:

StartInteger – The first number in the series of records.

EndInteger – Enter the final number in the series of records. If this value is prior to the Start Integer, then you will only get one record in your record set. If you require a descending sequence of records, enter the dates with a StartInteger before the EndInteger and then use the Record Sort Expert inside the report designer to sort the records after they are generated by CrystalCalendar.

Step – Enter a multiplier for the frequency. For example, a step of 10 will create records with 10 as the value between each record.

LicenseCode – If you are using a trial version, then leave this blank. On purchase, we will send you an activation code that removes the trial version limitations.
Crystal calendar info shot 4

Click Image to Enlarge

Installation

Run the CrystalCalendar setup script.  This will load and Register the CrystalCalendar data source. The default folder is c:\Program Files\CrystalKiwi\CrystalCalendar but you can change this if you wish.

In that folder are the license, readme files (as Rich Text), and the instruction document (as a PDF).

Free Trial

The trial version has two limitations:

  1. The Trial version has a limit of ten records in the table generated by CrystalCalendar. The full version can generate thousands of records if you need.
  2. The Trial version will expire 30 days after you install it.
Customer Reviews
Average Customer Review: Not yet rated
Write an online review and share your thoughts with others.

There are no reviews