Search results for query: *

I am using Crystal Reports 10 and upgraded to Windows 7. I installed the driver for my dot matrix printer Okidata ML590. The top of page was set up fine with the driver for Windows XP but when I switched over to Windows 7 and set up the new driver, the top of page work ok for the first couple...

SkipVought/xlbo: Yes, the data in each row is different within the worksheet and from one worksheet to the next. Each worksheet is a customer's price list, where it lists the customer's price and weight for each product. Actually I do have headers, hopefully this explains it better! Customer...

For example, sheet1 will have a formula in cell F1 = D1*E1 I would like to put a formula in sheet2 that refers the formula in sheet1 but actually return based on values in sheet2. Sheet1 D E F 1 3 2 6 (cell F1 is a formula (=D1*E1) Sheet2 D E...

I have a workbook that contains many worksheets. Each worksheet is a customer's price list. There are many formulas in the worksheet that are duplicated from one worksheet to the next. I would like to create a master worksheet and build up the formulas in specific rows and columns. Then, can...

The subreport is currently in the group header. The {@mainformula} is also located in the detail section. I did your recommendation above and it gave me the same results where the last entry is 0 and it should be the ending inventry amount.

{@QTY ON HAND} is my running balance up to my ending inventory quantity which keeps repeating after the max is reached. IF {#Qty Purchased} <{@MainFormula} THEN {#Qty Purchased} ELSE {@MainFormula} ------------------ {@MAINFORMULA} is my ending inventory quantity which pulls from my subreport...

Yes, all this is in detail. Detail of each purchase needs to stop after my ending inventory quantity is met. This formula brings the results I want but then keeps listing detail with the maximum @MainFormula (ending inv quantity) thru out the detail. I don't want to show details after my...

Yes, it is new. It is the criteria that I thought I can achieve by figuring out the max running balance. The report is grouped by item keys and displays every purchase showing most recent purchase first with quantity and price. Here are my fields and formulas in the detail section: Qty Purch...

I guess, and I cant get my columns to lineup QTY Running Ending Qty Purch PURCH TOtal Inv upto Inv 80 80 200 80 20 100 200 20 50 150 200 50 60 200* 200 50 100 0**...

Thank you for your input so much. This formula makes my last 210 result as 0 and thereafter. However, I want my 210 to be 200 and the rest of the running total be 0. More important I am after the Qty Purch upto Inv column to run inventory costing based on actual purchase. Like this: QTY PURCH...

Thanks Ibass. I will try this tomorrow. How can I then have the next record after the maximum amount return 0? QTY PURCH Running TOtal Ending Inv 80 80 200 20 100 50 150 60 210 (but I want this to be max...

Does anyone know how to get a maximum running total based on another field? For example, a running total of quantity purchased during the year up to ending inventory quantity. QTY PURCH Running TOtal Ending Inv 80 80 200 20 100 50...