Search results for query: *

I was able to get the "mm/dd/yyyy" to sort correctly. My only adjustment to the lbass's reply was the dollar amount sorted by the first digit only. I was able to fix by convering the totext({MASTER_JCM_JOB.Revised_Contract_Amount},2) to...

I'm trying to write a report with multiple sort options. It is telling me that the default: "" needs to be a date field. If I put a date field then it tells me the last three lines need to be a number. What is the proper fix? //Output 1st sorting criteria if count({?Sort Conditions})>=1 then...

Here is a sample of a "transaction log"... Cat TranDate Tranaction Type Amt 06-s-074 Our Job-Palm Beach, FL 01-710 Cost Code Description 12-31-06 Percent Complete 100.00 M 12-31-06 JC Cost 53.73...

dgillz - I appreciate your time (and patience) today. I'll try to explain the situation better... With Timberline, when you enter a job cost, it creates a transaction record. The transaction 'type' depends on how the data was entered. For example, when you enter a commitment in Timberline...

Thank you dgillz, However, {CURRENT_JCT_TRANSACTION.Cost_Code} is not the null value. The {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Committed cost" could be null in certain instances. How do I test for a null value if it is not a field, but a formula? (Sorry, not very savvy in...

Crystal 10/Timberline Database I need help with the below (very lengthy) formula. I have an instance where my "01" number may or may not have a committed cost entry. For instance, cost code "01-710" has a commitment on one job, in which I want that amount to show on the report. On another...

This pulls in the maximum percentage, but not the entry for the most recent date/time. For example, I have a "Percent Complete" entered on 12/31/06 as 100% at 13:42, and then this was reduced to 0% on 12/31/06 at 14:27. I need to most recent entry pulled in, which in this case would be the 0%...

NEWBIE - Crystal 10, Timberline 9.2 I have this very basic formula to look up the amount for "Percent Complete". However, this may have more than one value, so I need to pick the value that has the most recent transaction date, but I'm not sure how to word it. if...

The "quick fix" did it. I never had to use that before, so I didn't realize it was there. I appreciate the kind response to my 'very newbie question!!!! Holly

Windows XP, Crystal 10, Timberline database. The following formula, in instances where AP costs nor JC costs have occured, is coming back with a 'blank' value vs. a zero. I'm having difficulty writing the formula to return a zero value in instances where an AP cost transaction nor a JC cost...

No record selection... At the detail level, it suppresses data if the Revised Contract Amount is < 0. The Group Footer suppresses using the following formula: {@YTD Costs Recognized} = 0 and {@YTD Revenue Earned} = 0 and {@Over-Billing} = 0 and {@Under-Billing} = 0 or...

When I move my end parentheses up a line, I lose all data. I end up with nothing but zeros.

I've been staring at this too long, and all my formulas are running together.... Any ideas why this formula is not giving me information within the date parameter? (Yes, I know my formula could be condensed). [wink] I'm using 5/31/06 as my cut off date, and it is still giving me entries that...

LB- Tried your suggestion first, and it worked. I would have never thought the () would have made the difference. Again, you have bailed me out! Much appreciated! Teknogeek9 & synapsevampire - Thanks to both of you for the responses! HS [ponytails]

CR10 - Trying to sum my Contracts by Year and then have a Grand Total in my Report Footer. The following is the formula (hidden) in my details section to accumulate: WhilePrintingRecords; numbervar RCyrtot; numbervar RCgrtot; if not({@YTD Costs Recognized} = 0 and {@YTD Revenue Earned} = 0 and...

It worked ~ Thank you!

This worked! Except....The {@accum}, and thus the {@displyrtot} in GF#1, does not seem to reset at the end of the year. Did I overlook something? (Note: I've had beginner Crystal training only, so these formulas are a little outside my realm of training). Also, I want to sincerly thank you...

In the Details Section (which is all supressed) are the following formulas: Job to Date Costs (as of cut-off prompt): IF {CURRENT_JCT_TRANSACTION.Transaction_Type} in ["AP cost","JC cost","PR cost","EQ Cost","IV Cost"] and ({CURRENT_JCT_TRANSACTION.Accounting_Date} <= {?Cut Off Date}) then...

Many of the job total are built into the software. For those that weren't, I was able to sum the individual transaction, where certain criteria were met. I have not used running totals up to this point.

Three Groups: GP 1 - Year of Job (which is first two digits of Job#) Formula: Left ({MASTER_JCM_JOB.Job},2) GP 2 - Transactions by Job {current_jct_transaction.job} GP 3 - Job {master_jcm_job.job} I was able to get my totals to work for each job, but I'm not having any luck getting...