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
Allignment Issues
 Login/Join
 
Platinum Member
posted
Goog Morning,

I am having issues with trying to get my data fields to align up properly...I am attempting to get everything to align up 2 spaces to the right of bus prin hom addr1 on the 1st data column and 4 spaces to the right of Merch website on the second data column. I am also attempting to shade the background in grey for the row that is peoduced in Red. If anyone could assist I would greatly appreciate the help. Thanks

 TABLE FILE DISSUBREG
HEADING
"Discover Submitted Registration Report"
" "
"<+10>Report Date: &TODAY <+10>Source File Timestamp:<+0><discredtm"
"Bank:<+0><disbank
" "
"Page <TABPAGENO of <TABLASTPAGE "
PRINT
discreuser      AS 'Operator:        ;'     disdbanam     AS 'DBA Name:'      OVER IN 38
DATASRCDESC     AS 'Data Source - Desc:'         disdbaress1   AS 'DBA Addr 1:'    OVER IN 38
dissubdtm       AS 'Reg Submit Date:'            disdbaress2   AS 'DBA Addr 2:'    OVER IN 38
disrectype      AS 'Record Type - Desc:'         disdbacity    AS 'DBA City:     '      OVER IN 38
disconvmrch     AS 'Converted Discover Acct Nbr' disstate      AS 'DBA State:'     OVER IN 38
dismcc          AS 'MCC:'                        disdbazip     AS 'DBA Zip:'       OVER IN 38
MERCHSTATDESC   AS 'Merch Status - Desc:'        disdbactry    AS 'DBA Ctry:'      OVER IN 38
dismrchstatupdt AS 'Merch Status Date:'          disdbaphn     AS 'DBA Phone:'     OVER IN 38
MERCHTYPEDESC   AS 'Merch Type - Desc:'          disemail      AS 'DBA Email:'     OVER IN 38
LABEL10B LABEL10C                                disurl        AS 'Merch Website:' OVER IN 38
LABEL11 AS ' ' OVER
BUSTYPEDESC     AS 'Bus Type - Desc:'            distaxid      AS 'Tax ID:'         OVER IN 38
dishdqacct      AS 'HQ Acct Nbr:'                dislegalnam   AS 'Legal Bus Name:' OVER IN 38
disbusfrnam     AS 'Bus contact First:'          disdbaress1   AS 'Bus Addr 1:'     OVER IN 38
disbusltnam     AS 'Bus Contact Last:'           disbusress2   AS 'Bus Addr 2:'     OVER IN 38
disbusprnfnam   AS 'Bus Principal First:'        disbusprncity AS 'Bus City:'       OVER IN 38
disbusprnlnam   AS 'Bus Principal Last:'         disbusstate   AS 'Bus State:'      OVER IN 38
disbusprntinam  AS 'Bus Principal Title:'        disbuszip     AS 'Bus Zip:'        OVER IN 38
disbusprnress1  AS 'Bus Principal Home Addr 1:'  disbusprnctry AS 'Bus Ctry:'       OVER IN 38
disbusprnress2  AS 'Bus Principal Home Addr 2:'  OVER
disbusprncity   AS 'Bus Principal Home City:'   OVER
disbusprnstate  AS 'Bus Principal Home State:'  OVER
disbusprnzip    AS 'Bus Principal Home Zip'     OVER
disbusctry      AS 'Bus Principal Home City:'   OVER
MASKSSN         AS 'Bus Principal SSN
BY disacqid NOPRINT
ON disacqid SUBHEAD
"Acquirer ID<+5><disacqid <+20>Discover Acct Nbr<+1><dismchnum"
" "
"Acquirer ID: Disc Acct Nbr:"
FOOTING BOTTOM
" "
"Page <TABPAGENO of <TABLASTPAGE "
ON disacqid SKIP-LINE
ON TABLE PCHOLD AS &HOLDNAME1 FORMAT PDF
-*ON TABLE HOLD AS &HOLDNAME1 FORMAT PDF
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=9,FONT='ARIAL',ORIENTATION=LANDSCAPE,SQUEEZE=ON,GRID=OFF,$
TYPE=HEADING,LINE=1,STYLE=UNDERLINE,$
-*TYPE=HEADING,LINE=3,BACKGROUND=GREY,$
TYPE=HEADING,LINE=3,color=red,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=CENTER,$
TYPE=TABHEADING,LINE=2,JUSTIFY=CENTER,$
ENDSTYLE
END
-EXIT 




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Virtuoso
posted Hide Post
You are mixing HTML coding in a PDF report. That is the basic problem.

Can you try this (or something like this) with the CAR database.

It is easier to copy and see what we get here.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Platinum Member
posted Hide Post
Let's say in this example I wanted my
number values to show up under the "T" in the header lable "Transmission #"

-* File alingmment.fex
DEFINE FILE CAR
REC_CNT/I5 WITH DCOST            =  1;
NRCOST/D10.2=RCOST;
END
TABLE FILE CAR
HEADING
"Report Heading"
"Last Logon: 2006/02/24"
" "
"Filter Summary"
"Reporting Area:  <10>  ACH   <30>   Bank Number(s):     <40>3865"
"Report Name:     <10>  Mis-qualified ACH Exceptions     <30>   Association ID:
<40>"
"Date:            <10>  09/01/2005   <30>   Merchant ID:        <40>"
"Plan Type:       <10>     <30>   Tran Code:          <40>"
"Run #:           <10>     <30>   Transmission #:     <40>"
" "
-*
PRINT
DCOST    AS 'Merchant ID' OVER
SEATS    AS 'Assoc ID'    OVER
HEIGHT   AS 'Ref Number'  OVER 
WEIGHT   AS 'Vendor'      OVER
MPG      AS 'Tran Code'   OVER
SALES    AS 'Plan'        OVER
NRCOST   AS 'Net Deposit'  
BY DCOST NOPRINT
ON  DCOST SUBFOOT
"Number of Records: <ST.REC_CNT>"

-*WHERE COUNTRY EQ 'ENGLAND'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,     FONT=HELVETICA,
SIZE=8,ORIENTATION=PORTRAIT,GRID=OFF,SQUEEZE=ON,$
TYPE=HEADING,    LINE=1,         JUSTIFY=RIGHT,$
TYPE=HEADING,    LINE=2,         JUSTIFY=RIGHT,$
TYPE=FOOTING,    CLASS=WHITEROW, JUSTIFY=CENTER,$
TYPE=SUBFOOT,LINE=1,ITEM=1,OBJECT=TEXT,POSITION=SEATS,$
TYPE=SUBFOOT,LINE=1,ITEM=1,OBJECT=FIELD,POSITION=WEIGHT,JUSTIFY=RIGHT,$
TYPE=SUBFOOT,LINE=2,ITEM=1,OBJECT=TEXT,POSITION=SALES,$
TYPE=SUBFOOT,LINE=2,ITEM=1,OBJECT=FIELD,POSITION=NRCOST,JUSTIFY=RIGHT,$
ENDSTYLE
END  




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Virtuoso
posted Hide Post
Try putting the fields in a SUBHEAD instead of using the OVER command.

-* File alingmment.fex
DEFINE FILE CAR
REC_CNT/I5 WITH DCOST = 1;
NRCOST/D10.2=RCOST;
END
TABLE FILE CAR
HEADING
"Report Heading"
"Last Logon: 2006/02/24"
" "
"Filter Summary"
"Reporting Area: <10> ACH <30> Bank Number(s): <40>3865"
"Report Name: <10> Mis-qualified ACH Exceptions <30> Association ID:
<40>"
"Date: <10> 09/01/2005 <30> Merchant ID: <40>"
"Plan Type: <10> <30> Tran Code: <40>"
"Run #: <10> <30> Transmission #: <40>"
" "
PRINT DCOST NOPRINT
BY DCOST NOPRINT
ON DCOST SUBHEAD
"Merchant ID <DCOST "
"Assoc ID <SEATS "
"Ref Number <HEIGHT"
"Vendor <WEIGHT"
"Tran Code <MPG "
"Plan <SALES "
"Net Deposit <NRCOST"
"Number of Records: <ST.REC_CNT>"


-*WHERE COUNTRY EQ 'ENGLAND'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=HELVETICA,
SIZE=8,ORIENTATION=PORTRAIT,GRID=OFF,SQUEEZE=ON,$
TYPE=HEADING, LINE=1, JUSTIFY=RIGHT,$
TYPE=HEADING, LINE=2, JUSTIFY=RIGHT,$
TYPE=FOOTING, CLASS=WHITEROW, JUSTIFY=CENTER,$

TYPE=SUBHEAD, OBJECT=TEXT, ITEM=1, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=1, WIDTH=0.50, JUSTIFY=RIGHT,$


ENDSTYLE
END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Platinum Member
posted Hide Post
Mickey I tryed this and it totaly changed the format of my report. I believe I need to use the "over" as my requirements dictate my report be laid out in that manor....I am just trying to position the data for a field that had been retrieved

-* File alingmment.fex
DEFINE FILE CAR
REC_CNT/I5 WITH DCOST            =  1;
NRCOST/D10.2=RCOST;
END
TABLE FILE CAR
HEADING
"Report Heading"
"Last Logon: 2006/02/24"
" "
"Filter Summary"
"Reporting Area:  <10>  ACH   <30>   Bank Number(s):     <40>3865"
"Report Name:     <10>  Mis-qualified ACH Exceptions     <30>   Association ID:
<40>"
"Date:            <10>  09/01/2005   <30>   Merchant ID:        <40>"
"Plan Type:       <10>     <30>   Tran Code:          <40>"
"Run #:           <10>     <30>   Transmission #:     <40>"
" "
-*
PRINT
DCOST    AS 'Merchant ID' 
SEATS    AS 'Assoc ID'    
HEIGHT   AS 'Ref Number'  
WEIGHT   AS 'Vendor'      
MPG      AS 'Tran Code'   
SALES    AS 'Plan'        
NRCOST   AS 'Net Deposit'
BY DCOST NOPRINT
ON  DCOST SUBFOOT
"Number of Records: <ST.REC_CNT>"

-*WHERE COUNTRY EQ 'ENGLAND'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,     FONT=HELVETICA,
SIZE=8,ORIENTATION=PORTRAIT,GRID=OFF,SQUEEZE=ON,$
TYPE=HEADING,    LINE=1,         JUSTIFY=RIGHT,$
TYPE=HEADING,    LINE=2,         JUSTIFY=RIGHT,$
TYPE=FOOTING,    CLASS=WHITEROW, JUSTIFY=CENTER,$
TYPE=SUBFOOT,LINE=1,ITEM=1,OBJECT=TEXT,POSITION=SEATS,$
TYPE=SUBFOOT,LINE=1,ITEM=1,OBJECT=FIELD,POSITION=WEIGHT,JUSTIFY=RIGHT,$
TYPE=SUBFOOT,LINE=2,ITEM=1,OBJECT=TEXT,POSITION=SALES,$
TYPE=SUBFOOT,LINE=2,ITEM=1,OBJECT=FIELD,POSITION=NRCOST,JUSTIFY=RIGHT,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=1, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=1, WIDTH=0.50, JUSTIFY=RIGHT,$
-*
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=2, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=2, WIDTH=0.50, JUSTIFY=RIGHT,$
-*
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=3, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=3, WIDTH=0.50, JUSTIFY=RIGHT,$
-*
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=4, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=4, WIDTH=0.50, JUSTIFY=RIGHT,$
-*
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=5, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=5, WIDTH=0.50, JUSTIFY=RIGHT,$
-*
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=6, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=6, WIDTH=0.50, JUSTIFY=RIGHT,$
-*
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=7, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=FIELD, ITEM=7, WIDTH=0.50, JUSTIFY=RIGHT,$
ENDSTYLE
END  




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
OH....I see now...let me give this a shot...

Thanks




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
I don't know...just cant seem to get this to look like I need it to look...I may have sent you a bad car example because my report is to have two columns of lables and 1 column of data for each row...this is why I choose to use the "over" command. I almost have is working (basically it is working) just not able to line up the data for the lables...I'm still lost.

discreuser      AS 'Operator:'     disdbanam     AS 'DBA Name:'      OVER IN 38
DATASRCDESC     AS 'Data Source - Desc:'         disdbaress1   AS 'DBA Addr 1:' OVER IN 38
dissubdtm       AS 'Reg Submit Date:'            disdbaress2   AS 'DBA Addr 2:' OVER IN 38
disrectype      AS 'Record Type - Desc:'         disdbacity    AS 'DBA City:' OVER IN 38  




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Virtuoso
posted Hide Post
To use the SUBHEAD you need to put your fields and labels in the the text of a SUBHEAD and remove them from the PRINT statement. Try looking again at the code example I posted.

Here's another example showing multiple columns.

DEFINE FILE CAR
REC_CNT/I5 WITH DCOST = 1;
NRCOST/D10.2=RCOST;
END
TABLE FILE CAR
HEADING
"Report Heading"
"Last Logon: 2006/02/24"
" "
"Filter Summary"
"Reporting Area: <10> ACH <30> Bank Number(s): <40>3865"
"Report Name: <10> Mis-qualified ACH Exceptions <30> Association ID:
<40>"
"Date: <10> 09/01/2005 <30> Merchant ID: <40>"
"Plan Type: <10> <30> Tran Code: <40>"
"Run #: <10> <30> Transmission #: <40>"
" "
PRINT DCOST NOPRINT
BY DCOST NOPRINT
ON DCOST SUBHEAD
"Merchant ID <DCOST <+0>Assoc ID <SEATS"
"Ref Number <HEIGHT <+0>Vendor <WEIGHT"
"Tran Code <MPG <+0>Plan <SALES"
"Net Deposit <NRCOST <+0>Number of Records: <ST.REC_CNT>"

-*WHERE COUNTRY EQ 'ENGLAND'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=HELVETICA,
SIZE=8,ORIENTATION=PORTRAIT,GRID=OFF,SQUEEZE=ON,$
TYPE=HEADING, LINE=1, JUSTIFY=RIGHT,$
TYPE=HEADING, LINE=2, JUSTIFY=RIGHT,$
TYPE=FOOTING, CLASS=WHITEROW, JUSTIFY=CENTER,$

TYPE=SUBHEAD, OBJECT=TEXT, WIDTH=3.00,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=2, WIDTH=0.50,$
TYPE=SUBHEAD, OBJECT=FIELD, WIDTH=0.50, JUSTIFY=RIGHT,$

ENDSTYLE
END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Platinum Member
posted Hide Post
Mickey....

I love you !!!! Smiler




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
Thank's very Frank and Mickey for your help ...




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Virtuoso
posted Hide Post
tlbrydie2,

Your welcome. Two things that may be useful to do:

1) Read the two articles I wrote about HTML and PDF report design. the second one covers stuff in the examples I posted.

2) If you are at Summit, attend my presentation on HTML and PDF report design. This will cover the material from article #1.

Go to the following web page and scroll down to Formatting Reports. there you will find Part I and Part II.

http://www.informationbuilders.com/support/developers/index.html


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Platinum Member
posted Hide Post
Mickey (or Anyone). I sorry to bother you with this again but I'm having issues. I am trying to produce a very simular report using the same methodology you sopke of the other day...the method works for the other report but does not seem to work for this report. Could you please assist me?

Thanks


 
This does not work...
 
SET COMPOUND='NOBREAK'

TABLE FILE DISRESPFIL20
PRINT rsp20disacqid NOPRINT
BY rsp20disacqid NOPRINT
-*BY rsp20rectype NOPRINT
-*BY rsp20dismchnum NOPRINT
ON rsp20disacqid SUBHEAD NOPRINT
"Acquirer Name:<rsp20acqname    <+0>Bus Principal First:<rsp20busprnfnam"
"Tax ID:<rsp20taxid             <+0>Bus Principal Last:<rsp20busprnlnam"
"Open Date:<rsp20opendt         <+0>Bus Principal SSN:<RSP20SSN"
"Closed Date:<rsp20clsddt       <+0>Bus Principal Home addr 1::<rsp20busprnad1"
"Fraudulent Closure:<+0>        <+0> <+0>"
"Reason - Desc:<FRAUD20DESC     <+0>Bus Principal Home Addr 2:<rsp20dbaadd2"
"MCC:<rsp20merchcat             <+0>Bus Principal Home City:<rsp20dbacity"
"DBA Name:<rsp20dbaname         <+0>Bus Principal Home State:<rsp20dbastate"
"DBA ADDR 1:<rsp20dbaadd1       <+0>Bus Principal Home Zip:<rsp20dbazip"
"DBA ADDR 2:<rsp20dbaadd2       <+0><+0>"
"DBA City:<rsp20dbacity         <+0><+0>"
"DBA State:<rsp20dbastate       <+0><+0>"
"DBA Zip:<rsp20dbazip           <+0><+0>"
"DBA Ctry:<rsp20dbactry         <+0><+0>"
"DBA Phone:<rsp20dbaphon        <+0><+0>"
BY rsp20disacqid NOPRINT
BY rsp20rectype NOPRINT
BY rsp20dismchnum NOPRINT
HEADING
" "
"Record Type:<rsp20rectype <+6>Acquirer ID:<+5><rsp20disacqid <+20>Discover Acct Nbr:<+1><rsp20dismchnum"
FOOTING
"Total Type 20:<&TOTERR20_CNT"
" "
-*FOOTING BOTTOM
-*" "
-*"Page <TABPAGENO of <TABLASTPAGE "
ON rsp20disacqid SKIP-LINE
ON TABLE PCHOLD AS &HOLDNAME20 FORMAT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=9,FONT='ARIAL',ORIENTATION=LANDSCAPE,SQUEEZE=ON,GRID=OFF,$
-*TYPE=HEADING,LINE=1,$
TYPE=HEADING,LINE=2,BACKCOLOR=GREY,JUSTIFY=LEFT,$$
TYPE=FOOTING, JUSTIFY=LEFT,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=CENTER,$
TYPE=TABHEADING,LINE=2,JUSTIFY=CENTER,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=1, WIDTH=2.00,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=2, WIDTH=1.25, JUSTIFY=LEFT,POSITION=3,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=3, WIDTH=1.25, JUSTIFY=LEFT,POSITION=5, $
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=4, WIDTH=1.25, JUSTIFY=LEFT,POSITION=7,$
TYPE=SUBHEAD, OBJECT=FIELD, WIDTH=0.50, JUSTIFY=LEFT,$
TYPE=FOOTING, OBJECT=TEXT, ITEM=2, WIDTH=1.25, JUSTIFY=LEFT,POSITION=3,$
TYPE=FOOTING, OBJECT=FIELD, WIDTH=0.50, JUSTIFY=LEFT,$
ENDSTYLE
END
-*-EXIT 


 
This does work...

 TABLE FILE DISSUBREG
PRINT disacqid NOPRINT
discredtm NOPRINT
COMPUTE SOURCEDTM/A20 = HCNVRT(discredtm,'(HMDYYS)',20,'A20'); NOPRINT
BY disacqid NOPRINT
ON disacqid SUBHEAD NOPRINT
"Operator:<discreuser                      <+0>DBA Name: <disdbanam"
"Data Source - Desc:<DATASRCDESC           <+0>DBA Addr 1:<disdbaress1"
"Reg Submit Date:<dissubdtm                <+0>DBA Addr 2:<disdbaress2"
"Record Type - Desc:<disrectype            <+0>DBA City:<disdbacity"
"Converted Discover Acct Nbr:<disconvmrch  <+0>DBA State:<disstate"
"MCC:<dismcc                               <+0>DBA Zip:<disdbazip"
"Merch Status - Desc:<MERCHSTATDESC        <+0>DBA Ctry:<disdbactry"
"Merch Status Date:<dismrchstatupdt        <+0>DBA Phone:<disdbaphn"
"Merch Type - Desc:<MERCHTYPEDESC          <+0>DBA Email:<disemail"
"<+0> <+0>                                 <+0>Merch Website:<disurl"
"<+0> <+0>                                 <+0> <+0>"
"Bus Type - Desc:<BUSTYPEDESC              <+0>Tax ID:<distaxid"
"HQ Acct Nbr:<dishdqacct                   <+0>Legal Bus Name:<dislegalnam"
"Bus contact First:<disbusfrnam            <+0>Bus Addr 1:<disdbaress1"
"Bus Contact Last:<disbusltnam             <+0>Bus Addr 2:<disbusress2"
"Bus Principal First:<disbusprnfnam        <+0>Bus City:<disbusprncity"
"Bus Principal Last:<disbusprnlnam         <+0>Bus State:<disbusstate"
"Bus Principal Title:<disbusprntinam       <+0>Bus Zip:<disbuszip"
"Bus Principal Home Addr 1:<disbusprnress1 <+0>Bus Ctry:<disbusprnctry"
"Bus Principal Home Addr 2:<disbusprnress2"
"Bus Principal Home City:<disbusprncity"
"Bus Principal Home State:<disbusprnstate"
"Bus Principal Home Zip:<disbusprnzip"
"Bus Principal Home City:<disbusctry"
"Bus Principal SSN:<MASKSSN"
BY disacqid NOPRINT
BY dismchnum NOPRINT

HEADING
"                                                                                 Discover Submitted Registration Report"
" "
"                                            Report Date: &RPT_TODAY <+10>Source File Timestamp:<+0> <SOURCEDTM"
" "
"Bank:<+0><disbank
" "
"Acquirer ID<+2><disacqid <+30>Discover Acct Nbr<+1><dismchnum"
" "
FOOTING BOTTOM
" "
"Page <TABPAGENO of <TABLASTPAGE "
ON disacqid SKIP-LINE
ON TABLE PCHOLD AS &HOLDNAME1 FORMAT PDF
-*ON TABLE HOLD AS &HOLDNAME1 FORMAT PDF
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=9,FONT='ARIAL',ORIENTATION=LANDSCAPE,SQUEEZE=ON,GRID=OFF,$
-*TYPE=REPORT,LINE=1,OBJECT=FIELD,ITEM=1,WIDTH=1.000,JUSTIFY=RIGHT,$
-*TYPE=REPORT,LINE=1,COLUMN=N2,POSITION=2.000000,
$
-*TYPE=HEADING,LINE=1,JUSTIFY=CENTER,$
-*TYPE=HEADING,LINE=1,JUSTIFY=LEFT,$
TYPE=HEADING,LINE=1,SIZE=10,FONT='ARIAL',$
-*TYPE=HEADING,LINE=3,BACKGROUND=GREY,$
TYPE=HEADING,LINE=6,BACKCOLOR=GREY,JUSTIFY=LEFT,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=CENTER,$
TYPE=TABHEADING,LINE=2,JUSTIFY=CENTER,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=1, WIDTH=2.00,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=2, WIDTH=1.25, JUSTIFY=LEFT,POSITION=3,$
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=3, WIDTH=1.25, JUSTIFY=LEFT,POSITION=5, $
TYPE=SUBHEAD, OBJECT=TEXT, ITEM=4, WIDTH=5.25, JUSTIFY=LEFT,POSITION=7,$
TYPE=SUBHEAD, OBJECT=FIELD, WIDTH=3.50, JUSTIFY=LEFT,$
ENDSTYLE
END




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
I get a error that no text is supplied below subhead or subfoot




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
Platinum Member
posted Hide Post
All,

I have figured out my issue related to my recent post... I removed the NOPRINT on this statement and the report worked.

Thanks Timothy

  ON rsp22disacqid SUBHEAD NOPRINT




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders