Recent content by mfroggie

It always helps to review your typing. I put <=, <= in my 2nd subreport selection formula and once I changed that to the correct >=, <= my totals look correct. Thank you again for your abundance patience and remarkable help. Mfroggie

So when I put the selection formulas here for you I noticed I hadn't made your changes to those with the greater than and less than. So I made those changes, took out the formulas you had me put in the headers of the subreports and now I get totals. The only problem I see now is my "last year"...

This formula Shared numberVar array currtotal := [0,0,0]; Shared numberVar array lasttotal := [0,0,0]; "" is in the Report Header of the Main Report and this formula Shared numberVar array currrep := [0,0,0]; Shared numberVar array lastrep := [0,0,0]; "" is in the Group Header #1 of the Main...

I will try, bear with me. There are 2 subreports which are both placed in the Group Header 2 and the variables for the running totals on the main report are placed in the group footer 1a. Group based on Category of parts sold. The report that works and has been working based on only one fiscal...

Thank you pmax9999. That makes more sense, I had tried "to" and got an error message so changed it to "and". Unfortunately when I changed the selection formula to your suggestion I still get the same results when trying a range. Any other suggestions? Mfroggie Mfroggie

I hope somebody can help me with this. I have a main report with 2 subreports that have been working fine requesting info for only 1 fiscal pd. Now they want a range so I changed the selection formula to the following: (tonumber({OESHDT.YR})=tonumber({?FiscalYear}) or...

This did work. I will have to tweak the Mid portion a bit for different rows since some items are different lengths but the formula is good. Thank you for your help Skip. mfroggie Mfroggie

Embedded formula like that is what I was thinking. I am transferring their data now and tomorrow will load it into my software and run some tests to see how that works. Would be great to have that so everytime they want to do a new price increase all I have to do is export their items and paste...

1. There will not always be 3 there could be up to 7 I believe. (Clients data, I am transferring it now to look at it.) 2. Yes 3. I was trying to make it simple the costs could be anything. Thanks, mfroggie Mfroggie

Sure, I hope this is what you want. Sheet1 ColA ColB ColC(results) abc1200.124 124 7.00 abc1200.135 135 9.00 Sheet2 ColA ColB 1 1.00 2 2.00 3 3.00 4 4.00 5 5.00 So as per Gavins...

Ok, let me see if I can explain it better. You have base item abc1200 and it sells for 20.00. Now you have options you can add to and they are listed on sheet2 with their identifier in column a and their price in column b. We will say 1 thru 5 and to make it simple we will say option 1 cost's...

I need to create a formula that will go thru a cell and find a character that matches my criteria and pull the price for that criteria to create a base price for the item in the initial cell. For example I have an item on Sheet1 ABC1200.124 ABC1200.135 I have options on a Sheet2 1 1.00 2 2.00 3...

Ok, I have setup 3 parameters ?Printby (bolean) ?EXPDATE (number) ?REFERENCE (string) And I have setup this formula as @select (({?PrintBy} = "EXPDATE" and {OEORDH.EXPDATE} = {?EXPDATE}) or({?PrintBy} = "REFERENCE" and {OEORDH.REFERENCE} = {?REFERENCE})) Now I am not sure if I am doing the...

I have a simple report to print a list of active quotes but the client wants to be able to either print by a exp date range or by a reference number. I have it set up to select EXPDATE or REFERENCE using a selection formula and putting that in Sort but I want to also be able to select the...

Thank you so very much, this did it for me. I used it in a crosstab and then set up a parameter so he could print which ever quarter or all quarters. Thanks again for your help, greatly appreciated. Mfroggie Mfroggie