Crystal Reports Formatting Standards

Page Margins

Top: 0.630
Left: 0.630
Right: 0.50
Bottom: 0.50

Font

Arial, 8pt

Standard Text

Height: 0.15

Logo

Width: 1.125”
Height: 0.750”

Report Title

As wide as possible without overlapping the logo
Centered on Page
Height: 0.260”
Font: Size 16, Blue, Bold

Second Title (if any)

As wide as possible without overlapping the logo
Centered on Page
Height: 0.170”
Font: Size 10, Black, Bold

Other Title (if any)

Height: 0.15”
Font: Size 9, Black

Title on Pages after 1

Line underneath the title: 1/4" under page header

Page Footer

1/4" suppressed box
Report ID: Size 7, Rename object name under the common tab to “ReportID” to prevent from becoming dictionary enabled.
Page Number : Size 7, Centered on page
Page Number Formula: "Page " & Cstr(PageNumber, "0") & " of " &  Cstr(TotalPageCount, "0")
Organization Sub-report: Size 7, space between org name and number

Groups

Main Group/First Group
Section Background Color custom font: Red: 211, Green: 211, blue: 211
Insert section after: ‘suppressed’ box for spacing - Size 0.05”
Column headings within shaded bars: Size 8, Black, Bold
Never: Underline within shaded bars, Underline column headings above shaded bars, Column headings are to display only once on each page at page header.
Group Totals: Single Top Border
Gray Bar: If a group exists, then the group background will be black, with the text being white. The following details sections will alternate between white and color(211,211,211).  Using the following suppression formula for the two details sections:
Remainder({#Counter}, 2) = 0 for section A
Remainder({#Counter}, 2) = 1 for section B

There also must be suppression on the Section Expert -> Color Tab -> Background Color, if there is an option to toggle the Gray Bar on/off.

Report Summaries
Grand Totals:             Single Top Border, Double Bottom Border
Group section with 1 row of data: Suppress Subtotal, Create counter - if count = 1 then suppress subtotal

Sub Report

Sub-report objects are formatted to be green.  The name of the sub-report is Arial size 9 font.

Address Labels

While displaying address information from an account, you need to use the EV870_ADDR_LBL_XX fields within your subreport.  If anyone of the EV870_ADDR_LBL_XX has text in it, it will automatically use these fields.  If they are all blank, then it will use the normal address fields from EV870.

Use the subreports from Standard Subreports to display this information.  There are two variations of this subreport, one with the account and account contact address information, or one just with the account.

CRUFLUS.DLL

Contains standard EBMS formatting functions

Added through the Crystal Formula Editor – located in functions, additional functions, Visual Basic UFL’s

Date Formatting (CRUFLUS.DLL)

EBMSDATE: Converts numeric date to standard date (MM/DD/YYYY)
FORMATSHORTDATE: Gets user settings to display date
FORMATSTARTENDTIMENUM: Formats EBMS standard Date-Time range (dates in numeric format)
FORMATSTARTENDTIMEISO: Formats EBMS standard Date-Time range (dates in ISO format)
FORMATINOUTTIMENUM: Formats EBMS Standard In/Out range (dates in numeric format)
FORMATINOUTTIMEISO: Formats EBMS standard In/Out range (dates in ISO format)

Format Foreign Currency

Number Tab
Decimal Separator: X/2 button, use “GETDECIMAL”
Thousands Separator: X/2 button, use “GETTHOUSANDS”
Currency Symbol Tab
Currency symbols display in all totals and in the first record of each group.
Check: enable currency
X/2 button: if {#Total for Symbol} = 1 then 2 (enables floating symbol) for the first record in the group
Position: $ - 123
Currency Symbol: X/2 Button Drop in currency symbol field from MM020 Table (MM020_CURRENCY_CODES.MM020_SYMBOL)

Note on Formulas

When creating formulas, any text to be displayed should be surrounded by quotes.  Example: “Text:” &  “” & {EV870_NAME}