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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Output formate like this

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Output formate like this
 Login/Join
 
Deepu
Gold member
posted
Hi

I'm new to webfocus please help me

i need Output format like this 
 
                      Employee Details
------------------------------------------------------------------------

Emp ID : 112847612                   HireDate : 01/07/81
Name   : Mary_Smity                  CJob Code: B14
Dept   : Mis                         Skils    : FIQU
Job Des: File Quality
Skils Des:Insure File Integrity

Bank Acct: --
Bank Code: --
Bank Name: --
CurSal : $13,200.00  


Can any please help me by giving sample code with 

TABLE FILE  EMPLOYEE
PRINT 
 EMP_ID
 COMPUTE NAME/A100=FIRST_NAME||'_'||LAST_NAME ;
 HIRE_DATE
 DEPARTMENT
 CURR_SAL
 CURR_JOBCODE
 BANK_NAME
 BANK_CODE
 BANK_ACCT
 JOB_DESC
 SKILLS
 SKILL_DESC	
WHERE EMP_ID EQ '112847612'
END

This message has been edited. Last edited by: Deepu,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Report This Post
jimster06
Guru
posted Hide Post
Look for Designing a Free-Form Report in the Creating Reports documentation; this will provide the solution to your requirement.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post

/TR
/body
/html
head
Similarly all other columns.


Rahul Jain,
India

WebFOCUS 7.6
Windows, All Outputs
Rahul Jain
Member
posted Hide Post
Hi Deepu Plz go through below steps :-

Step 1 :-
TABLE FILE EMPLOYEE
PRINT
EMP_ID
COMPUTE NAME/A100=FIRST_NAME||'_'||LAST_NAME ;
HIRE_DATE
DEPARTMENT
CURR_SAL
CURR_JOBCODE
BANK_NAME
BANK_CODE
BANK_ACCT
JOB_DESC
SKILLS
SKILL_DESC
WHERE EMP_ID EQ '112847612'
ON TABLE HOLD AS HLD_EMPDTL
END
-RUN

TABLE FILE HLD_EMPDTL

EMP_ID/A20
NAME/A100
HIRE_DATE/A20
DEPARTMENT/A20
CURR_SAL/A20
CURR_JOBCODE/A20
BANK_NAME/A20
BANK_CODE/A20
BANK_ACCT/A20
JOB_DESC/A20
SKILLS/A20
SKILL_DESC/A20
ON TABLE SAVE AS HLD_EMPDTLF
END
-RUN

step 2 :- READ ALL THE COLUMNS IN VARIABLE

AS BELOW

-READ HLD_EMPDTLF &EMP_ID.A20 &NAME.A100

SIMLARLY FOR ALL....

STEP 3 :- DISPLAYING

USE HTML
html
head
body
TR
TD
Employee ID :-
 &EMP_ID
 
Posts: 1 | Registered: February 09, 2011Report This Post
<FreSte>
posted
Deepu,

Try this (I used a HOLD-file, but you can do it directly from the EMPLOYEE master file)


TABLE FILE  EMPLOYEE
PRINT
 EMP_ID
 COMPUTE NAME/A100=FIRST_NAME||'_'||LAST_NAME ;
 HIRE_DATE
 DEPARTMENT
 CURR_SAL
 CURR_JOBCODE
 BANK_NAME
 BANK_CODE
 BANK_ACCT
 JOB_DESC
 SKILLS
 SKILL_DESC
WHERE EMP_ID EQ '112847612'
ON TABLE HOLD
END

SET PAGE=NOPAGE
SET HTMLCSS = ON

TABLE FILE HOLD
HEADING
"                      Employee Details "
"-----------------------------------------------------------------------------------------------------------------------"
"Emp ID <+0> : <EMP_ID  <+0> Hiredate <+0 : <HIRE_DATE"
"Name <+0>  : <NAME     <+0> Jobcode <+0> : <CURR_JOBCODE"
"etc etc etc"     
ON TABLE SET STYLE *
-*TYPE=REPORT   ,HFREEZE=TOP ,SCROLLHEIGHT=4                ,$
TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
TYPE=REPORT     ,BORDER=1    ,BORDER-COLOR=RGB(210 210 210) ,$
TYPE=DATA       ,TOPGAP=2    ,BOTTOMGAP=2                   ,$
TYPE=DATA     ,BACKCOLOR=(RGB(255 255 255) RGB(245 245 245)),$

TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, WIDTH=500,SIZE=12,$
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, WIDTH=500,$
TYPE=HEADING, OBJECT=TEXT  ,ITEM=1, WIDTH=50,$
TYPE=HEADING, OBJECT=FIELD ,ITEM=1, WIDTH=150,$
TYPE=HEADING, OBJECT=TEXT  ,ITEM=4, WIDTH=50,$
ENDSTYLE
END
 
Report This Post
Deepu
Gold member
posted Hide Post
Thanks a lot


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Report This Post
Doug
Expert
posted Hide Post
You could also use POSITION within your style sheet.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Deepu
Gold member
posted Hide Post
quote:
Originally posted by FreSte:
Deepu,

Try this (I used a HOLD-file, but you can do it directly from the EMPLOYEE master file)


TABLE FILE  EMPLOYEE
PRINT
 EMP_ID
 COMPUTE NAME/A100=FIRST_NAME||'_'||LAST_NAME ;
 HIRE_DATE
 DEPARTMENT
 CURR_SAL
 CURR_JOBCODE
 BANK_NAME
 BANK_CODE
 BANK_ACCT
 JOB_DESC
 SKILLS
 SKILL_DESC
WHERE EMP_ID EQ '112847612'
ON TABLE HOLD
END

SET PAGE=NOPAGE
SET HTMLCSS = ON

TABLE FILE HOLD
HEADING
"                      Employee Details "
"-----------------------------------------------------------------------------------------------------------------------"
"Emp ID <+0> : <EMP_ID  <+0> Hiredate <+0 : <HIRE_DATE"
"Name <+0>  : <NAME     <+0> Jobcode <+0> : <CURR_JOBCODE"
"etc etc etc"     
ON TABLE SET STYLE *
-*TYPE=REPORT   ,HFREEZE=TOP ,SCROLLHEIGHT=4                ,$
TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
TYPE=REPORT     ,BORDER=1    ,BORDER-COLOR=RGB(210 210 210) ,$
TYPE=DATA       ,TOPGAP=2    ,BOTTOMGAP=2                   ,$
TYPE=DATA     ,BACKCOLOR=(RGB(255 255 255) RGB(245 245 245)),$

TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, WIDTH=500,SIZE=12,$
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, WIDTH=500,$
TYPE=HEADING, OBJECT=TEXT  ,ITEM=1, WIDTH=50,$
TYPE=HEADING, OBJECT=FIELD ,ITEM=1, WIDTH=150,$
TYPE=HEADING, OBJECT=TEXT  ,ITEM=4, WIDTH=50,$
ENDSTYLE
END



HI

colud u plz tell me in excel how to position in paticular place of that items

between item i need a space in exl2k formate

Thnaks


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Report This Post
<FreSte>
posted
OK, try this. It's another way of doing it

SET PAGE=NOPAGE
SET HTMLCSS = ON

DEFINE FILE EMPLOYEE
  COLON/A1     = ':';
  SEPERATOR/A1 = '';
  NAME/A100    = FIRST_NAME||'_'||LAST_NAME ;
END

TABLE FILE EMPLOYEE
HEADING
"Employee Details "
  PRINT
    COLON        AS 'Emp_id'
    EMP_ID       AS ''
    SEPERATOR    AS ''
    COLON        AS 'Hiredate'
    HIRE_DATE    AS '' OVER

    COLON        AS 'Name'
    NAME         AS ''
    SEPERATOR    AS ''
    COLON        AS 'Jobcode'
    CURR_JOBCODE AS '' OVER
  WHERE EMP_ID EQ '112847612';
  ON TABLE PCHOLD FORMAT EXL2K
  
  ON TABLE SET STYLE *
    TYPE=HEADING, SIZE=14, STYLE=BOLD,$
    TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
    TYPE=REPORT     ,BORDER=0    ,BORDER-COLOR=RGB(210 210 210) ,$
    TYPE=DATA       ,TOPGAP=2    ,BOTTOMGAP=2                   ,$
    TYPE=DATA       ,COLUMN=SEPERATOR, WIDTH=60,$
  ENDSTYLE
END
 
Report This Post
Deepu
Gold member
posted Hide Post
Hi

The above code is not working


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Report This Post
<FreSte>
posted
A little more info might be helpfull.
 
Report This Post
Deepu
Gold member
posted Hide Post
Hi

This code is generating html output

TABLE FILE EMPLOYEE
PRINT
EMP_ID
COMPUTE NAME/A100=FIRST_NAME||'_'||LAST_NAME ;
HIRE_DATE
DEPARTMENT
CURR_SAL
CURR_JOBCODE
BANK_NAME
BANK_CODE
BANK_ACCT
JOB_DESC
SKILLS
SKILL_DESC
WHERE EMP_ID EQ '112847612'
ON TABLE HOLD
END

SET PAGE=NOPAGE
SET HTMLCSS = ON

TABLE FILE HOLD
HEADING
" Employee Details "
"-----------------------------------------------------------------------------------------------------------------------"
"Emp ID <+0> : Hiredate <+0 : "Name <+0> : Jobcode <+0> : "etc etc etc"
ON TABLE SET STYLE *
-*TYPE=REPORT ,HFREEZE=TOP ,SCROLLHEIGHT=4 ,$
TYPE=REPORT ,UNITS=PTS ,FONT='VERDANA', SIZE=8 ,$
TYPE=REPORT ,BORDER=1 ,BORDER-COLOR=RGB(210 210 210) ,$
TYPE=DATA ,TOPGAP=2 ,BOTTOMGAP=2 ,$
TYPE=DATA ,BACKCOLOR=(RGB(255 255 255) RGB(245 245 245)),$

TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, WIDTH=500,SIZE=12,$
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, WIDTH=500,$
TYPE=HEADING, OBJECT=TEXT ,ITEM=1, WIDTH=50,$
TYPE=HEADING, OBJECT=FIELD ,ITEM=1, WIDTH=150,$
TYPE=HEADING, OBJECT=TEXT ,ITEM=4, WIDTH=50,$
ENDSTYLE
END


i need same format in excel format


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Report This Post
Doug
Expert
posted Hide Post
Deepu,
quote:
The above code is not working
Remove the last "OVER" in "CURR_JOBCODE AS '' OVER" from FreSte's post and try again..
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
<FreSte>
posted
Good spot Doug; I missed that one Wink
 
Report This Post
Deepu
Gold member
posted Hide Post
quote:
Originally posted by Doug:
Deepu,
quote:
The above code is not working
Remove the last "OVER" in "CURR_JOBCODE AS '' OVER" from FreSte's post and try again..


i'm not getting proper way

can you plz show sample code for that

how to do


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Output formate like this

Copyright © 1996-2020 Information Builders