Search results for query: *

Hello I am trying to write a Formula for Monthly data to be used in a Chart. The Data is base on the Balance Sheet. My Formulas now have Data only being read for one month or a rolling balance. Here are two months worth for my Current Month data, and the second Formula shows YTD: 1. If...

I am trying to create a Fromula to represent all employees still on board after 12/31/2009 to show what the yearly cost would be for each Department. Here is what I have so far; IsNull// If {V_PLSEE.PL_TERMINATE_DT} < {?Enter Date} I am getting a alert stating that I do not have enough...

Hello, I really enjoy using Crystal Reports XI and the Clients I am working with want to know what is better about Crystal than Excel when it comes to Reports and Graphs. Is there a way I can explain rather than just saying it is easier for all users and for report design. Thanks

I created two formulas, one for AP and one for AR: shared numbervar apAmt; If {RV_GLSA_ROLLING_BAL.GL_YR} = {@Current Year} Then If {@month} = 10 Then If {@Account1} = "1.4010.1" or {@Account1} in "0.4013.9" to "0.4016.5" or {@Account1} in "0.4017.1"...

Hello I am trying to find the difference between Account Receivables and Account Payables for a Consolidated Bal Sheet. Acct Rec Accts If {@Account1} = "1.1190.99" or {@Account1} = "1.1180.22" or {@Account1} = "1.1190.77" or {@Account1} = "0.1190.9" Then...

I need to make manual changes to some servers and here are my steps: cd /acct/34537 vi versions.dat I then go in and make the necessary changes. Here is where I can't figure it out. I hit 'esc' Then 'Enter' but I still cannot type 'wq!' Can someone help me out. I think I am missing a...

I am using CR XI and I have created a Formula for Eliminating Entries for September in a Balance Sheet; CASE 9:if ({@Account1} = "1.1180.22" or {@Account1} = "1.1190.77" or {@Account1} = "0.1190.9" or {@Account1} = "1.1190.99" or {@Account1} = "0.1401" or {@Account1} = "1.4010.1" or {@Account1}...

Hello I have data in one file and would like tomput it into a separate file to look like a Database. "COLUMN A" "COLUMN B" "COLUMN C" Depr 979,501 1,038,884 Def Taxes (152,160) 61,540 Gain(Loss) (1,140,864) (143,506) Can you help me create a Lookup function to be...

Hello, This is the Formula"Eliminating Entries" I have created for the Eliminating Entries column on the Consolidate Bal Sheet. CASE 5:if ({@Account1} = "1.1180.22" or {@Account1} = "1.1190.77" or {@Account1} = "0.1190.9" or {@Account1} = "1.1190.99" or {@Account1} = "0.1401" or {@Account1} =...

Hello, I have just purchsed a new server, SuSE 10, and have setup my company and carried my Database over. How can I grab all my Historic Reports which has data in them so I can have them on my new server. I was trying to do this ftp ftp.misc."ip address" of old server cd /reports mget...

Hello, I am creating Financials for a Parent company that has a subsidiary. They would like two seperate columns showing the amounts for 0. Parent Company and 1. Subsidiary. This is decided based on the first number. I tried to use 0. for these accounts, but at the end of my Formula I have...

Hello I have different studies that have been done by our Accounting Department. There are approximately 15 tabs and they all floww into one another. I have created subreports, but not in a long time. Is there a way to create Subreports that flow into one another just as excel spreadsheets...

Hello I am currently working on a Balance Sheet and I am running into a problem trying to keep all Assets on page 1 and the Liabilities & Equity on the second. I went into Section Expert for my Group Name which contains the following formula for the headings to each main Topic: If...

Hello, This is a simple question and con not figure it out myself. I am producing a Bal Sheet w/ Eliminating Entries. My Eliminations are fine, but I can not figure out the formula for the Consolidating Column. My eliminations have the negatives & positives where need be so that is why I...

Any tips? I created a Transaction Activity report for a Client using OpenSUSE Linux and when I go into the Directory report/ I can see the file. I write a command pr MayActivity but when it queues up for printing, it is trying to print to our Clients printer. Is there a way I can write a...

This problem has been occuring since we went to an ODBC connection. For example, when I do the balance sheet template I created, if I drag the previous years data and the current years data, the preview screen goes blank. If I only use one years data, it works fine. I am putting the data in...

Hi, I have created Consolidated Financial Statements and all my Data is there. I also created a Parameter for each report using Detail or Summary. Right now, I can't figure out how to make the report a Summary. For example, on my Income Statement, there are over 60 Accts for Total...

Hello, I am trying to adjust a Formula for a Subsidiary Company for Consolidation. I can add the Account to a particular Range of Accounts but I can not remember how to say not in a range in Accounts. Please see below... If {@Accounts} < "5299.999999" or {@Accounts} in "5301" to "5999" and...

Can anyone help? My Accounting Dept is going thru a conversion with the Chart of Accounts. I Can't remember how to write a Lookup so i can automatically link the old chart of accounts to the new ones. For example: 1190.7 A/R PLANTERS NET 1170 1190.8 ACCOUNTS RECEIVABLE-PTLD 1170...

I am trying to create Financial Statements using the Financials. Each Line Item contains multiple Accounts. I cant remember how to do a Between Formula so only certain Accounts will be pulled for their Data(Amounts). Does anyone have a tip? Jason