Search results for query: *

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

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

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

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

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

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

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

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!

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