Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Editing Existing Reports with additional table Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: Editing Existing Reports with additional table
    Posted: 21 Jan 2013 at 5:18pm
I really need helps with this one, I'm editing one of the existing report because we are implementing new system in our company.
the problem is that my boss wants me to combine the two table and make it looks the way she wants it.

The first table

Job   Description Cust      mat labor overhead sub
1234   New Job       ABC   $1500 $300   $200
3456   New Job       DCF    2000 400    300
       
       Outside             (200)                 200
       Freight             (300)                 300
       Our Freight               (25)    (50)    75

The first part comes from the Job Pervasive table which i have no problem created it.

but the second part is what im stuck with for few days now. here the way they want it.

OUTSIDE: IF (TABLE_LMO) = 'O' AND (TABLE_TRAN) = 50 AND (TBALE_DESC) <> THEN (TABLE_LABOR)

FREIGHT: IF (TABLE_LMO) = 'O' AND (TABLE_TRAN) = 50 AND (TABLE_DESC) = 'FREGIHT OUTSOURCE' THEN (TABLE_LABOR)

OUR FREIGHT: IF (TABLE_LMO) = 'O' AND (TABLE_MACHINE) = 'FRHT' THEN (TABLE_LABOR) + (TABLE_OVERHEAD)

- the formula didn't work when I use the second pervasive table in the report. it works if I created all of the three formulas in each diff reports.Any idea?

- How can I make the number in the formula appear in the report as negative and positive (Sub column) and use it in the reports.


Any help would be amazing!!!!!!!

I just got this job and I have to learn programming and CR.

Im in need of help :)




IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.