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

    Can I create a JOIN which uses two different keys depending on a field in the file?

    I have a file which contains records of invoices from two different sources. One of the sources has a field for the year that the product invoiced was created, and the other one has that field blank. I want to join this file to another one, using a key that includes the year if the invoice...
  2. ekl0908

    Subtotals by different fields sorted independently

    I have completed the report using workfiles as I outlined above. It works! [wiggle] [wavey2]
  3. ekl0908

    Subtotals by different fields sorted independently

    Thank you for your response, sxscheck! I would like to print the same set of subtotals for all users. I have thought of a way to do this: Create workfiles, each sorted by a field called SORTFIELD which is the same length. In one workfile, make the sortfield the size, in another workfile it...
  4. ekl0908

    Subtotals by different fields sorted independently

    Can I subtotal the same amount by four different fields on the same report, using WebFOCUS 7? Not with a nested sort, but four independent sorts. The situation is that we have a report that gives a grand total of sales and then a choice of subtotals. To use the hypothetical example of car...
  5. ekl0908

    Is there a maximum length for an index field?

    Hi All, Does anyone know the maximum size of an index field? I don’t mean the field name, but the size of the field itself. For example, if I was creating a table as follows: ON TABLE HOLD AS YTD_SALES FORMAT FOCUS INDEX STYLE SIZE COLOR And the fields had been defined this way: STYLE/A30...
  6. ekl0908

    Cannot get report to print on legal size paper

    I am printing a report which is formatted as follows: ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * TYPE=REPORT , GRID=OFF, UNITS=INCHES,SQUEEZE=ON, PAGESIZE='Legal', LEFTGAP=0, ORIENTATION=LANDSCAPE, TITLETEXT='&TITLETEXT ',$ The report is printing on letter size, even though it says...
  7. ekl0908

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

    I am printing a report of quantities by week-ending date, using the ACROSS function. This is the code that prints the report: BY STYLE_DESC AS ‘ ‘ ACROSS weekseqn NOPRINT ACROSS Saturday AS ‘ ‘ ON TABLE SUMMARIZE AS ‘ ‘ This correctly prints the quantities for each week that has...
  8. ekl0908

    Suppress subtotals on only one column

    When I try SUMMARIZE MULTILINES, it prints a subtotal for each BY field. I ended up using ON CUSTOMERNAME SUBTOTAL MULTILINES FIELD1 FIELD3 FIELD4. The only fields that print subtotals then are the one I specified. Thank you for your help!
  9. ekl0908

    Suppress subtotals on only one column

    I'm working on a report which calculates the average price as follows: -COMPUTE AVG-PRC/P12.2SM = PRODUCT_VALUE/UNITS_PACKED; AS 'Avg,Price' The output should have subtotals for the units packed and the amount, but not for the average price. Originally, I used a SUBTOTAL MULTILINES...

Part and Inventory Search

Back
Top