Recent content by tfratzke

If i didn't elaborate enough, the MASTER_JCM_COST_CODE.JTD_Cost is the dollar value to the job cost code in the MASTER_JCM_COST_CODE.Cost_Code field. Tony

I am using three Tables: MASTER_JCM_JOB is equal joined to MASTER_JCM_COST_CODE by the JOB to JOB field. MASTER_JCM_JOB is equal joined to MASTER_ARM_CUSTOMER_TOTALS by the AR_CUSTOMER to CUSTOMER field. The two fields; MASTER_JCM_COST_CODE.Cost_Code (string) & MASTER_JCM_COST_CODE.JTD_Cost...

I get the same results with that formula, except now, all of my applied commissions are a string and cannot be grand totaled . Let me ask this...how could i ONLY show records where "1-100" is null and hide all other groups/records? Tony

Sorry, Crystal 8.5 I actually had tried that already what you said, and justt tried it again. I put this suppress formula in the detail section: {MASTER_JCM_COST_CODE.Cost_Code} <> "1-100" Now, all of my groups (jobs) show up, but it still won't display anything when job cost code "1-100" is...

Here is my issue. I am working on a Timberline Job Cost report. This reports shows contract amounts, billed amounts, invoice dates, and calcuates a job cost %. I also want the report to pull in the amount of commission that has been applied to each job. The commission job cost code is "1-100"...