**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Financial\Dynamic Full Year Actual - Forecast.rpt **************************************************************************** Report Information Version: 11.0 Author: Business Objects Comments: This report shows the companys net income for the current period and the forcasted amounts for the remaining months of the year. Title: Full Year Budget Report with Actuals 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-14 3:18:30 PM Default Values: 2005-02-28 3:18:30 PM 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.Journal Entry ID} : Number {Journal_Entry.Date} : DateTime {Journal_Entry.Amount} : Number {Journal_Entry.Debit Or Credit} : String[22] Table: Command_9 Connection: Connection #1 SQL Command: SELECT [Amount], [Account Number],[Month] FROM [Monthly Account Budgets] WHERE Year=Year({?End Date}) Parameters: End Date Used Columns: {Command_9.Amount} : Number {Command_9.Account Number} : String[18] {Command_9.Month} : Number 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] Command_9 INNER JOIN Account ON Command_9.[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 ["Revenue", "Expense"] and {Journal_Entry_Type.Journal Entry Type} <> "closing entries" and {Journal_Entry.Date} <= dateserial(year({?End Date}),12,31) 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 Journal_Entry.Journal Entry ID -- Ascending Order Group #4 Custom Functions Function: mar Formula Fields Field: jan_balance Formula: whileprintingrecords; currencyvar jan_account_balance; currencyvar jan_budget; if month({?End Date}) >= 1 then ( if month({Journal_Entry.Date}) = 1 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( jan_account_balance := jan_account_balance + ({Journal_Entry.Amount} * -1); ) else ( jan_account_balance := jan_account_balance + ({Journal_Entry.Amount}); ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( jan_account_balance := jan_budget * -1; ) else ( jan_account_balance := jan_budget; ); ); jan_account_balance; Field: feb_balance Formula: whileprintingrecords; currencyvar feb_account_balance; currencyvar feb_budget; if month({?End Date}) >= 2 then ( if month({Journal_Entry.Date}) = 2 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( feb_account_balance := feb_account_balance + ({Journal_Entry.Amount} * -1); ) else ( feb_account_balance := feb_account_balance + ({Journal_Entry.Amount}); ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( feb_account_balance := feb_budget * -1; ) else ( feb_account_balance := feb_budget; ); ); feb_account_balance; Field: mar_balance Formula: whileprintingrecords; currencyvar mar_account_balance; currencyvar mar_budget; if month({?End Date}) >= 3 then ( if month({Journal_Entry.Date}) = 3 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( mar_account_balance := mar_account_balance + ({Journal_Entry.Amount} * -1); ) else ( mar_account_balance := mar_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( mar_account_balance := mar_budget * -1; ) else ( mar_account_balance := mar_budget; ); ); mar_account_balance; Field: mar_account_balance Formula: whileprintingrecords; currencyvar mar_account_balance; currencyvar mar_type_total; mar_type_total := mar_type_total + mar_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( mar_account_balance * -1; ) else ( mar_account_balance; ); Field: feb_account_balance Formula: whileprintingrecords; currencyvar feb_account_balance; currencyvar feb_type_total; feb_type_total := feb_type_total + feb_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( feb_account_balance * -1; ) else ( feb_account_balance; ); Field: jan_account_balance Formula: whileprintingrecords; currencyvar jan_account_balance; currencyvar jan_type_total; jan_type_total := jan_type_total + jan_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( jan_account_balance * -1; ) else ( jan_account_balance; ); Field: apr_balance Formula: whileprintingrecords; currencyvar apr_account_balance; currencyvar apr_budget; if month({?End Date}) >= 4 then ( if month({Journal_Entry.Date}) = 1 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( apr_account_balance := apr_account_balance + {Journal_Entry.Amount} * -1; ) else ( apr_account_balance := apr_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( apr_account_balance := apr_budget * -1; ) else ( apr_account_balance := apr_budget; ); ); apr_account_balance; Field: apr_account_balance Formula: whileprintingrecords; currencyvar apr_account_balance; currencyvar apr_type_total; apr_type_total := apr_type_total + apr_account_balance; if {Account_Type.Account Type} = 'Revenue' then (apr_account_balance * -1;) else (apr_account_balance;) Field: init Formula: whileprintingrecords; currencyvar jan_account_balance :=0; currencyvar feb_account_balance :=0; currencyvar mar_account_balance :=0; currencyvar apr_account_balance :=0; currencyvar may_account_balance :=0; currencyvar jun_account_balance :=0; currencyvar jul_account_balance :=0; currencyvar aug_account_balance :=0; currencyvar sep_account_balance :=0; currencyvar oct_account_balance :=0; currencyvar nov_account_balance :=0; currencyvar dec_account_balance :=0; currencyvar jan_budget :=0; currencyvar feb_budget :=0; currencyvar mar_budget :=0; currencyvar apr_budget :=0; currencyvar may_budget :=0; currencyvar jun_budget :=0; currencyvar jul_budget :=0; currencyvar aug_budget :=0; currencyvar sep_budget :=0; currencyvar oct_budget :=0; currencyvar nov_budget :=0; currencyvar dec_budget :=0; Field: init_account_type Formula: whileprintingrecords; currencyvar jan_type_total:=0; currencyvar feb_type_total:=0; currencyvar mar_type_total:=0; currencyvar apr_type_total:=0; currencyvar may_type_total:=0; currencyvar jun_type_total:=0; currencyvar jul_type_total:=0; currencyvar aug_type_total:=0; currencyvar sep_type_total:=0; currencyvar oct_type_total:=0; currencyvar nov_type_total:=0; currencyvar dec_type_total:=0; Field: jan_account_type_total Formula: whileprintingrecords; currencyvar jan_net_profit; currencyvar jan_type_total; if {Account_Type.Account Type} = 'Revenue' then (jan_net_profit := jan_net_profit + jan_type_total * -1; jan_type_total * -1; ) else ( jan_net_profit := jan_net_profit - jan_type_total; jan_type_total; ); Field: jan_budget Formula: whileprintingrecords; currencyvar jan_budget; if {Command_9.Month} = 1 then ( jan_budget := {Command_9.Amount}; ) Field: feb_budget Formula: whileprintingrecords; currencyvar feb_budget; if {Command_9.Month} = 2 then ( feb_budget := {Command_9.Amount} ) Field: mar_budget Formula: whileprintingrecords; currencyvar mar_budget; if {Command_9.Month} = 3 then ( mar_budget := {Command_9.Amount} ) Field: apr_budget Formula: whileprintingrecords; currencyvar apr_budget; if {Command_9.Month} = 4 then ( apr_budget := {Command_9.Amount} ) Field: may_budget Formula: whileprintingrecords; currencyvar may_budget; if {Command_9.Month} = 5 then ( may_budget := {Command_9.Amount} ) Field: jun_budget Formula: whileprintingrecords; currencyvar jun_budget; if {Command_9.Month} = 6 then ( jun_budget := {Command_9.Amount}; ) Field: jul_budget Formula: whileprintingrecords; currencyvar jul_budget; if {Command_9.Month} = 7 then ( jul_budget := {Command_9.Amount}; ) Field: aug_budget Formula: whileprintingrecords; currencyvar aug_budget; if {Command_9.Month} = 8 then ( aug_budget := {Command_9.Amount}; ) Field: sep_budget Formula: whileprintingrecords; currencyvar sep_budget; if {Command_9.Month} = 9 then ( sep_budget := {Command_9.Amount} ) Field: oct_budget Formula: whileprintingrecords; currencyvar oct_budget; if {Command_9.Month} = 10 then ( oct_budget := {Command_9.Amount} ) Field: nov_budget Formula: whileprintingrecords; currencyvar nov_budget; if {Command_9.Month} = 11 then ( nov_budget := {Command_9.Amount} ) Field: dec_budget Formula: whileprintingrecords; currencyvar dec_budget; if {Command_9.Month} = 12 then ( dec_budget := {Command_9.Amount} ) Field: may_balance Formula: whileprintingrecords; currencyvar may_account_balance; currencyvar may_budget; if month({?End Date}) >= 5 then ( if month({Journal_Entry.Date}) = 5 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( may_account_balance := may_account_balance + ({Journal_Entry.Amount} * -1); ) else ( may_account_balance := may_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( may_account_balance := may_budget * -1; ) else ( may_account_balance := may_budget; ); ); may_account_balance; Field: may_account_balance Formula: whileprintingrecords; currencyvar may_account_balance; currencyvar may_type_total; may_type_total := may_type_total + may_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( may_account_balance * -1; ) else ( may_account_balance; ); Field: jun_balance Formula: whileprintingrecords; currencyvar jun_account_balance; currencyvar jun_budget; if month({?End Date}) >= 6 then ( if month({Journal_Entry.Date}) = 6 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( jun_account_balance := jun_account_balance + ({Journal_Entry.Amount} * -1); ) else ( jun_account_balance := jun_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( jun_account_balance := jun_budget * -1; ) else ( jun_account_balance := jun_budget; ); ); jun_account_balance; Field: jun_account_balance Formula: whileprintingrecords; currencyvar jun_account_balance; currencyvar jun_type_total; jun_type_total := jun_type_total + jun_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( jun_account_balance * -1; ) else ( jun_account_balance; ); Field: jul_account_balance Formula: whileprintingrecords; currencyvar jul_account_balance; currencyvar jul_type_total; jul_type_total := jul_type_total + jul_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( jul_account_balance * -1; ) else ( jul_account_balance; ); Field: jul_balance Formula: whileprintingrecords; currencyvar jul_account_balance; currencyvar jul_budget; if month({?End Date}) >= 7 then ( if month({Journal_Entry.Date}) = 7 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( jul_account_balance := jul_account_balance + ({Journal_Entry.Amount} * -1); ) else ( jul_account_balance := jul_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( jul_account_balance := jul_budget * -1; ) else ( jul_account_balance := jul_budget; ); ); jul_account_balance; Field: aug_balance Formula: whileprintingrecords; currencyvar aug_account_balance; currencyvar aug_budget; if month({?End Date}) >= 8 then ( if month({Journal_Entry.Date}) = 8 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( aug_account_balance := aug_account_balance + {Journal_Entry.Amount} * -1; ) else ( aug_account_balance := aug_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( aug_account_balance := aug_budget * -1; ) else ( aug_account_balance := aug_budget; ); ); aug_account_balance; Field: aug_account_balance Formula: whileprintingrecords; currencyvar aug_account_balance; currencyvar aug_type_total; aug_type_total := aug_type_total + aug_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( aug_account_balance * -1; ) else ( aug_account_balance; ); Field: sep_balance Formula: whileprintingrecords; currencyvar sep_account_balance; currencyvar sep_budget; if month({?End Date}) >= 9 then ( if month({Journal_Entry.Date}) = 9 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( sep_account_balance := sep_account_balance + ({Journal_Entry.Amount} * -1); ) else ( sep_account_balance := sep_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( sep_account_balance := sep_budget * -1; ) else ( sep_account_balance := sep_budget; ); ); sep_account_balance; Field: sep_account_balance Formula: whileprintingrecords; currencyvar sep_account_balance; currencyvar sep_type_total; sep_type_total := sep_type_total + sep_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( sep_account_balance * -1; ) else ( sep_account_balance; ); Field: oct_balance Formula: whileprintingrecords; currencyvar oct_account_balance; currencyvar oct_budget; if month({?End Date}) >= 10 then ( if month({Journal_Entry.Date}) = 10 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( oct_account_balance := oct_account_balance + ({Journal_Entry.Amount} * -1); ) else ( oct_account_balance := oct_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( oct_account_balance := oct_budget * -1; ) else ( oct_account_balance := oct_budget; ); ); oct_account_balance; Field: oct_account_balance Formula: whileprintingrecords; currencyvar oct_account_balance; currencyvar oct_type_total; oct_type_total := oct_type_total + oct_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( oct_account_balance * -1; ) else ( oct_account_balance; ); Field: nov_balance Formula: whileprintingrecords; currencyvar nov_account_balance; currencyvar nov_budget; if month({?End Date}) >= 11 then ( if month({Journal_Entry.Date}) = 11 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( nov_account_balance := nov_account_balance + ({Journal_Entry.Amount} * -1); ) else ( nov_account_balance := nov_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( nov_account_balance := nov_budget * -1; ) else ( nov_account_balance := nov_budget; ); ); nov_account_balance; Field: nov_account_balance Formula: whileprintingrecords; currencyvar nov_account_balance; currencyvar nov_type_total; nov_type_total := nov_type_total + nov_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( nov_account_balance * -1; ) else ( nov_account_balance; ); Field: dec_balance Formula: whileprintingrecords; currencyvar dec_account_balance; currencyvar dec_budget; if month({?End Date}) >= 12 then ( if month({Journal_Entry.Date}) = 12 then ( if {Journal_Entry.Debit Or Credit} = 'Credit' then ( dec_account_balance := dec_account_balance + ({Journal_Entry.Amount} * -1); ) else ( dec_account_balance := dec_account_balance + {Journal_Entry.Amount}; ) ) ) else ( if {Account_Type.Account Type} = 'Revenue' and {Account.Account Name} <> 'Sales Returns' then ( dec_account_balance := dec_budget * -1; ) else ( dec_account_balance := dec_budget; ); ); dec_account_balance; Field: dec_account_balance Formula: whileprintingrecords; currencyvar dec_account_balance; currencyvar dec_type_total; dec_type_total := dec_type_total + dec_account_balance; if {Account_Type.Account Type} = 'Revenue' then ( dec_account_balance * -1; ) else ( dec_account_balance; ); Field: feb_type_total Formula: whileprintingrecords; currencyvar feb_net_profit; currencyvar feb_type_total; if {Account_Type.Account Type} = 'Revenue' then ( feb_net_profit := feb_net_profit + feb_type_total * -1; feb_type_total * -1; ) else ( feb_net_profit := feb_net_profit - feb_type_total; feb_type_total; ); Field: mar_type_total Formula: whileprintingrecords; currencyvar mar_net_profit; currencyvar mar_type_total; if {Account_Type.Account Type} = 'Revenue' then ( mar_net_profit := mar_net_profit + mar_type_total * -1; mar_type_total * -1; ) else ( mar_net_profit := mar_net_profit - mar_type_total; mar_type_total; ); Field: apr_type_total Formula: whileprintingrecords; currencyvar apr_net_profit; currencyvar apr_type_total; if {Account_Type.Account Type} = 'Revenue' then ( apr_net_profit := apr_net_profit + apr_type_total * -1; apr_type_total * -1; ) else ( apr_net_profit := apr_net_profit - apr_type_total; apr_type_total; ); Field: may_type_total Formula: whileprintingrecords; currencyvar may_net_profit; currencyvar may_type_total; if {Account_Type.Account Type} = 'Revenue' then ( may_net_profit := may_net_profit + may_type_total * -1; may_type_total * -1; ) else ( may_net_profit := may_net_profit - may_type_total; may_type_total; ); Field: jun_type_total Formula: whileprintingrecords; currencyvar jun_net_profit; currencyvar jun_type_total; if {Account_Type.Account Type} = 'Revenue' then ( jun_net_profit := jun_net_profit + jun_type_total * -1; jun_type_total * -1; ) else ( jun_net_profit := jun_net_profit - jun_type_total; jun_type_total; ); Field: jul_type_total Formula: whileprintingrecords; currencyvar jul_net_profit; currencyvar jul_type_total; if {Account_Type.Account Type} = 'Revenue' then ( jul_net_profit := jul_net_profit + jul_type_total * -1; jul_type_total * -1; ) else ( jul_net_profit := jul_net_profit - jul_type_total; jul_type_total; ); Field: aug_type_total Formula: whileprintingrecords; currencyvar aug_net_profit; currencyvar aug_type_total; if {Account_Type.Account Type} = 'Revenue' then ( aug_net_profit := aug_net_profit + aug_type_total * -1; aug_type_total * -1; ) else ( aug_net_profit := aug_net_profit - aug_type_total; aug_type_total; ); Field: sep_type_total Formula: whileprintingrecords; currencyvar sep_net_profit; currencyvar sep_type_total; if {Account_Type.Account Type} = 'Revenue' then ( sep_net_profit := sep_net_profit + sep_type_total * -1; sep_type_total * -1; ) else ( sep_net_profit := sep_net_profit - sep_type_total; sep_type_total; ); Field: oct_type_total Formula: whileprintingrecords; currencyvar oct_net_profit; currencyvar oct_type_total; if {Account_Type.Account Type} = 'Revenue' then ( oct_net_profit := oct_net_profit + oct_type_total * -1; oct_type_total * -1; ) else ( oct_net_profit := oct_net_profit - oct_type_total; oct_type_total; ); Field: nov_type_total Formula: whileprintingrecords; currencyvar nov_net_profit; currencyvar nov_type_total; if {Account_Type.Account Type} = 'Revenue' then ( nov_net_profit := nov_net_profit + nov_type_total * -1; nov_type_total * -1; ) else ( nov_net_profit := nov_net_profit - nov_type_total; nov_type_total; ); Field: dec_type_total Formula: whileprintingrecords; currencyvar dec_net_profit; currencyvar dec_type_total; if {Account_Type.Account Type} = 'Revenue' then ( dec_net_profit := dec_net_profit + dec_type_total * -1; dec_type_total * -1; ) else ( dec_net_profit := dec_net_profit - dec_type_total; dec_type_total; ); Field: type_total_heading Formula: if {Account_Type.Account Type} = 'Revenue' then "Net Sales" else "Total Operating Expenses" Field: jan_net_income Formula: whileprintingrecords; currencyvar jan_net_profit; jan_net_profit; Field: feb_net_income Formula: whileprintingrecords; currencyvar feb_net_profit; feb_net_profit; Field: mar_net_income Formula: whileprintingrecords; currencyvar mar_net_profit; mar_net_profit; Field: apr_net_income Formula: whileprintingrecords; currencyvar apr_net_profit; apr_net_profit; Field: may_net_income Formula: whileprintingrecords; currencyvar may_net_profit; may_net_profit; Field: jun_net_income Formula: whileprintingrecords; currencyvar jun_net_profit; jun_net_profit; Field: jul_net_income Formula: whileprintingrecords; currencyvar jul_net_profit; jul_net_profit; Field: aug_net_income Formula: whileprintingrecords; currencyvar aug_net_profit; aug_net_profit; Field: sep_net_income Formula: whileprintingrecords; currencyvar sep_net_profit; sep_net_profit; Field: oct_net_income Formula: whileprintingrecords; currencyvar oct_net_profit; oct_net_profit; Field: nov_net_income Formula: whileprintingrecords; currencyvar nov_net_profit; nov_net_profit; Field: dec_net_income Formula: whileprintingrecords; currencyvar dec_net_profit; dec_net_profit; Field: annual_balance_total Formula: {@jan_account_balance}+{@feb_account_balance}+{@mar_account_balance}+{@apr_account_balance}+{@may_account_balance}+{@jun_account_balance}+{@jul_account_balance}+{@sep_account_balance}+{@oct_account_balance}+{@nov_account_balance}+{@dec_account_balance} Field: annual_type_total Formula: {@jan_account_type_total}+{@feb_type_total}+{@mar_type_total}+{@apr_type_total}+{@may_type_total}+{@jun_type_total}+{@jul_type_total}+{@aug_type_total}+{@sep_type_total}+{@oct_type_total}+{@nov_type_total}+{@dec_type_total} Field: annual_net_income Formula: {@jan_net_income}+{@feb_net_income}+{@mar_net_income}+{@apr_net_income}+{@may_net_income}+{@jun_net_income}+{@jul_net_income}+{@aug_net_income}+{@sep_net_income}+{@oct_net_income}+{@nov_net_income}+{@dec_net_income} Field: actual_dates Formula: "Actual Data : January - " + monthname(month({?End Date})) Field: forecast_dates Formula: if month({?End Date}) = 12 then "Forecast Data : None" else "Forecast Data : " + monthname(month(dateadd('m',1,{?End Date}))) + " - December" 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: actualdates1 Data Source: {@actual_dates} Data Type: String Field: forcastdates1 Data Source: {@forecast_dates} Data Type: String Text Fields Text Field: Text1 Text: Full Year Budget Report with Actuals Text Field: Text2 Text: How to create a Full Year Budget Report with Actual and Forecast Amounts Text Field: Text19 Text: For the Months Ending {?End Date} Text Field: Text20 Text: Dynamic Full Year Actual - Forecast Text Field: Text21 Text: Xtreme Mountain Bikes Text Field: Text10 Text: January Text Field: Text5 Text: February Headings Heading: Text4 Text: April Heading: Text14 Text: March Heading: Text15 Text: May Heading: Text16 Text: June Heading: Text17 Text: July Heading: Text18 Text: August Heading: Text22 Text: September Heading: Text23 Text: October Heading: Text24 Text: November Heading: Text25 Text: December Heading: Text3 Text: Annual Actual + Forecast Pictures Picture: RO_Xtreme_Logo Size: 279x111 Hyperlink: http://www.businessobjects.com Boxes Box: Box1 Ends in Section: PageHeaderSection1 Size: 614x19 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: initaccounttype1 Data Source: {@init_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. Group Footer Section: Section a Fields Field: janaccounttypetotal1 Data Source: {@jan_account_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: febtypetotal1 Data Source: {@feb_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: martypetotal1 Data Source: {@mar_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: aprtypetotal1 Data Source: {@apr_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: maytypetotal1 Data Source: {@may_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: juntypetotal1 Data Source: {@jun_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: jultypetotal1 Data Source: {@jul_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: augtypetotal1 Data Source: {@aug_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: septypetotal1 Data Source: {@sep_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: octtypetotal1 Data Source: {@oct_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: novtypetotal1 Data Source: {@nov_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: dectypetotal1 Data Source: {@dec_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: typetotalheading1 Data Source: {@type_total_heading} Data Type: String Field: annualtypetotal1 Data Source: {@annual_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. 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 Header Section: Section a Fields 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: febaccountbalance1 Data Source: {@feb_account_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: janaccountbalance1 Data Source: {@jan_account_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: maraccountbalance1 Data Source: {@mar_account_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: apraccountbalance1 Data Source: {@apr_account_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: mayaccountbalance1 Data Source: {@may_account_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: junaccountbalance1 Data Source: {@jun_account_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: julaccountbalance1 Data Source: {@jul_account_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: augaccountbalance1 Data Source: {@aug_account_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: sepaccountbalance1 Data Source: {@sep_account_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: octaccountbalance1 Data Source: {@oct_account_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: novaccountbalance1 Data Source: {@nov_account_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: decaccountbalance1 Data Source: {@dec_account_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: balancetotal1 Data Source: {@annual_balance_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: GroupNameAccountNumber2 Data Source: GroupName ({Account.Account Name}) Data Type: String Group: Group #4 Grouped By: {Journal_Entry.Journal Entry ID} Group Header Section: Section a Fields Field: GroupNameJournalEntryID1 Data Source: GroupName ({Journal_Entry.Journal Entry ID}) Data Type: String Group Footer Section: Section a Fields Field: marbalance1 Data Source: {@mar_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: janbalance1 Data Source: {@jan_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: febbalance1 Data Source: {@feb_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: aprbalance1 Data Source: {@apr_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: maybalance1 Data Source: {@may_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: junbalance1 Data Source: {@jun_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: julbalance1 Data Source: {@jul_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: augbalance1 Data Source: {@aug_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: sepbalance1 Data Source: {@sep_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: octbalance1 Data Source: {@oct_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: novbalance1 Data Source: {@nov_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: decbalance1 Data Source: {@dec_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. Detail Section: Section a Fields Field: janbudget1 Data Source: {@jan_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: febbudget1 Data Source: {@feb_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: marbudget1 Data Source: {@mar_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: aprbudget1 Data Source: {@apr_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: maybudget1 Data Source: {@may_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: junbudget1 Data Source: {@jun_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: julbudget1 Data Source: {@jul_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: augbudget1 Data Source: {@aug_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: sepbudget1 Data Source: {@sep_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: octbudget1 Data Source: {@oct_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: novbudget1 Data Source: {@nov_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: decbudget1 Data Source: {@dec_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. 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: jannetincome1 Data Source: {@jan_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: febnetincome1 Data Source: {@feb_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: marnetincome1 Data Source: {@mar_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: aprnetincome1 Data Source: {@apr_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: maynetincome1 Data Source: {@may_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: junnetincome1 Data Source: {@jun_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: julnetincome1 Data Source: {@jul_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: augnetincome1 Data Source: {@aug_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: sepnetincome1 Data Source: {@sep_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: octnetincome1 Data Source: {@oct_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: novnetincome1 Data Source: {@nov_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: decnetincome1 Data Source: {@dec_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: annualnetincome1 Data Source: {@annual_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. Text Fields Text Field: Text29 Text: Net Income