Search results for query: *

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...

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...

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...

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...

I have a sub-report with running totals using a formula to Evaluate based on doctype and never resetting. It resets though in the subreport. If I save the subreport as an individual report and test it the running total works. If I insert the subreport into my main report again it resets on each...

[B]I have a report that has a Date Range Parameter, the dates have to be entered yyyymmdd. I need to put the beginning period MMMM yyyy thru MMMM yyyy into the header and cannot seem to get the correct formula. I have done Minimum and Maximum but had to change date totext to get the MMMM yyyy to...

[B]I am trying to write a report that has sales for a certain period and the next column to have sales for same period last year. Can't seem to come up with it. Can anybody help? Thanks [B] Mfroggie

I believe I figured it out. Thank you very much for everybody who helped. Mfroggie

I am trying to write a report where there would be 12 columns with total sales for a customer by month in each column, for a year. How do I do this? Thanks for any help. Mfroggie

I hope somebody can answer this question. Say you have records that could have one of 3 different classes assigned to them. Then you want to pull records out according to these classes by the 1st class and a date minus so many days, the 2nd class by that date minus a different no of days and the...

I hope someone can point me in the right direction. I am trying to write a report where I need information out of one table and just 1 field out of another table. The tables have common key fields ie vendor number. When I start adding my fields just to get my innitial data whenever I add the one...