Focal Point
Allignment Issues
March 20, 2008, 09:19 AM
tlbrydie2Allignment Issues
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
March 20, 2008, 09:50 AM
FrankDutchYou 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 |
March 20, 2008, 10:15 AM
tlbrydie2Let'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
March 20, 2008, 11:00 AM
mgrackinTry 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 |
March 20, 2008, 11:11 AM
tlbrydie2Mickey 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
March 20, 2008, 11:14 AM
tlbrydie2OH....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
March 20, 2008, 11:36 AM
tlbrydie2I 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
March 20, 2008, 12:07 PM
mgrackinTo 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 |
March 20, 2008, 01:06 PM
tlbrydie2Mickey....
I love you !!!!
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
March 20, 2008, 01:13 PM
tlbrydie2Thank'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
March 20, 2008, 02:09 PM
mgrackintlbrydie2,
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 |
March 27, 2008, 07:15 PM
tlbrydie2Mickey (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
March 27, 2008, 07:16 PM
tlbrydie2I 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
March 28, 2008, 07:45 AM
tlbrydie2All,
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