Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jason2121

    Formula for Monthly data for Charts

    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...
  2. Jason2121

    IsNull Formula

    I used this and it worked to eliminate any employees thata re no longer on Staff after a Parameter Date selected. IsNull ({V_PLSEE.PL_TERMINATE_DT}) Thanks
  3. Jason2121

    IsNull Formula

    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...
  4. Jason2121

    Crystal better than Excel? Trying to upgrade

    I appreciate all this input - I am currently writing my proposal and have my final Meeting this afternoon where I present this option, which I think going to Crystal for Reports and Graphs for presentations or printed proposals is best for Managerial aspects. If there are any other opinions...
  5. Jason2121

    Crystal better than Excel? Trying to upgrade

    Thanks for your opinion(s). I like them both, but feel Crystal is more benevicial to the client because they are not database conscious. I can Audit their numbers and keep it in the same format and then design Reports for them based on Excel which they enter into everyday and I upload, CSV...
  6. Jason2121

    Crystal better than Excel? Trying to upgrade

    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
  7. Jason2121

    Summary on non-recurring Field

    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"...
  8. Jason2121

    Subtracting Accounts

    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"...
  9. Jason2121

    Subtracting Accounts

    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...
  10. Jason2121

    exiting from vi versions.dat

    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...
  11. Jason2121

    Using a Formula w/in a Formula

    This what I did and it worked. Thanks for your advice, and it did take me awhile to figure out to go the detailed route. I hope this helps out anyone else who trying to do the same thing. If {RV_GLSA_ROLLING_BAL.GL_YR} = {@Current Year} Then If {@month} = 9 Then If ({@Account1} =...
  12. Jason2121

    Using a Formula w/in a Formula

    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}...
  13. Jason2121

    Creating Lookup Function

    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...
  14. Jason2121

    Adding a Summary into a Report Field

    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} =...
  15. Jason2121

    Moving multiple files to a new server

    That worked - Thanks
  16. Jason2121

    Moving multiple files to a new server

    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...
  17. Jason2121

    Formula for Seperating Co. Financials

    This is not the format of it. I am just trying to see how to do an: If then -({RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL}) if then {RV_GLSA_ROLLING_BAL.GL_PER_1_ACCUM_BAL} else How can I do this for each month so all that needs to be done is refresh for monthly financials. I am...
  18. Jason2121

    Formula for Seperating Co. Financials

    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...
  19. Jason2121

    Using Subreports

    I am thinking of creating reports for each tab and then using the Main Tab as the Main Crystal Report then creating Subreports using the other CR's I created with the other Tabs - Make Sense? If this works - then all the links in excel wont play a factor because Crystal will read the data as...
  20. Jason2121

    Using Subreports

    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...

Part and Inventory Search

Back
Top