Report Information
Version: 11.0
Author: Copyright © 2004 Business Objects
Comments: The balance Sheet describes the financial position of a company by listing the types and dollar amounts of assets, liabilities and equity of a business. The income statement shows whether the business earned a profit.
Title: Combination Balance Sheet and Income Statement
Printer: Unknown/Not Set
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: 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} : Date
{Journal_Entry.Amount} : Number
{Journal_Entry.Debit Or Credit} : String[22]
Table Links
Joins: [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.Date} <= {?End Date}
Record Sorting
Sort By: Account_Type.Account Type -- Original Order Group #1
Account.Account Name -- Ascending Order Group #2
Formula Fields
Field: YTD_liability_and_equity_ balance
Formula: if {Account_Type.Account Type} in ['Equity','Liability'] then
(
if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1
)
else
(
{Journal_Entry.Amount}
)
)
Field: YTD_balance_check
Formula: {@YTD_total_L_and_E_balance_and_current_earnings} + Sum ({@YTD_total_assets})
Field: YTD_total_L_and_E_balance_and_current_earnings
Formula: Sum ({@YTD_liability_and_equity_ balance}) + Sum ({@YTD_net_income})
Field: YTD_balance
Formula: if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1
)
else
(
{Journal_Entry.Amount}
)
Field: YTD_total_assets
Formula: if {Account_Type.Account Type} = 'Asset' then
(
if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1
)
else
(
{Journal_Entry.Amount}
)
)
Field: YTD_net_income
Formula: if {Account_Type.Account Type} in ['Revenue','Expense'] then
(
if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1
)
else
(
{Journal_Entry.Amount}
)
)
Field: type_total_heading
Formula: if {Account_Type.Account Type} = 'Asset' then
"Total Assets"
else if {Account_Type.Account Type} = 'Liability' then
"Total Liabilities"
else
"Total Equity"
Summary Fields
Field: YTD_balance
Formula: Sum ({@YTD_balance}, {Account.Account Name})
Field: YTD_balance
Formula: Sum ({@YTD_balance}, {Account_Type.Account Type})
Field: YTD_total_assets
Formula: Sum ({@YTD_total_assets})
Field: YTD_liability_and_equity_ balance
Formula: Sum ({@YTD_liability_and_equity_ balance})
Field: YTD_net_income
Formula: Sum ({@YTD_net_income})
Page Header
Section: Section a
Fields
Field: PrintDate1
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
Text Fields
Text Field: Text7
Text: YTD
Text Field: Text1
Text: Balance Sheet
Text Field: Text3
Text: Xtreme Mountain Bikes
Text Field: Text13
Text: For the Months Ending {?End Date}
Text Field: Text12
Text: Balance Sheet
Text Field: Text5
Text: How to create a Balance Sheet
Pictures
Picture: RO_Xtreme_Logo
Size: 279x111
Hyperlink: http://www.businessobjects.com
Boxes
Box: Box1
Ends in Section: Section2
Size: 416x19
Line Type: Single
Line Thickness: 20
Lines
Line: Line1
Ends in Section: Section2
Line Type: Single
Line Thickness: 30
Line: Line4
Ends in Section: Section2
Line Type: Single
Line Thickness: 30
Groups
Group: Group #1
Grouped By: {Account_Type.Account Type}
Group Header
Section: Section a
Conditional Formulas
Condition: EnableSuppress
Formula: {Account_Type.Account Type} in ['Revenue','Expense']
Fields
Field: GroupNameAccountTypeID1
Data Source: GroupName ({Account_Type.Account Type})
Data Type: String
Group Footer
Section: Section a
Conditional Formulas
Condition: EnableSuppress
Formula: {Account_Type.Account Type} in ['Revenue','Expense']
Fields
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.
Field: typeheading1
Data Source: {@type_total_heading}
Data Type: String
Group: Group #2
Grouped By: {Account.Account Name}
Group Header
Section: Section a
Fields
Field: GroupNameAccountNumber1
Data Source: GroupName ({Account.Account Name})
Data Type: String
Group Footer
Section: Section a
Fields
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: YTDliabilityandequitybalance1
Data Source: {@YTD_liability_and_equity_ 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: YTDbalance1
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.
Field: YTDtotalassets1
Data Source: {@YTD_total_assets}
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: YTDnetincome1
Data Source: {@YTD_net_income}
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: Field10
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: Text9
Text: Business Objects Technical Support Site
Hyperlink: http://support.businessobjects.com
Text Field: Text11
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@businessobjects.com
Text Field: Text10
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.
Pictures
Picture: Picture2
Size: 150x40
Hyperlink: http://www.businessobjects.com
Report Footer
Section: Section a
Fields
Field: SumofYTDliabilityandequitybalance1
Data Source: Sum ({@YTD_liability_and_equity_ 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: SumofYTDnetincome1
Data Source: Sum ({@YTD_net_income})
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: YTDtotalLandEbalanceandcurrentearnings1
Data Source: {@YTD_total_L_and_E_balance_and_current_earnings}
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: SumofYTDtotalassets1
Data Source: Sum ({@YTD_total_assets})
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: YTDbalancecheck1
Data Source: {@YTD_balance_check}
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: Text2
Text: Total Liabilities and Equity
Text Field: Text8
Text: Balance Check
Text Field: Text14
Text: + Current Earnings (Net Income)
SubReports
SubReport: Income Statement.rpt
Links: {?End Date} => {?Pm-?End Date}
Subreport: Income Statement.rpt
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: Pm-?End Date
Data Type: DateTime
Description: Pm-?End Date
List Type: Static
Tables
Table: Account
Connection: Connection #1
Used Columns: {Account.Account Number} : String[18]
{Account.Account Heading 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: Account Heading
Connection: Connection #1
Report Alias: Account_Heading
Used Columns: {Account_Heading.Account Heading Name} : String[102]
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]
Account INNER JOIN [Account Type] Account_Type ON Account.[Account Type ID] = Account_Type.[Account Type ID]
Account INNER JOIN [Journal Entry] Journal_Entry ON Account.[Account Number] = Journal_Entry.[Account Number]
Account INNER JOIN [Account Heading] Account_Heading ON Account.[Account Heading Number] = Account_Heading.[Account Heading Number]
Record Selection Formulas
Formula: {Account_Type.Account Type} in ["Expense", "Revenue"] and
{Journal_Entry.Date} <= {?Pm-?End Date} and
{Journal_Entry.Date} >= DateSerial(year( {?Pm-?End Date}),1,1) and
{Journal_Entry_Type.Journal Entry Type} <> "closing entries"
Record Sorting
Sort By: Account_Type.Account Type -- Descending Order Group #1
Account_Heading.Account Heading Name -- Ascending Order Group #2
Account.Account Name -- Ascending Order Group #3
Formula Fields
Field: YTD_balance
Formula: if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1
)
else
(
{Journal_Entry.Amount};
)
Field: month_balance
Formula: if month({Journal_Entry.Date}) = month({?Pm-?End Date}) then
(
if {Journal_Entry.Debit Or Credit} = 'Credit' then
(
{Journal_Entry.Amount} * -1
)
else
(
{Journal_Entry.Amount}
)
)
Field: type_heading
Formula: if GroupName ({Account_Type.Account Type})= 'Revenue' then
"Net Sales"
else
"Total Expenses"
Field: month
Formula: MonthName(month({?Pm-?End Date}))
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})
Report 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: Text1
Text: Income Statement
Text Field: Text2
Text: How to Create an Income Statement
Text Field: Text3
Text: Xtreme Mountain Bikes
Text Field: Text5
Text: For the Months Ending {?Pm-?End Date}
Text Field: Text4
Text: Income Statement
Text Field: Text9
Text: YTD
Pictures
Picture: RO_Xtreme_Logo
Size: 279x111
Hyperlink: http://www.businessobjects.com
Boxes
Box: Box1
Ends in Section: ReportHeaderSection1
Size: 416x19
Line Type: Single
Line Thickness: 20
Lines
Line: Line1
Ends in Section: ReportHeaderSection1
Line Type: Single
Line Thickness: 30
Line: Line4
Ends in Section: ReportHeaderSection1
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: typeheading1
Data Source: {@type_heading}
Data Type: String
Field: Sumofmonthbalance3
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: SumofYTDbalance3
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: True
Number Style: $(5,555,555).
Group: Group #2
Grouped By: {Account_Heading.Account Heading Name}
Group Header
Section: Section a
Fields
Field: GroupNameAccountHeadingName1
Data Source: GroupName ({Account_Heading.Account Heading Name})
Data Type: String
Group: Group #3
Grouped By: {Account.Account Name}
Group Footer
Section: Section a
Fields
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: True
Number Style: $(5,555,555).
Field: GroupNameAccountName1
Data Source: GroupName ({Account.Account Name})
Data Type: String
Detail
Section: Section a
Fields
Field: monthbalance1
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: YTDbalance1
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.
Report Footer
Section: Section a
Fields
Field: SumofYTDbalance2
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: True
Number Style: $(5,555,555).
Field: Sumofmonthbalance2
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: True
Number Style: $(5,555,555).
Text Fields
Text Field: Text18
Text: Net Income
Section: Section b
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: Text8
Text: Business Objects Technical Support Site
Hyperlink: http://support.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: Text6
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@businessobjects.com
Pictures
Picture: Picture3
Size: 150x40
Hyperlink: http://www.businessobjects.com
Lines
Line: Line3
Ends in Section: ReportFooterSection2
Line Type: Single
Line Thickness: 30