**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\Balance Sheet.rpt **************************************************************************** Report Information Version: 11.0 Author: © 2002 Crystal Decisions, Inc Comments: Consolidated Balance Statement shown in two cross-tabs: Assets and Total Liabilities and Shareholders' Equity Title: Consolidated Balance Sheet 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: Organization Data Type: String Description: Enter Organization: List Type: Static List Values: TBC Group Default Values: TBC Group Tables Table: Financials Connection: Connection #1 Used Columns: {Financials.Statement Date} : Date {Financials.Cash} : Number {Financials.Account Receivable} : Number {Financials.Inventories} : Number {Financials.Other Current Assets} : Number {Financials.Land} : Number {Financials.Buildings} : Number {Financials.Machinery etc} : Number {Financials.Accumulated Depreciation} : Number {Financials.Other Assets} : Number {Financials.Accounts Payable} : Number {Financials.Accrued Liabilities} : Number {Financials.Accrued Income Taxes} : Number {Financials.Notes Payable} : Number {Financials.Deferred Income Taxes} : Number {Financials.Preferred Stock} : Number {Financials.Common Stock} : Number {Financials.Retained Earnings} : Number Formula Fields Field: total current assets Formula: {Financials.Cash} + {Financials.Account Receivable} + {Financials.Inventories} + {Financials.Other Current Assets} Field: net fixed assets Formula: {Financials.Land} + {Financials.Buildings} + {Financials.Machinery etc} - {Financials.Accumulated Depreciation} Field: total assets Formula: {@total current assets} + {@total fixed and other assets} Field: total fixed and other assets Formula: {@net fixed assets} + {Financials.Other Assets} Field: Quarter Formula: if Month({Financials.Statement Date})=3 then "Qtr1" else if Month({Financials.Statement Date})=6 then "Qtr2" else if Month({Financials.Statement Date})=9 then "Qtr3" else if Month({Financials.Statement Date})=12 then "Qtr4 " Field: current liabilities Formula: {Financials.Accounts Payable} + {Financials.Accrued Liabilities} + {Financials.Accrued Income Taxes} Field: long term liabilities Formula: {Financials.Notes Payable} + {Financials.Deferred Income Taxes} Field: total liabilities Formula: {@current liabilities} + {@long term liabilities} Field: total equity Formula: {Financials.Common Stock} + {Financials.Preferred Stock} + {Financials.Retained Earnings} Field: total equity and liabilities Formula: {@total equity} + {@total liabilities} Report Header Section: Section a Fields Field: Field1 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: Field2 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: Text1 Text: For the Last 4 Quarters Text Field: Text2 Text: Consolidated Balance Sheet Text Field: Text3 Text: Xtreme Mountain Bikes, Inc. Pictures Picture: Picture4 Size: 286x107 Lines Line: Line1 Ends in Section: Section1 Line Type: Single Line Thickness: 30 Section: Section b Text Fields Text Field: Text4 Text: Assets Section: Section c Text Fields Text Field: Text5 Text: Total Current Assets Text Field: Text6 Text: Land Text Field: Text7 Text: Buildings Text Field: Text8 Text: Equipments etc Text Field: Text9 Text: Less: Accumulated Depreciation Text Field: Text10 Text: Net Fixed Assets Text Field: Text11 Text: Other Assets Text Field: Text12 Text: Total Fixed and Other Assets Text Field: Text13 Text: Total Assets Text Field: Text14 Text: Cash Tool Tip Formula: "The Cross-tab Report Expert makes it easy to create a cross-tab" Text Field: Text15 Text: Accounts Receivable Text Field: Text16 Text: Inventories Text Field: Text17 Text: Other Current Assets Lines Line: Line2 Ends in Section: Section3 Line Type: Single Line Thickness: 20 Cross-Tabs Cross-Tab: CrossTab1 Section: Section d Text Fields Text Field: Text18 Text: Liabilities & Shareholders' Equity Section: Section e Text Fields Text Field: Text19 Text: Total Liabilities Text Field: Text20 Text: Long Term Debts Text Field: Text21 Text: Accounts Payable Text Field: Text22 Text: Accrued Liabilities Text Field: Text23 Text: Accrued Income Taxes Text Field: Text24 Text: Total Current Liabilities Text Field: Text25 Text: Preferred Stock Text Field: Text26 Text: Common Stock Text Field: Text27 Text: Retained Earnings Text Field: Text28 Text: Total Shareholders' Equity Text Field: Text29 Text: Total Equity and Liabilities Lines Line: Line3 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Cross-Tabs Cross-Tab: CrossTab2 Cross-Tab: CrossTab3 Page Footer Section: Section a Fields Field: Field3 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: Text30 Text: Crystal Care Support Site Hyperlink: http://support.crystaldecisions.com Text Field: Text31 Text: © Copyright 2002 Crystal Decisions, Inc. All Rights Reserved. Text Field: Text32 Text: Feedback on Samples by E-mail Hyperlink: mailto:crfeedback@crystaldecisions.com Pictures Picture: Picture2 Size: 179x50 Hyperlink: http://www.crystaldecisions.com Lines Line: Line4 Ends in Section: Section9 Line Type: Single Line Thickness: 30