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.
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
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
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,$
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
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
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
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,$
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
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
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
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
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