Focal Point
Output formate like this

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

September 11, 2011, 05:23 AM
Deepu
Output formate like this
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
September 11, 2011, 09:54 AM
jimster06
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
September 13, 2011, 12:45 AM
Rahul Jain
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
/TR
/body
/html
head
Similarly all other columns.


Rahul Jain,
India

WebFOCUS 7.6
Windows, All Outputs
September 13, 2011, 01:18 AM
<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

September 13, 2011, 05:47 AM
Deepu
Thanks a lot


WebFOCUS 7.6
Windows, All Outputs
September 13, 2011, 04:18 PM
Doug
You could also use POSITION within your style sheet.
September 15, 2011, 06:48 AM
Deepu
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
September 15, 2011, 09:51 AM
<FreSte>
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

September 19, 2011, 04:48 AM
Deepu
Hi

The above code is not working


WebFOCUS 7.6
Windows, All Outputs
September 19, 2011, 05:19 AM
<FreSte>
A little more info might be helpfull.
September 19, 2011, 01:04 PM
Deepu
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
September 19, 2011, 03:21 PM
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..
September 19, 2011, 03:47 PM
<FreSte>
Good spot Doug; I missed that one Wink
September 20, 2011, 12:47 AM
Deepu
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