Overview


Purpose

Cyrious utilizes a third-party reporting engine known as Crystal Reports for the majority of reports that area available within Control. Crystal Reports is a publicly available and can be purchased directly from many online vendors or directly from SAP. If you wish to create your own reports and have them accessible within Control you will need to utilize Crystal Reports for this task.

Technology Requirements

  • Control requires Crystal Reports XI or later.
  • SMS requires Crystal Reports 8.5. No other versions are supported with SMS.

General Interface Design

Fonts

Some font types are not supported by all of Crystal Reports embedded dll's that export from Crystal Reports into pdf, excel, word, etc. formats. Because of this it is recommended that you stick with the Arial font type if you plan to save into pdf format.

Page Size (A4 v Letter)

Control is used in countries that employ both Imperial and Metric units. With a few careful considerations, the same reports can be designed to operate in both regions without conflict.
The standard paper size for Imperial-unit countries is called "Letter". It is 8.5 inches x 11 inches. The standard paper size for metric-unit countries is called A4. It is 210.06 mm x 296.93 mm, or 8.27 inches x 11.69 inches.
As the sizes indicate, A4 paper is a bit narrower but longer than Letter sized paper. For this reason, if you keep two rules in mind the reports you design will work for both systems.

Portrait Reports should be designed for A4 paper. This prevents the right side from being chopped off internationally.
Landscape Reports should be designed for Letter-sized paper.

This arrangement prevents the right side from being chopped off or incorrectly aligned.

Translation Issues

If translation is enabled, Control attempts to translate the Crystal Report prior to its generation. The following types of fields are translated:
Text Objects (Labels, Memos)

No data fields are translated, nor are any formula values. Care should be taken to place all translated information on the screen via text objects. If conditional information must be displayed, the report will have to be customized or, in some cases, multiple labels may be placed on the form and only the correct one displayed (not suppressed).


SubReports

  • Change the font color to "Blue" in the sub-report options. This makes it easy to see which fields on a report are subreports and which are not. This is only the font color of the actual subreport and not the fonts of those fields inside the subreport.
  • Ensure the subreport option "Re-import When Opening" is unchecked if possible. Sometimes this option will be checked in a grayed-out/disabled state. If this occurs you will not be able to uncheck it. Having this option enabled increases the initial load time of the report from when you click the report in the Control report menu until you get the screen where you can set the options of the report or click preview/print/email/save. It does not actually impact the execution time of the time.


Parameters


Using parameters to Give Users Choice

When a user chooses the open a Crystal Report from within a Cyrious application (Control, SMS), Cyrious initially scans the report to determine which parameters the report uses. It then dynamically builds a print menu to provide the user with a list of those choices.

In order to change the options provided to the user, the Crystal Reports programmer needs to add (and use) the parameters within Crystal Reports. The resulting behaviour in Cyrious is then automatic.

Standard parameter Types supported

The following types of parameters are supported in Cyrious:

Checkbox Parameters
Text Parameters
Selection List Parameters
Date Parameters
Date Range Parameters
Numeric Parameters



Special parameters

Order Number Parameter
Estimate Number Parameter
Account ID (Customer) Parameter
Division ID Parameter
Range Parameters in Commands

Naming Convention


Special Processing


Logo Resizing


See Also