Report Information
Version: 11.0
Author: Business Objects
Comments: The Trial balance report can be created as a way to test your account balances, to make sure that they balance.
Title: Trial Balance
Printer: No Printer
Main Body
Data Sources
Source: Connection #1
Database DLL: crdb_odbc.dll
Database Type: ODBC (RDO)
Server: Xtreme Sample Database 11.5
Properties: QE_LogonProperties
DSN: Xtreme Sample Database 11.5
UseDSNProperties: False
QE_SQLDB: True
SSO Enabled: False
Report Parameters
Parameter: End Date
Data Type: DateTime
Description: Enter End Date:
List Type: Static
Default Values: 2005-01-31 12:00:00 AM
Tables
Table: Account
Connection: Connection #1
Used Columns: {Account.Account Number} : String[18]
{Account.Account Type ID} : Number
{Account.Account Name} : String[102]
Table: Account Type
Connection: Connection #1
Report Alias: Account_Type
Used Columns: {Account_Type.Account Type} : String[42]
Table: Journal Entry
Connection: Connection #1
Report Alias: Journal_Entry
Used Columns: {Journal_Entry.Date} : DateTime
{Journal_Entry.Amount} : Number
{Journal_Entry.Debit Or Credit} : String[22]
Table: Journal Entry Type
Connection: Connection #1
Report Alias: Journal_Entry_Type
Used Columns: {Journal_Entry_Type.Journal Entry Type} : String[102]
Table Links
Joins: [Journal Entry Type] Journal_Entry_Type INNER JOIN [Journal Entry] Journal_Entry ON Journal_Entry_Type.[Journal Entry Type ID] = Journal_Entry.[Journal Entry Type ID]
[Journal Entry] Journal_Entry INNER JOIN Account ON Journal_Entry.[Account Number] = Account.[Account Number]
Account INNER JOIN [Account Type] Account_Type ON Account.[Account Type ID] = Account_Type.[Account Type ID]
Record Selection Formulas
Formula: {Journal_Entry_Type.Journal Entry Type} <> "closing entries" and
{Journal_Entry.Date} <= {?End Date} and
{Journal_Entry.Date} >= dateserial(year({?End Date}),1,1)
Record Sorting
Sort By: Account_Type.Account Type -- Original Order Group #1
Account.Account Name -- Ascending Order Group #2
Formula Fields
Field: month
Formula: MonthName (Month ({?End Date}))
Field: month_balance
Formula: if month({Journal_Entry.Date}) = month({?End Date}) then
(
if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1;
)
else
(
{Journal_Entry.Amount};
)
)
Field: YTD_balance
Formula: if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1;
)
else
(
{Journal_Entry.Amount};
)
Summary Fields
Field: month_balance
Formula: Sum ({@month_balance}, {Account.Account Name})
Field: YTD_balance
Formula: Sum ({@YTD_balance}, {Account.Account Name})
Field: month_balance
Formula: Sum ({@month_balance}, {Account_Type.Account Type})
Field: YTD_balance
Formula: Sum ({@YTD_balance}, {Account_Type.Account Type})
Field: month_balance
Formula: Sum ({@month_balance})
Field: YTD_balance
Formula: Sum ({@YTD_balance})
Page Header
Section: Section a
Fields
Field: PrintDate2
Data Source: PrintDate
Data Type: Date
Format: Date and Time
Order: Date Time
Date Type: System Default
Date Format: YYYY-MM-DD hh:mm:ss AM
Field: PrintTime1
Data Source: PrintTime
Data Type: Time
Format: Date and Time
Order: Date Time
Date Type: System Default
Time Format: MM/DD/YY h:mm:ss AM
Field: month1
Data Source: {@month}
Data Type: String
Text Fields
Text Field: Text3
Text: Xtreme Mountain Bikes
Text Field: Text4
Text: Trial Balance
Text Field: Text9
Text: YTD
Text Field: Text10
Text: For the Months Ending {?End Date}
Text Field: Text1
Text: Trial Balance
Text Field: Text2
Text: How to Create a Trial Balance
Pictures
Picture: RO_Xtreme_Logo
Size: 279x112
Hyperlink: http://www.businessobjects.com
Boxes
Box: Box1
Ends in Section: PageHeaderSection1
Size: 416x19
Line Type: Single
Line Thickness: 20
Lines
Line: Line1
Ends in Section: PageHeaderSection1
Line Type: Single
Line Thickness: 30
Line: Line4
Ends in Section: PageHeaderSection1
Line Type: Single
Line Thickness: 30
Groups
Group: Group #1
Grouped By: {Account_Type.Account Type}
Group Header
Section: Section a
Fields
Field: GroupNameAccountType1
Data Source: GroupName ({Account_Type.Account Type})
Data Type: String
Group Footer
Section: Section a
Fields
Field: Sumofmonthbalance2
Data Source: Sum ({@month_balance}, {Account_Type.Account Type})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Field: SumofYTDbalance2
Data Source: Sum ({@YTD_balance}, {Account_Type.Account Type})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Text Fields
Text Field: Text5
Text: Total GroupName ({Account_Type.Account Type})
Group: Group #2
Grouped By: {Account.Account Name}
Group Footer
Section: Section a
Fields
Field: GroupNameAccountNumber1
Data Source: GroupName ({Account.Account Name})
Data Type: String
Field: Sumofmonthbalance1
Data Source: Sum ({@month_balance}, {Account.Account Name})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Field: SumofYTDbalance1
Data Source: Sum ({@YTD_balance}, {Account.Account Name})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Detail
Section: Section a
Fields
Field: monthaccountbalance1
Data Source: {@month_balance}
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Field: YTDaccountbalance1
Data Source: {@YTD_balance}
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Page Footer
Section: Section a
Fields
Field: PageNumber1
Data Source: PageNumber
Data Type: Number
Format: Number
Currency Symbol: None
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: -5,555,555
Text Fields
Text Field: Text6
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@businessobjects.com
Text Field: Text7
Text: Copyright 2004 Business Objects Software Limited. All rights reserved. Business Objects, the Business Objects logo, Crystal Reports, Crystal Enterprise, Crystal Analysis, WebIntelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects and its affiliates in the United States and/or other countries. Other trademarks are the property of their respective owners. Business Objects owns the following U.S. patents, which may cover products that are offered and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and 6,289,352.
Text Field: Text8
Text: Business Objects Technical Support Site
Hyperlink: http://support.businessobjects.com
Pictures
Picture: Picture3
Size: 150x40
Hyperlink: http://www.businessobjects.com
Lines
Line: Line3
Ends in Section: PageFooterSection1
Line Type: Single
Line Thickness: 30
Report Footer
Section: Section a
Fields
Field: SumofYTDbalance3
Data Source: Sum ({@YTD_balance})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Field: Sumofmonthbalance3
Data Source: Sum ({@month_balance})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Text Fields
Text Field: Text14
Text: Balance Check