Focal Point
report layout

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7841048182

April 25, 2008, 05:23 PM
Noel
report layout
I hope somebody give me an idea on how to generate a report shown below. I wondering if I need to do this in plain html or in maintain.
Thanks for the help.

Company number . . . . . : 2 VERSATILE
Customer number . . . . . : 18501
Addressee name . . . . . : BUHLER MANUFACTURING
Address line 1 . . . . . : .
2 . . . . . : R.R. #5, 71459 OXFORD 4 3 . . . . . :
City . . . . . . . . . . : WOODSTOCK
State code . . . . . . . : ON ONTARIO
Postal/Country . . . . . : N4S 7V9 CA Tax city/county
Address format . . . . . : 1 City/state/postal/country
Contact name . . . . . . :
Export designator . . . . : N
Telephone/Fax number . . :
Shipping instructions . . :
Shipping location . . . . :
Zone . . . . . . . . . . :
Customer status . . . . . : A
Active
Price book ID . . . . . . :
Price code . . . . . . . . :
Sales representative . . . : 15 CANADIAN HOUSE
Commissionable percent . . : .000
Invoice copies . . . . . : 1
Territory . . . . . . . . :
Customer class . . . . . . :
Variable trade discount . : N
Purchase order required .. : N
Fixed trade disc code . . :
Invoice language format . : 0
Foreign & local language . :
Print backorder quantity . : Y
Print item tax amount . .. : N
Tax suffix . . . . . . . . :
Surcharge code . . . . . . :
Automatic credit hold . . : N
Review invoiceconsolidation: N
Item industry class . . . : VERITEMS
Versatile Idustry Itm Nbr. :
Sales transport terms . . :
Invoice procedure code . . : 0
Market analysis code . . . :
Credit limit amount . . . :
Credit rating . . .. . . . :
Credit check . . . . . . : N
Date last order . . . . . :
Date last payment . . .. . :


Tax ID 1 . . . . . . . . :
Tax ID 2 . . . . . . . . :
Terms . . . . . . . . . . : 3 10th Day - Next Month
Currency ID . . . . . . . :
Personal ledger . . . . . : ARBVICAD
Highest credit limit . . :
Last CR limit change . . :
By user ID . . . . . . . . :
Date customer created . . : 5/08/07
First invoiced . . . . . . :
Backorders . . . . . . . : Y
Pack list . . . .. . . . . : 1
Partial ship . . . . . . : Y
Pack hierarchy . . . . . .: 5
Accept substitute . . . . : Y
Maintenance log . . . . . .: N
Requires adv ship notice . : N

Enterprise code . . . .. . :
Carrier ID . . . . . .. . :
Priority ID . . . . . .. . :
Shipment lead time . .. . : 00
Consolidated shipping . . .: 0
Warehouse . . . . . . .. . :
Stage area . . . . . .. . :
Consolidated packing . . .: 0
Language code . . . . .. . : 001
Default local language . . :
EEC transport mode . .. . :
EEC delivery terms . .. . :
EEC transaction type .. . :

Noel


WebFocus 762 AS400 / DB2
April 25, 2008, 06:35 PM
Darin Lee
So it's just a list of fields and their values?

Just create a fex and put everything in the heading:
TABLE FILE filename
PRINT COMPANY_NUMBER NOPRINT
HEADING
"Company Number:<20><COMPANY_NUMBER"
"Customer Number:<20><CUSTOMER_NUMBER"
"Addressee Name:<20><ADDRESSEE_NAME"
and so on
BY COMPANY_NUMBER PAGE-BREAK
stylesheet stuff here
END

should do the trick. MAINTAIN doesn't really have anything to do with this one, although I suppose you could build a screen to display all of this. Way too much overkill.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
April 25, 2008, 10:47 PM
Leah
As Darin says if it is all just one occurance put in a heading, if something is detail, think about headings and footings. Would be as if you were creating a letter. Output format depends on what you want to use the report for.

Maintain is a tool for 'maintaining' files, not building reports.


Leah
April 27, 2008, 05:58 PM
Waz
The other option is to use OVER

TABLE FILE filename
PRINT COMPANY_NUMBER AS 'Company Number:'
OVER CUSTOMER_NUMBER AS 'Customer Number:'
OVER ADDRESSEE_NAME  AS 'Addressee Name:'
.
.
.
etc
BY COMPANY_NUMBER PAGE-BREAK
END


You can then also use headings and footings as well.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 28, 2008, 09:37 AM
Gizmo
Just to keep the number of possible answers up....(so many ways of doing things)

Try it as a fix form report.
TABLE FILE filename
BY keyfield
HEADING
"Company number.........: <COMPANY_NUMBER"
"Customer number........: <CUSTOMER_NUMBER"
"Addressee name.........: <ADDR_NAME"
...

Output can be done in fixed style (courier font) or you could use styling to make sure that the field shows in a specific position to get alignment correct as well.



Windows: WF 7.6.2: SQL Server 2008 R2