Search results for query: *

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

It actually would depend on the fiscal calendar the company is using, whether they use a calendar yr as their fiscal calendar or a fiscal yr. This particular company uses a fiscal calendar with their 1st month being October so that October is 1, November is 2, etc. Thanks, Mfroggie Mfroggie

lbass, Thank you for your response. The {ICSTATI.PERIOD} field returns 1, 2, 3...... 12 representing the 12 fiscal periods in a fiscal calendar. Hope this helps. Mfroggie Mfroggie

I am trying a formula to pull sales numbers by qtr using Calendar1stQtr, etc and get "a number is required here" highlighting Calendar1stQtr. My formula is as follows. I don't have a date but am using period. IF {ICSTATI.PERIOD} in Calendar1stQtr then {ICSTATI.SALESAMT} Else 0 Any advise...

Does P2000i use RPC in client/server environment? W2k Server, W98 and XP workstations. Was getting an error message stating user didn't have permission to access the Database. It was working after re-installing Active Directory, LSASS.exe was corrupt. But after new IT person went in it quit...

I had to reboot my server and now it just keeps rebooting after the Windows Screen comes up it reboots itself. I can't boot to CD to repair my windows install and I created Boot Disks per MS directions but won't boot from a: either. It just goes to Windows screen. Try to go into setup and it...