In adhoc, custom reports, if you do not get the prompt "Change column headings?" , check the Top right field on the design screen: FANCY or Q&D
One user had an A instead of a Q and was not getting the prompt.
REPORT NAME: COSTEQP DATE LAST USED: 97-09-19 FANCY (F) or Q&D (Q)?
BASE TABLE FOR THIS REPORT (F9 TO CHANGE)
WOHIST
FILE NAME
WOHIST.MST
ARE THE REPORTS:
ON FORMS? (LABELS, ENVELOPES, ETC.) (Y/N)
N
IF 'Y': NUMBER OF LINES @ 6 PER INCH?
57
PAUSE BETWEEN PAGES OR SCREENS (Y/N)?
N
REPORT TITLE COST REPORT BY EQUIPMENT LAST MONTH PORTAGE___________
FOR Q&D REPORTS ONLY:
What fields do you want to display? (separate by ,) (F1-Lookup, F2-Help, F8-Clear)
UNIQUE PMPLANID PIC "%10r",UNIQUE DESC PIC "%10r",UNIQUE EQUIPNUM,WONUM PIC "ddd
FOR ALL REPORTS:
What are the special conditions? (F1-Lookup, F2-Help, F8-Clear)
COMPMON EQ LASTMONTH
What is the sorting order? (F1-Lookup, F2-Help, F8-Clear)
AZ PMPLANID AZ EQUIPNUM AZ COMPDAT
What is the grouping (sub-totaling)? (F1-Lookup, F2-Help, F8-Clear)
PM{LANID
Special Instructions? (Use only with OOPS! Tech Support Assistance)
------------------------------------------------------------------------------
1. If Fancy or Q&D is blank, you won't get a prompt to change your column
headings.
2. Special conditions will give you last month data.
Custom reporting tip for handling year 2000 dates in adhoc reports.
If you have Ad Hoc reports which you sort by SCHEDDAT (or COMPDAT), you may notice that the output will be in the wrong date order. For example, dates 00-xx-yy will appear before 99-xx-yy.
To fix this, replace statements
AZ SCHEDDAT with AZ SCHEDJUL AZ COMPDAT wity AZ COMPJULin the "What is the sorting order?" line. This will fix the problem.
MACRO FILES IN CUSTOM REPORTS
You can use multiple macros in custom reports by making an .SPC file containing the macro definitions. Each line must end with a \. In special instructions, put:
CUSTOM REPORTS
O - To use an existing OOPS! template in Custom Reports,
change F or Q&D to O. The ID and title can be anything.
Make sure the template has the extension .PTP. You can specify conditions
and sorting and grouping (on most).
For special instructions,
put ZZTEMPLATE="templatename" (no extension). Some templates
require ZZ variables to be set. Error messages when you try to
run the report will indicate this.
Go to the place in OOPS!
where the template was designed to be run to find out what
information must be specified. Field names go in quotes, as
ZZV1="system";ZZT1="system". This specifies both field and
title on SHLIST, for example.
F - To use a custom template in Custom Reports,
set F or Q&D to F. The report must have the same name as the template. The
template must have the extension .TPL.
You can specify conditions and some sorting and grouping. In special instructions, put SPECFILE="templatenm.TPL";PERFORM SPECIAL.PPF.
You can get more out of this by having programming statements before the TEMPLATE statement, such as custom titles, etc.
Problem:
In AdHoc, Custom Reports, you are unable to get the prompt: Change column headings".
Solution:
Make certain that the Top right field on the design screen: FANCY or Q&D is properly set.
Problem:
Some of the records on your Low Stock Report look funny.
For instance, one may have the price too high and one may be ordered when the
ordering equation has not been satisfied.
Solution:
For the equation not satisfied, make certain that the "ONE-TIME order
quantity" is not set. For the other, there was a confusion over order unit
of measure and units per order unit that was making the price be
1 * 5 * 5 instead of 1 * 5. No errors were found.
Problem:
You want to make space between columns in custom reports.
Solution:
Put " " pic "rrr" in the fields and then make the column heading
blank.
Problem:
You want to put in a few spaces before the first field on a
report to move the info over.
Solution:
Put " " PIC "%5r", as the first field.
Problem:
You Need to make reports on specific workers.
Solution:
Run Completion Report 8. This makes COMLAB.TMP. Then make
custom reports from this file.
Problem:
You are writing a report and need decimals in a custom field
where you are forcing numbers using TONUM.
Solution:
Use a pic of "%6d.dd".
Problem:
You want to make a string field numeric.
Solution:
To make a string field numeric, put TONUM(fieldname) pic
"%10d" as a field to display. This will handle length
and number. To make the numbers total, put E.DSUM=true
in the special instructions line.
Problem:
You want to shorten a field for appearance on an ad hoc report?
Solution:
Use a picture such as "%6r" to shorten the field to 6 characters.
Example: EQUIPNUM PIC "%6r" (It is important that you remember to use lower case "r"; otherwise "RRRRRR" will appear on your report.
Problem:
You have equipment numbers of xxx 1 and xxx 2 and xxx 10. The sequence
is coming out 1, 10, 2. You would like it to come out 1, 2, 10.
Solution:
OOPS! sees 1 and 10 as the same number. Use 01, 02, 10 and
the sequence will be correct.
Problem:
When trying to run a report you get "Expression Expected."
Solution:
In "Sorting", you need "AZ" AND a "field name".
Problem:
You want to make a report with departments on separate pages.
but don't want to make a report for each department.
Solution:
Use E.SECB=FALSE on Sp. Inst. line.
Problem:
You want to delete a custom report.
Solution:
Put DELETE in the "Report Title" on the design screen. (Not at the "What report do you want" prompt). Then run Cleanup.
Problem:
You cannot get the report column headings to change to what you
want.
Solution:
Make certain you have not been pressing the "down" arrow instead of the Enter key.
Problem:
You want a report with total by month.
Solution:
Change Grouping to SUBSTR(COMPDAT,1,5) for subtotals by month.
This will only use yy-mm of the date. Make sure COMPDAT is listed first
in the sort order.
Problem:
You want to do page breaks by group.
Solution:
In special instructions, set E.SECB=FALSE.
Problem:
You want a custom report to look at only the last 5% of the
history file.
Solution:
In the "Special Conditions" field enter:
Wonum ne 0 range last5,lastend
In the "Special Instructions" field enter:
specfile="rangecw.spc";perform special.ppf
Create an ascii file called rangecw.spc in the OOPS! directory with this info:
use local wohist.mst
obtain last from wohist
last5=toint(currec(wohist)-currec(wohist)*.05)
lastend=currec(wohist)
finish wohist
return
Problem:
You want a custom report for PMs that shows the supplemental
sheet name and description and shows it as a continuation.
Solution:
Write a custom report running off of the schedule file with
special conditions line of:
suppshid ne " " from suppsht pluck sched.suppshid
Special instructions line of: use suppsht.mst with suppsht.ind
Fields to display, schedule information and suppsht.suppname and
suppsht.
Problem:
You want to set up PM Schedule list in Custom Reports.
Solution:
Setting up the PM schedule list in Custom Reports.
1. Create a new custom report
2. In Fancy or Q&D put an O
3. Set up variables in special conditions line for sorting
ZZV1="PMPLANID";ZZT1="PMPLANID";ZZV2="SYSTEM";ZZT2="SYSTEM";
ZZV3="EQUIPNUM";ZZT3="EQUIPNUM";ZZTEMPLATE="SHLIST"
This would change depending on how you want your report sorted. If system should be first ZZV1 and ZZT1 would be SYSTEM.
Problem:
You need to get information from emplab and the requisition log
with a special condition coming from reqlog and inventory.
Solution:
1. Create and run TSG to create a dummy table
2. Create a new custom report
In this case the primary file was reqlog
Put in your fields to display, remember to use emplab. for
any fields coming from inventory, ie. emplab.manufnum
Special conditions: reqrecv eq "Q" from emplab pluck "m",
reqlog.partno, reqlog.primloc from dummy for
emplab.manuf="manuf1"
Note: you cannot use wildcards in the second special
condition, ie can't put emplab.manuf="*man*"
Problem:
You need a formula to find an average column width
Solution:
#SUM(X.00)/#CNT
Problem:
Trying to run history reports and they all run
endlessly and never finish.
Solution:
You may have lost end-of-file pointer. This happens when you have a power failure or improper shut-down. Call technical support for help.
Problem:
Getting an error message on a custom report.
Solution:
You may be comparing a Work Order (a string) to a number value. Use
WONUM.
Problem:
You want WOMOSUM to include the current month.
Solution:
If the system date is the 11th or greater, WOMOSUM includes the
current month. Doesn't include it if the date is the 10th or
less.
Problem:
You want a list of all the schedule records with the
supplemental sheet names and descriptions.
Solution:
You will need to create a custom report based on the schedule file
In Fields to Display line, type:
pmplanid,system,equipnum,suppshid.suppsht,suppshid.suppname
In Special Conditions, type:
suppshid ne " " from suppsht pluck sched.suppshid
In Special Instructions, type:
use suppsht.mst with suppsht.ind
Problem
Need to get information from Completed Material Utilization
Report and the Equipment File.
Solution:
1. Run the standard COMMAT report first
2. Create a new custom report, use another file
COMMAT is table name. COMMAT.TMP is master file name
press enter on the index
3. Any fields you want, any coming from the equipment file must
be prefaced with equip., ie equip.system
4. Special conditions line:
woreq ne " " from equip pluck commat.equipnum
5. Special instructions line:
use equip.mst with equip.ind
Problem:
You need to export the inventory information using a comma
delimited ascii format.
Solution:
Write a custom report with the fields needed
surrounded by quotes and commas to do this:
The backslash allows OOPS to recognize the quote and comma and characters.
Problem:
Getting a lot of backlogged partially completed WOs
that you don't want.
Solution:
Unless you are trying to do a partial completion, leave the
field blank.
Problem:
Getting Misplaced Field when you try to run completion
reports.
Solution:
Make certain you don't have file protection on *.TMP files. OOPS! must be able to delete these and remake them. Remove protection and run again.
Problem:
You are a OOPS! user on the network and when you run a report you get a blank screen.
Solution:
Check to see if OOPS! has been moved on the network to a different drive letter; if so OOPS! will not be able to create the temporary file to make the report.