Report Information
Version: 11.0
Author: Business Objects
Comments: The income statement shows whether the business earned a profit including the budgeted amounts.
Title: Consolidated Income Statement
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: End Date?
List Type: Static
List Values: 2005-02-28 11:05:13 AM
2005-02-28 11:05:39 AM
Default Values: 2005-02-28 11:05:39 AM
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: Command
Connection: Connection #1
SQL Command: SELECT [Amount], [Account Number]
FROM [Monthly Account Budgets]
WHERE Year=Year({?End Date}) and Month = Month({?End Date})
Parameters: End Date
Used Columns: {Command.Amount} : Number
{Command.Account Number} : String[18]
Table: Command_1
Connection: Connection #1
SQL Command: SELECT Sum(Amount) AS Year_Budget, [Account Number]
FROM [Monthly Account Budgets]
WHERE Year=Year({?End Date}) and month <= month({?End Date})
GROUP BY [Account Number];
Parameters: End Date
Used Columns: {Command_1.Year_Budget} : Number
{Command_1.Account Number} : String[18]
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]
Command INNER JOIN Account ON Command.[Account Number] = Account.[Account Number]
Command_1 INNER JOIN Account ON Command_1.[Account Number] = Account.[Account Number]
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_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_Heading.Account Heading Name -- Ascending Order Group #2
Account.Account Name -- Ascending Order Group #3
Formula Fields
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}
)
Field: month
Formula: monthname(month({?End Date}))
Field: month_account_variance
Formula: if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then
(
{Command.Amount} + Sum ({@month_balance}, {Account.Account Name})
)
else
(
{Command.Amount} - Sum ({@month_balance}, {Account.Account Name})
)
Field: YTD_account_variance
Formula: if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then
(
{Command_1.Year_Budget} + Sum ({@YTD_balance}, {Account.Account Name})
)
else
(
{Command_1.Year_Budget} - Sum ({@YTD_balance}, {Account.Account Name})
)
Field: YTD_budget
Formula: whileprintingrecords;
currencyvar YTD_budget_total;
if {Account.Account Name} = 'Sales Returns' then
(
YTD_budget_total := YTD_budget_total - {Command_1.Year_Budget};
)
else
(
YTD_budget_total := YTD_budget_total + {Command_1.Year_Budget};
);
{Command_1.Year_Budget};
Field: month_budget
Formula: whileprintingrecords;
currencyvar month_budget_total;
if {Account.Account Name} = 'Sales Returns' then
(
month_budget_total := month_budget_total - {Command.Amount}
)
else
(
month_budget_total := month_budget_total + {Command.Amount}
);
{Command.Amount};
Field: YTD_budget_type_total
Formula: whileprintingrecords;
currencyvar YTD_budget_net_income;
currencyvar YTD_budget_total;
if {Account_Type.Account Type} = 'Expense' then
(
YTD_budget_net_income := YTD_budget_net_income - YTD_budget_total
)
else
(
YTD_budget_net_income := YTD_budget_net_income + YTD_budget_total
);
YTD_budget_total;
Field: month_budget_type_total
Formula: whileprintingrecords;
currencyvar month_budget_net_income;
currencyvar month_budget_total;
if {Account_Type.Account Type} = 'Expense' then
(
month_budget_net_income := month_budget_net_income - month_budget_total;
)
else
(
month_budget_net_income := month_budget_net_income + month_budget_total;
);
month_budget_total;
Field: month_type_total_variance
Formula: if {Account_Type.Account Type} = 'Revenue' then
(
{@month_budget_type_total} + Sum ({@month_balance}, {Account_Type.Account Type})
)
else
(
{@month_budget_type_total} - Sum ({@month_balance}, {Account_Type.Account Type})
)
Field: YTD_type_total_variance
Formula: if {Account_Type.Account Type} = 'Revenue' then
(
{@YTD_budget_type_total} + Sum ({@YTD_balance}, {Account_Type.Account Type})
)
else
(
{@YTD_budget_type_total} - Sum ({@YTD_balance}, {Account_Type.Account Type})
)
Field: type_total_heading
Formula: if GroupName ({Account_Type.Account Type}) = 'Revenue' then
"Net Sales"
else
"Total Operating Expenses"
Field: month_net_income_variance
Formula: {@month_budget_net_income} + Sum ({@month_balance})
Field: YTD_net_income_variance
Formula: {@YTD_budget_net_income} + Sum ({@YTD_balance})
Field: YTD_budget_net_income
Formula: whileprintingrecords;
currencyvar YTD_budget_net_income;
YTD_budget_net_income;
Field: month_budget_net_income
Formula: whileprintingrecords;
currencyvar month_budget_net_income;
month_budget_net_income;
Field: init
Formula: whileprintingrecords;
currencyvar month_budget_total :=0;
currencyvar YTD_budget_total :=0;
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: Text1
Text: Consolidated Income Statement
Text Field: Text2
Text: How to create a Consolidated Income Statement
Text Field: Text19
Text: For the Months Ending {?End Date}
Text Field: Text20
Text: Consolidated Income Statement
Text Field: Text21
Text: Xtreme Mountain Bikes
Text Field: Text9
Text: YTD
Text Field: Text13
Text: Variance
Text Field: Text12
Text: Budget
Text Field: Text11
Text: Actual
Text Field: Text16
Text: Variance
Text Field: Text14
Text: Actual
Text Field: Text15
Text: Budget
Pictures
Picture: RO_Xtreme_Logo
Size: 279x111
Hyperlink: http://www.businessobjects.com
Boxes
Box: Box1
Ends in Section: PageHeaderSection1
Size: 413x19
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
Field: init1
Data Source: {@init}
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.
Group Footer
Section: Section a
Fields
Field: YTDbudgettypetotal1
Data Source: {@YTD_budget_type_total}
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: monthbudgettypetotal1
Data Source: {@month_budget_type_total}
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: monthtypetotalvariance1
Data Source: {@month_type_total_variance}
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: YTDtypetotalvariancwe1
Data Source: {@YTD_type_total_variance}
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: typetotalheading1
Data Source: {@type_total_heading}
Data Type: String
Field: Sumofmonthbalance4
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: True
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: 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: GroupNameAccountName1
Data Source: GroupName ({Account.Account Name})
Data Type: String
Field: monthaccountvariance1
Data Source: {@month_account_variance}
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: YTDaccountvariance1
Data Source: {@YTD_account_variance}
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: YTDbudget1
Data Source: {@YTD_budget}
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: monthbudget1
Data Source: {@month_budget}
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: 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: True
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).
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.
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: displaymonthnetincomevariance1
Data Source: {@month_net_income_variance}
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: displayYTDnetincomevariance1
Data Source: {@YTD_net_income_variance}
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: displayYTDbudgetnetincome1
Data Source: {@YTD_budget_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: displaymonthbudgetnetincome1
Data Source: {@month_budget_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: 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: True
Number Style: $(5,555,555).
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: True
Number Style: $(5,555,555).
Text Fields
Text Field: Text29
Text: Net Income