Report Information
Description Report Title: Consolidated Balance Sheet
Report Author: � 2002 Crystal Decisions, Inc
Report Comments: Consolidated Balance Statement shown in two cross-tabs: Assets and Total Liabilities and Shareholders' Equity
Converted By: Crystal Migration Services, support@crystalmigrater.com
Data Sources
DataSource1
Name DataSource1
Connection String DSN=Xtreme Sample Database 11.5;
Data Provider ODBC
Datasets
DataSet1
Name DataSet1
Query
Data Source DataSource1
CommandText
SELECT Financials.[Statement Date], Financials.[Other Assets], Financials.[Accumulated Depreciation], Financials.[Machinery etc], Financials.Buildings, Financials.Land, Financials.[Other Current Assets], Financials.Inventories, Financials.[Account Receivable], Financials.Cash, Financials.[Accrued Income Taxes], Financials.[Accrued Liabilities], Financials.[Accounts Payable], Financials.[Deferred Income Taxes], Financials.[Notes Payable], Financials.[Retained Earnings], Financials.[Common Stock], Financials.[Preferred Stock]
FROM Financials Financials
Parameters
Fields
Statement_Date
Name Statement_Date
Source [Statement Date]
Data Type DateTime
Other_Assets
Name Other_Assets
Source [Other Assets]
Data Type Decimal
Accumulated_Depreciation
Name Accumulated_Depreciation
Source [Accumulated Depreciation]
Data Type Decimal
Machinery_etc
Name Machinery_etc
Source [Machinery etc]
Data Type Decimal
Buildings
Name Buildings
Source Buildings
Data Type Decimal
Land
Name Land
Source Land
Data Type Decimal
Other_Current_Assets
Name Other_Current_Assets
Source [Other Current Assets]
Data Type Decimal
Inventories
Name Inventories
Source Inventories
Data Type Decimal
Account_Receivable
Name Account_Receivable
Source [Account Receivable]
Data Type Decimal
Cash
Name Cash
Source Cash
Data Type Decimal
Accrued_Income_Taxes
Name Accrued_Income_Taxes
Source [Accrued Income Taxes]
Data Type Decimal
Accrued_Liabilities
Name Accrued_Liabilities
Source [Accrued Liabilities]
Data Type Decimal
Accounts_Payable
Name Accounts_Payable
Source [Accounts Payable]
Data Type Decimal
Deferred_Income_Taxes
Name Deferred_Income_Taxes
Source [Deferred Income Taxes]
Data Type Decimal
Notes_Payable
Name Notes_Payable
Source [Notes Payable]
Data Type Decimal
Retained_Earnings
Name Retained_Earnings
Source [Retained Earnings]
Data Type Decimal
Common_Stock
Name Common_Stock
Source [Common Stock]
Data Type Decimal
Preferred_Stock
Name Preferred_Stock
Source [Preferred Stock]
Data Type Decimal
Embedded Images
Picture_A71C16DB5FC6FA97CA22693727225E5E
Name Picture_A71C16DB5FC6FA97CA22693727225E5E
Type jpeg
Picture_9B686CFB00AA497757CA65E94EDA1223
Name Picture_9B686CFB00AA497757CA65E94EDA1223
Type jpeg
Custom Code
Public Function total_liabilities (ByVal dbField12 As Decimal, ByVal dbField11 As Decimal, ByVal dbField10 As Decimal, ByVal dbField14 As Decimal, ByVal dbField13 As Decimal) As Decimal
Return current_liabilities (dbField12, dbField11, dbField10) + long_term_liabilities (dbField14, dbField13)
End Function
Public Function current_liabilities (ByVal dbField12 As Decimal, ByVal dbField11 As Decimal, ByVal dbField10 As Decimal) As Decimal
Return (dbField12 + dbField11) + dbField10
End Function
Public Function long_term_liabilities (ByVal dbField14 As Decimal, ByVal dbField13 As Decimal) As Decimal
Return dbField14 + dbField13
End Function
Body
Report Items
Text1
Name Text1
Type Text Box
Content For the Last 4 Quarters
Text2
Name Text2
Type Text Box
Content Consolidated Balance Sheet
Field1
Name Field1
Type Text Box
Content =Format(Globals.ExecutionTime, "M/d/yyyy")
Field2
Name Field2
Type Text Box
Content =Format(Globals.ExecutionTime, "h:m:s tt")
Text3
Name Text3
Type Text Box
Content Xtreme Mountain Bikes, Inc.
Picture4
Name Picture4
Type Image
Source Type Embedded Image Name
Embedded Image Name Picture_A71C16DB5FC6FA97CA22693727225E5E
Text4
Name Text4
Type Text Box
Content Assets
CrossTab1_Corner
Name CrossTab1_Corner
Type Text Box
RectCrossTab100
Name RectCrossTab100
Type Rectangle
SummaryField01
Name SummaryField01
Type Text Box
Content =Sum (Fields!Cash.Value)
SummaryField011
Name SummaryField011
Type Text Box
Content =Sum (Fields!Account_Receivable.Value)
SummaryField012
Name SummaryField012
Type Text Box
Content =Sum (Fields!Inventories.Value)
SummaryField013
Name SummaryField013
Type Text Box
Content =Sum (Fields!Other_Current_Assets.Value)
SummaryField014
Name SummaryField014
Type Text Box
Content =Sum (Cdbl(((Fields!Cash.Value + Fields!Account_Receivable.Value) + Fields!Inventories.Value) + Fields!Other_Current_Assets.Value))
SummaryField015
Name SummaryField015
Type Text Box
Content =Sum (Fields!Land.Value)
SummaryField016
Name SummaryField016
Type Text Box
Content =Sum (Fields!Buildings.Value)
SummaryField017
Name SummaryField017
Type Text Box
Content =Sum (Fields!Machinery_etc.Value)
SummaryField018
Name SummaryField018
Type Text Box
Content =Sum (Fields!Accumulated_Depreciation.Value)
SummaryField019
Name SummaryField019
Type Text Box
Content =Sum (Cdbl(((Fields!Land.Value + Fields!Buildings.Value) + Fields!Machinery_etc.Value) - Fields!Accumulated_Depreciation.Value))
SummaryField0110
Name SummaryField0110
Type Text Box
Content =Sum (Fields!Other_Assets.Value)
SummaryField0111
Name SummaryField0111
Type Text Box
Content =Sum (Cdbl(((Fields!Land.Value + Fields!Buildings.Value) + Fields!Machinery_etc.Value) - Fields!Accumulated_Depreciation.Value + Fields!Other_Assets.Value))
SummaryField0112
Name SummaryField0112
Type Text Box
Content =Sum (Cdbl(((Fields!Cash.Value + Fields!Account_Receivable.Value) + Fields!Inventories.Value) + Fields!Other_Current_Assets.Value + ((Fields!Land.Value + Fields!Buildings.Value) + Fields!Machinery_etc.Value) - Fields!Accumulated_Depreciation.Value + Fields!Other_Assets.Value))
RectCrossTab101
Name RectCrossTab101
Type Rectangle
Rectangle_CrossTab1_ColField0
Name Rectangle_CrossTab1_ColField0
Type Rectangle
CrossTab1_ColField0
Name CrossTab1_ColField0
Type Text Box
Content =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Rectangle_CrossTab1_ColField1
Name Rectangle_CrossTab1_ColField1
Type Rectangle
CrossTab1_ColField1
Name CrossTab1_ColField1
Type Text Box
Content Total
Visibility
Show or hide based on expression true
Rectangle_CrossTab1_RowField2
Name Rectangle_CrossTab1_RowField2
Type Rectangle
CrossTab1_RowField2
Name CrossTab1_RowField2
Type Text Box
Content Total
Visibility
Show or hide based on expression true
Text5
Name Text5
Type Text Box
Content Total Current Assets
Text6
Name Text6
Type Text Box
Content Land
Text7
Name Text7
Type Text Box
Content Buildings
Text8
Name Text8
Type Text Box
Content Equipments etc
Text9
Name Text9
Type Text Box
Content Less: Accumulated Depreciation
Text10
Name Text10
Type Text Box
Content Net Fixed Assets
Text11
Name Text11
Type Text Box
Content Other Assets
Text12
Name Text12
Type Text Box
Content Total Fixed and Other Assets
Text13
Name Text13
Type Text Box
Content Total Assets
Text14
Name Text14
Type Text Box
Content Cash
Text15
Name Text15
Type Text Box
Content Accounts Receivable
Text16
Name Text16
Type Text Box
Content Inventories
Text17
Name Text17
Type Text Box
Content Other Current Assets
Text18
Name Text18
Type Text Box
Content Liabilities & Shareholders' Equity
Text19
Name Text19
Type Text Box
Content Total Liabilities
Text20
Name Text20
Type Text Box
Content Long Term Debts
Text21
Name Text21
Type Text Box
Content Accounts Payable
Text22
Name Text22
Type Text Box
Content Accrued Liabilities
Text23
Name Text23
Type Text Box
Content Accrued Income Taxes
Text24
Name Text24
Type Text Box
Content Total Current Liabilities
CrossTab2_Corner
Name CrossTab2_Corner
Type Text Box
RectCrossTab200
Name RectCrossTab200
Type Rectangle
SummaryField01_1
Name SummaryField01_1
Type Text Box
Content =Sum (Fields!Preferred_Stock.Value)
SummaryField011_1
Name SummaryField011_1
Type Text Box
Content =Sum (Fields!Common_Stock.Value)
SummaryField012_1
Name SummaryField012_1
Type Text Box
Content =Sum (Fields!Retained_Earnings.Value)
SummaryField013_1
Name SummaryField013_1
Type Text Box
Content =Sum (Cdbl((Fields!Common_Stock.Value + Fields!Preferred_Stock.Value) + Fields!Retained_Earnings.Value))
SummaryField014_1
Name SummaryField014_1
Type Text Box
Content =Sum (Cdbl((Fields!Common_Stock.Value + Fields!Preferred_Stock.Value) + Fields!Retained_Earnings.Value + Code.total_liabilities (Fields!Accounts_Payable.Value, Fields!Accrued_Liabilities.Value, Fields!Accrued_Income_Taxes.Value, Fields!Notes_Payable.Value, Fields!Deferred_Income_Taxes.Value)))
RectCrossTab201
Name RectCrossTab201
Type Rectangle
Rectangle_CrossTab2_ColField0
Name Rectangle_CrossTab2_ColField0
Type Rectangle
CrossTab2_ColField0
Name CrossTab2_ColField0
Type Text Box
Content =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Visibility
Show or hide based on expression true
Rectangle_CrossTab2_ColField1
Name Rectangle_CrossTab2_ColField1
Type Rectangle
CrossTab2_ColField1
Name CrossTab2_ColField1
Type Text Box
Content Total
Visibility
Show or hide based on expression true
Rectangle_CrossTab2_RowField2
Name Rectangle_CrossTab2_RowField2
Type Rectangle
CrossTab2_RowField2
Name CrossTab2_RowField2
Type Text Box
Content Total
Visibility
Show or hide based on expression true
CrossTab3_Corner
Name CrossTab3_Corner
Type Text Box
RectCrossTab300
Name RectCrossTab300
Type Rectangle
SummaryField01_2
Name SummaryField01_2
Type Text Box
Content =Sum (Fields!Accounts_Payable.Value)
SummaryField011_2
Name SummaryField011_2
Type Text Box
Content =Sum (Fields!Accrued_Liabilities.Value)
SummaryField012_2
Name SummaryField012_2
Type Text Box
Content =Sum (Fields!Accrued_Income_Taxes.Value)
SummaryField013_2
Name SummaryField013_2
Type Text Box
Content =Sum (Cdbl((Fields!Accounts_Payable.Value + Fields!Accrued_Liabilities.Value) + Fields!Accrued_Income_Taxes.Value))
SummaryField014_2
Name SummaryField014_2
Type Text Box
Content =Sum (Cdbl(Fields!Notes_Payable.Value + Fields!Deferred_Income_Taxes.Value))
SummaryField015_1
Name SummaryField015_1
Type Text Box
Content =Sum (Cdbl(Code.total_liabilities (Fields!Accounts_Payable.Value, Fields!Accrued_Liabilities.Value, Fields!Accrued_Income_Taxes.Value, Fields!Notes_Payable.Value, Fields!Deferred_Income_Taxes.Value)))
RectCrossTab301
Name RectCrossTab301
Type Rectangle
Rectangle_CrossTab3_ColField0
Name Rectangle_CrossTab3_ColField0
Type Rectangle
CrossTab3_ColField0
Name CrossTab3_ColField0
Type Text Box
Content =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Rectangle_CrossTab3_ColField1
Name Rectangle_CrossTab3_ColField1
Type Rectangle
CrossTab3_ColField1
Name CrossTab3_ColField1
Type Text Box
Content Total
Visibility
Show or hide based on expression true
Rectangle_CrossTab3_RowField2
Name Rectangle_CrossTab3_RowField2
Type Rectangle
CrossTab3_RowField2
Name CrossTab3_RowField2
Type Text Box
Content Total
Visibility
Show or hide based on expression true
Text25
Name Text25
Type Text Box
Content Preferred Stock
Text26
Name Text26
Type Text Box
Content Common Stock
Text27
Name Text27
Type Text Box
Content Retained Earnings
Text28
Name Text28
Type Text Box
Content Total Shareholders' Equity
Text29
Name Text29
Type Text Box
Content Total Equity and Liabilities
Data Regions
CrossTab1
Name CrossTab1
Type Matrix
Column Member 1
CrossTab1_ColGroup0
Name CrossTab1_ColGroup0
Expressions =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Sort Expressions =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Column Member 2
Row Member 1
Source Dataset DataSet1
CrossTab2
Name CrossTab2
Type Matrix
Column Member 1
CrossTab2_ColGroup0
Name CrossTab2_ColGroup0
Expressions =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Sort Expressions =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Column Member 2
Row Member 1
Source Dataset DataSet1
CrossTab3
Name CrossTab3
Type Matrix
Column Member 1
CrossTab3_ColGroup0
Name CrossTab3_ColGroup0
Expressions =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Sort Expressions =IIF ((Month(Fields!Statement_Date.Value) = 3), ("Qtr1"), IIF (( Month(Fields!Statement_Date.Value) = 6 ), ("Qtr2"), IIF (( Month(Fields!Statement_Date.Value) = 9 ), ("Qtr3"), IIF (( Month(Fields!Statement_Date.Value) = 12 ), ("Qtr4 "), ""))))
Column Member 2
Row Member 1
Source Dataset DataSet1
Page Footer
Report Items
Field3
Name Field3
Type Text Box
Content =Globals!PageNumber
Picture2
Name Picture2
Type Image
Source Type Embedded Image Name
Embedded Image Name Picture_9B686CFB00AA497757CA65E94EDA1223
Actions
Go to URL http://www.crystaldecisions.com
Text30
Name Text30
Type Text Box
Content Crystal Care Support Site
Actions
Go to URL http://support.crystaldecisions.com
Text31
Name Text31
Type Text Box
Content © Copyright 2002 Crystal Decisions, Inc. All Rights Reserved.
Text32
Name Text32
Type Text Box
Content Feedback on Samples by E-mail
Actions
Go to URL mailto:crfeedback@crystaldecisions.com