Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Tewy
  • Order by date
  1. Tewy

    Totally new to WebFocus and have a question..

    Mark, Not entirely sure what you question is. The way these IF statements work in WebFOCUS is simply to miss out sections of code if they are satisfied. There are no end statements when coding the -IF statements, webfocus simply reads the line, decides if the condition is met and then either...
  2. Tewy

    Include file to show two graphs in one page

    hi, I'm not sure if I'm understanding your problem properly, if you want to display two graphs on one page, the easiest way to do it is like this: GRAPH FILE FILE1 SUM CNT.FIELD1 BY FIELD2 ON TABLE HOLD AS GRP1 FORMAT HTML END -RUN GRAPH FILE FILE2 SUM CNT.FIELD3 BY FIELD4 ON TABLE HOLD AS GRP2...
  3. Tewy

    IN Clause

    You can use Focus to check values in a file. You need to use ON TABLE HOLD AS filename FORMAT ALPHA, then filedef the file. You can then use IF fieldname IS (filename) or in a similar vein IF fieldname IS NOT (filename) in your code. You need to put this at the end of your WHERE statements or...
  4. Tewy

    bar graphs: to color one grid line

    Hi Eva, Your code should look something like: DEFINE FILE XYZ LINE/I9=90; END GRAPH FILE XYZ SUM MON TUE WED THU MAX.LINE ACROSS PERCENTFIELD END then you can use the standard graph functions to set LINE to a line, (if the others are bars), remove the line markers, change the colour and...
  5. Tewy

    bar graphs: to color one grid line

    Eva, One way that I use is to define a field in your graph that is equal to the value of the line. For example define a field called LINE which is equal to 90 and then sum the first value of this in your graph, you then get a straight line. You can colour the line easily then as its a data...
  6. Tewy

    X axis labels on a graph

    Go to the information builders website and download the Perspective for Java Programmers Manual (it's an acrobat file) it covers how to changes font sizes, colours, graph types etc. If you can't get at it there, post your e-mail address and I'll forward it to you. As to the angle of axis...
  7. Tewy

    Year Format

    Are you computing the YEAR off the date rather than defining? When you use compute the report automatically includes the field used in the compute in the report. If this is what's causing the problem there are two options: 1. Move your compute into a define 2. Add the field yourself into the...
  8. Tewy

    Graph axis display ... number format

    Hi Wayster, No doubt you have solved this by now, but just in case below is some text from a document I compiled for my own WebFOCUS users on Graphing. This gives the code required to enter into the edit text screen. To control the Y2 axis just change Y1 to Y2. As for controlling Axis titles, I...
  9. Tewy

    One Bar Chart with several BY fields

    You could define a field which concatenates your year field and department field into one field. i.e. if you department field is an A4 and year is an A4 then do DEFINE FILE filename DEPT_YR/A8=YEAR || DEPT; END GRAPH FILE filename SUM TOTAL_EMPLOYEE BY DEPT_YR etc Regards Tewy
  10. Tewy

    Get system date into a specific format

    Try this DATE1/I8=&YYMD; If you want the date in alpha format do DATE1/I8=&YYMD; DATE2/A8=EDIT(DATE1); Regards Tewy
  11. Tewy

    RELEASE THE YEAR OUT OF DATE FIELD

    Hi Oz, As your date field is stored in YYMD format, you can use the following in a define or compute: YEAR/YY=DATE; you can do the same for month or day by changing YY to M or D. Regards Tewy
  12. Tewy

    Grab one record with a condition

    Try this: TABLE FILE filename SUM UNIQUEID BY ORDER# BY HIGHEST 1 STATUS WHERE TOTAL STATUS NE 'Z'; END As 'Z' is higher than 'D' it should return one line per order number, with 'Z' for status if the order number is complete. The Where Total is evaluated after the data has been returned to...
  13. Tewy

    MATCH FILE

    Leo, The basic MATCH syntax is: MATCH FILE filename report request RUN FILE filename report request AFTER MATCH HOLD option END the match is performed on the BY fields used in the report request (which must have the same names). The are seven options to control what records are included in...
  14. Tewy

    join versus match

    Hi Breyt, When I did my focus training (what seems like many years ago now), I was told the following: SET ALL=OFF is the same as MATCH .... OLD-AND-NEW SET ALL=ON is the same as MATCH .... OLD SET ALL=PASS is the same as MATCH .... OLD-NOT-NEW I have never tested the above so I suggest...
  15. Tewy

    DATES SUBTRACTION

    Hi Oz, There are many ways of doing this, I would use the &YYMD function to return the current date, a define for what you want would then look like this: DATE1/YYMD=&YYMD; DATE2/MDYY='11022002'; DIFF/I4=DATEDIF(DATE2, DATE1, 'M'); where DATE2 is the date returned from your HTML form. This...
  16. Tewy

    graph: text rotation

    Hi Eva, The following works for me setTextRotation(getO1Label(),0); it seems from your note that your referring to the X-axis as X (as would seem appropriate) but for most graph types in WebFOCUS (including bar charts) its referred to as the Ordinate axis hence the O above. Regards Tewy

Part and Inventory Search

Back
Top