Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 07, 2016, 05:29 PM
Waz
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 08, 2016, 05:05 AM
User1
Hi ,
Sorry the content in my last post were not much clear.
This is the output format I needed,
Report output format ---
Order :101
TRANS_TYPE QUALIFIER CURRENCY MULTIPLE QTY SERIAL_NUMBER VALUE PRODUCT_TOTAL EXCHANGE_RATE CHARGES
Sell ABC USD 1600 1.21 0.0
1*30 10 AB123 500
1*50 20 PQ123 1100
Order:102
TRANS_TYPE QUALIFIER CURRENCY MULTIPLE QTY SERIAL_NUMBER VALUE PRODUCT_TOTAL EXCHANGE_RATE CHARGES
Sell ABC1 USD 600 1.21 0.0
1*10 5 AB1123 100
1*20 1 PQ1123 500
Below is the code I have tried but not getting the exact result.
SET SHOWBLANKS = ON
TABLE FILE TEST_DATA
-*BY ACCOUNT_NUMBER NOPRINT
-*BY USER NOPRINT
-*BY DATE NOPRINT
BY ORDER NOPRINT
BY TRANS_TYPE NOPRINT
BY QUALIFIER NOPRINT
BY ISSUER NOPRINT
BY PRODUCT NOPRINT
BY CURRENCY NOPRINT
ON ORDER SUBHEAD
" Order: <ORDER Transaction Type: <TRANSACTION_TYPE"
"______________________________________________________________________________________________________________________________________________"
"Trans type Qualifier Issuer Product Currency Multiple Quantity Serial Number Value Product Total Exchange Rate EUR Charges"
"<TRANS_TYPE <QUALIFIER <ISSUER <PRODUCT <CURRENCY <MULTIPLE <QTY <SERIAL_NUMBER <VALUE <PRODUCT_TOTAL <EXCHANGE_RATE <EUR <CHARGES "
ON TABLE SET PAGE-NUM OFF
-*ITS=IN,
-*UEEZE=ON,
-*ORIENTATION=PORTRAIT,
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
-*INCLUDE = IBFS:/EDA/STP/_EDAHOME/ETC/endeflt.sty,
$
END
Please provide your suggestion!!
Thanks, User1This message has been edited. Last edited by: User1,
WebFOCUS 8 Windows, All Outputs
March 08, 2016, 05:20 AM
User1
Also, I missed ENDSTYLE tag is above code. That tag I have included.
WebFOCUS 8 Windows, All Outputs
March 08, 2016, 03:48 PM
Waz
Are the fields, MULTIPLE QTY SERIAL_NUMBER VALUE, repeating values and the rest in the heading ?