Recent content by Jason2121

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

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

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

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

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

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

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

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

That worked - Thanks