Search results for query: *

Here's my issue: When I use "FORMULA A", any record that does not have an entry in the PODETL Table, no longer shows up on my Report. When I use "FORMULA B", all my records show on my report, but sometimes have the wrong value ... All my Values on this Report are either Calculated Values or...

If I have a USF1:String[20] that holds a number, can I make Crystal Reports use it as a number? If so, how do I do that? Please advise and Thanks! Louanne

Here is my current Formula: if {JOBDETL.ACTCOST} > 0 then {JOBDETL.ACTCOST} else if {PODETL.PRICE} > 0 then {PODETL.PRICE} else {JOBDETL.UNITCOST} *************************** I have changed the links and now have the PO Detail Linked Directly to the JO Detail and now I only the ACTCOST...

I cannot rationalize the why ... but I think I have found the pattern for the duplicate numbers ... if I purchase one line item on one Purchase Order then, then the values print once ... if there is no purchase order for the material, then there is no values (the whole line of data is gone)...

My End Goal is a Budget Based Report where we compare our Sales Price (as sold) to the Budget Costs (as budgeted) to our Total Actual Costs, which include money spent but not realized and estimates of money to be spent. Project XYZ (Group) Job Order for Assembly X Job Order for Assembly Y...

Opps ... Crystal Version (10) Pulling Data from EziJobz (Build 97) the PO Details is a One to One Correlation to the Job Details .... as it it the Purchase Order Detail for the Line Item in the Job Order.

Part II: I now have my Actual Qty Received or the Zero Value using Katy44 if is Null(RCVDQTY) ... et cetera The next part is similar but a little more complicated ... when any amount is received, the RCVDCOST Value gets updated from the Receipt against the Purchase ORder; however if there are...

Part II: I now have my Actual Qty Received or the Zero Value using Katy44 if is Null(RCVDQTY) ... et cetera The next part is similar but a little more complicated ... when any amount is received, the RCVDCOST Value gets updated from the Receipt against the Purchase ORder; however if there are...

First let me apologize for not know how to even give this a proper subject line ... Here is the scenerio ... I'm am creating a Detailed Costs Reports that includes the Sales Price, the Estimated Budget, the Actual Money Spent, plus the remaining amount committed but not yet spent. So here's my...