Search results for query: *

I have a problem similar to this one (http://tek-tips.com/viewthread.cfm?qid=1586994&page=22#post). My first group is salesrep, then 2 of customer ID (to have individual control over showing the chart in question and a subreport), then Monthname ("(" +...

thanks anyway :)

Both are evaluated For each record and reset On change of group Part.ID. The formulas themselves are in the detail (only for the calculations. nothing in this sub actually has to show in the resulting report). SELECT "PART"."ID", "INVENTORY_TRANS"."TRANSACTION_DATE"...

- Cost is just a sum of 4 fields in the table - the running totals are of a formula: if {INVENTORY_TRANS.TYPE} = "I" then {INVENTORY_TRANS.QTY} else 0-{INVENTORY_TRANS.QTY} and another formula almost identical (just slightly different condition) I take it there is no array sorting that will...

// cost of goods issued // ----------------------------------------------------- // ( ( start inventory cost + end inventory cost ) / 2 ) if ( ({PART.QTY_AVAILABLE_ISS}-{#PeriodChanges}) + {PART.QTY_AVAILABLE_ISS} ) = 0 then 0 else ( if {@1Cost} = 0 then (...

If I understand what you are asking correctly: The subreport is currently grouped first by p/n, then by transaction date, then by transaction ID. The transacted QTYs are conditionally summed at the transaction ID level. The results are then used, at the Part ID level, to calculate Turnover...

I have a subreport that goes through our database of parts and their transactions to calculate a Turnover ratio for each part. I store the part numbers in string array TurnoverPN, and at the same [element address] in number array Turnover, I store my calculated ratio. At the end of the...