Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
report layout
 Login/Join
 
Silver Member
posted
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
 
Posts: 34 | Location: Winnipeg, MB | Registered: January 23, 2008Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Expert
posted Hide Post
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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
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
 
Posts: 86 | Location: Chicago | Registered: August 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders