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: *

  1. jimster06

    write external file with webfocus

    The typical WF output syntax begins with a verb such as PRINT or SUM. After identifying the fields to be output, the syntax provides a way of designating the output file format such as ON TABLE PCHOLD FORMAT PDF Looking at the documentation is highly recommended. HTH
  2. jimster06

    Table of quantities by week-ending date should include weeks with zero

    FYI- IB is offering a webinar on this topic on 16 DEC 2010 presented by the renowned Noreen Redden. Check out the Virual User Forum on IB's Web site.
  3. jimster06

    Table of quantities by week-ending date should include weeks with zero

    Yes there is a way to add 'dummy' rows: it is called the MacGyver Technique. It will do what you need. Go over to the Information Builders' site and search for it. Note: you may have to be registered to access this info.
  4. jimster06

    Create a simple date range prompt?

    You might want to try the Crystal Forum for this info.
  5. jimster06

    Aggregate Virtual column in master file.

    If you are building a HOLD file using native SQL then what you are proposing should work for you.
  6. jimster06

    Aggregate Virtual column in master file.

    When you say 'MASTER FILE,' are you referring to the synonym or master file description? Or are you talking about extracting data for subsequent use in reports? If the latter, consider using a multi-verb request. Consider also the use of the TOT. prefix. I would urge caution regarding...
  7. jimster06

    WebFOCUS or SQL Stored Procedure?

    It has been my preference to let SQL do what it does best, extract data, and let WebFOCUS do what it does best;ie, accumulate, analyze, style, and present data in varios formats. That being said, I still like having MFDs (Master File Descriptions) available for each table for the quick and irty...
  8. jimster06

    HYYMDS CALCULATION

    There is a wealth of functions in WebFOCUS that deal with H format date-time data. They are listed in the Functions manual and in another book, (Almost) 1001 Ways to Work With DATES in WebFOCUS. Having said that, just what do you want to do with the date and I can be more specific.
  9. jimster06

    WEBFOCUS COLUMN-TOTAL

    This is a well-known issue with FOCUS and WebFOCUS. You can address it by defining a blank one-byte field and doing your major sort on it. Then ON MYBLANKFLD COLUMN-TOTAL AS ' HTH
  10. jimster06

    Combining numbers from two seperate columns

    Yes - that is the info that I was seeking. When you use EDIT(AGENCY_SALES_V.AGENCY_SALES_V.MTH, '99'), you are telling WF to get the FIRST two bytes of the field, hence the zeroes in your answer. This being a numeric field, the information is right justified and you would want the last two...
  11. jimster06

    Creating Columns

    Kerry- Have you considered a DEFINE? something like DEFINE FILE INPUT SALES2007/P12 = IF YEAR EQ '2007' THEN SALES ELSE 0; SALES2008/P12 = IF YEAR EQ '2008' THEN SALES ELSE 0; SALESDIFF/P12 = SALES2008 - SALES2007; END TABLE FILE INPUT SUM SALES2007 AS '2007,SALES' SALES2008 AS '2008,SALES'...
  12. jimster06

    Combining numbers from two seperate columns

    Kerry- What are the Master File Descriptions (MFD) of the fields in question? ie what is the format? Actual and Usage? Length? This will help us answer your question.
  13. jimster06

    Convert Alpha to Integer

    You request shows 20070215 for an I11 field; how is the rest of the field filled? &YYMD should return integer values 20080212 for today. This is a legacy date format. Is the field in question a standard date? (We once called them smart dates.) Or is it a date/time stamp?
  14. jimster06

    Help.. report to count rows based on criteria..

    How about DEFINE FILE TABLE1 TYPE1/I5 = IF TYP-IND EQ '1' THEN 1 ELSE 0; TYPE2/I5 = IF TYP-IND EQ '2' THEN 1 ELSE 0; TYPE3/I5 = IF TYP-IND EQ '3' THEN 1 ELSE 0; TYPE4/I5 = IF TYP-IND EQ '4' THEN 1 ELSE 0; END TABLE FILE TABLE1 SUM TYPE1 TYPE2 TYPE3 TYPE4 BY EFF-DATE AS "WEEK ENDING" etc You...
  15. jimster06

    Concatonating 7 string and 1 numeric field

    If the numeric is an integer the EDIT(IntField) should work. If number is floating point then FTOA (Float to Alpha) or DTOA (Double to Alpha) should work.
  16. jimster06

    Concatonating 7 string and 1 numeric field

    Using the GUI would make this fairly straight-forward but... The concatenation operator comes in two flavors: 1) | weak concatenation 2) || hard concatenation The difference is that the hard concatenation will move trailing blanks to the end of the concatenated string but weak concatenation...
  17. jimster06

    one to many, how to select specific record?

    You should have access to online documentation with your WF install. Click on HELP.
  18. jimster06

    Adding Rows that don't exist

    Have you considered McGyver technique?
  19. jimster06

    Number of Days between Today and a Date Field

    &DATEMDYY brings back a date with separators eg mm/dd/yyyy. DATEDIF is expecting date in format YYMD (or some variation there of), ths so-called standard date or what we once called a 'smart date' so first make sure that both of your date parms are in standard format.
  20. jimster06

    Number of Days between Today and a Date Field

    Leo- Are the formats for ALLOCATED_DT and &DATEMDYY the same?

Part and Inventory Search

Back
Top