Hi,

I have had some issues with a few items, but I have looked at other posts and simply cannot figure out why this instance is not working. Information as to why it's not working would be helpful as well as the code error I have.

 TABLE FILE BLRASFINAL
PRINT 
     J2.TPRFINAL.CHAR_UA91 AS ''
     J2.TPRFINAL.CURMOUA AS ''
     J2.TPRFINAL.CHAR_PD91 AS ''
     J2.TPRFINAL.CURMOPD AS ''
     J2.TPRFINAL.CHAR_PDT1 AS ''
     J2.TPRFINAL.CURMOPDT1 AS ''
     J2.TPRFINAL.CHAR_USWP AS ''
     J2.TPRFINAL.CUR_USWP_PER AS ''
     J2.TPRFINAL.CHAR_USWPT1 AS ''
     J2.TPRFINAL.CUR_USWPT1_PER AS ''
     J2.TPRFINAL.CHAR_USWPCF AS ''
     J2.TPRFINAL.CUR_USWPCF_PER AS ''
	 SPACEADD AS ''
	 J2.TPRFINAL.CHAR_CD AS ''
     J2.TPRFINAL.CURPOP AS ''
     J2.TPRFINAL.CHAR_CDT1 AS ''
     J2.TPRFINAL.CURT1 AS ''
     J5.BDFINAL.CHAR_TPRBD AS ''
     J5.BDFINAL.CURRPOP AS ''
     J5.BDFINAL.CHAR_PROG AS ''
     J5.BDFINAL.CURRPROG AS ''
     J2.TPRFINAL.CHAR_LOCUSWP AS ''
     J2.TPRFINAL.CURLOCUSWP AS ''
     J6.FINDFINA.CHAR_FIND AS ''
     J6.FINDFINA.CURFIND_PER AS ''
     J2.TPRFINAL.CHAR_MC AS ''
     J2.TPRFINAL.CURMC AS ''
	 COMPUTE CLASSFLAG/A1 = IF CLASSFLAG EQ '1' THEN '2' ELSE '1'; NOPRINT
BY  SPACEADD NOPRINT 
BY  BLRASFINAL.BLRASFIN.CUSTOM_RANK NOPRINT 
BY  BLRASFINAL.BLRASFIN.CUSTOM_BL AS ''
BY  BLRASFINAL.BLRASFIN.RAS AS ''
ON SPACEADD SUBHEAD
"TEST<+0>THIS<+0>Scorecard Metrics<+0> <+0>KRI"
-*" <+0> <+0>Aged (91+ Days)<+0>Critical Watch<+0> <+0>Population<+0>Other"
-*" <+0> <+0> <+0> <+0>High<+0> <+0>% High<+0>% Cust<+0> <+0> <+0>High<+0>Appr.<+0> <+0>TPRs<+0>High Risk<+0> <+0>"
-*" <+0> <+0>TPRs<+0>TPRs<+0>Risk<+0>% TPRs<+0>Risk<+0>Facing<+0> <+0>Corp<+0>Risk<+0>Bus<+0>Appr.<+0>w/ Priv<+0>TPRs w/<+0>Mission<+0>"
-*"Business<+0>RAS<+0>Rated<+0>Past<+0>TPRs<+0>Rated<+0>TPRs<+0>TPRs<+0> <+0>Dir (CD)<+0>CD<+0>Dir (BD)<+0>BD<+0>Vio-<+0>Crit/High<+0>Crit<+0>"
-*"Line<+0>Group<+0>Unsat<+0>Due<+0>Past Due<+0>CW<+0>Rated CW<+0>Rated CW<+0> <+0>TPRs<+0>TPRs<+0>Progs<+0>TPRs<+0>lation<+0>Sev Find<+0>TPRs<+0>"
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

TYPE=REPORT, GRID=OFF, SQUEEZE=ON, SIZE=8, ORIENTATION=LANDSCAPE, $

TYPE=SUBHEAD, HEADALIGN=BODY, $

TYPE=REPORT, COLUMN=N3, WRAP=1.00, RIGHTGAP=.05, LEFTGAP=.05,$
TYPE=REPORT, COLUMN=N4, WRAP=1.25, RIGHTGAP=.05, LEFTGAP=.05,$
TYPE=REPORT, COLUMN=N5, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N6, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N7, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N8, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N9, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N10, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N11, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N12, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N13, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N14, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N15, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N16, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N17, WRAP=0.05, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N18, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N19, WRAP=0.5, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N20, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0,$
TYPE=REPORT, COLUMN=N21, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N22, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0, $
TYPE=REPORT, COLUMN=N23, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01,$
TYPE=REPORT, COLUMN=N24, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0, $
TYPE=REPORT, COLUMN=N25, WRAP=0.5, LEFTGAP=.01, RIGHTGAP=.01, $
TYPE=REPORT, COLUMN=N26, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0, $
TYPE=REPORT, COLUMN=N27, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01, $
TYPE=REPORT, COLUMN=N28, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0, $
TYPE=REPORT, COLUMN=N29, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01, $
TYPE=REPORT, COLUMN=N30, WRAP=0.125, LEFTGAP=.0, RIGHTGAP=.0, $
TYPE=REPORT, COLUMN=N31, WRAP=0.45, LEFTGAP=.01, RIGHTGAP=.01, $

TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=1, WIDTH=3.1, JUSTIFY=CENTER, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=2, WIDTH=1.35, JUSTIFY=CENTER, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=3, WIDTH=8.22, JUSTIFY=CENTER, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=4, WIDTH=.05, JUSTIFY=CENTER,$
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=5, WIDTH=9.59, JUSTIFY=CENTER,$

ENDSTYLE
END
 

I have tried using the HTML version of COLSPAN, which works to separate the headers and provide boarders over the appropriate rows, but then I can't center the information which is the ultimate goal. Code is as follows:

 TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=1, POSITION=N3, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=2, POSITION=N4, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=3, POSITION=N5, COLSPAN=12, JUSTIFY=CENTER, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP=LIGHT, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=4, POSITION=N17, $
TYPE=SUBHEAD, LINE=1 OBJECT=TEXT, ITEM=5, POSITION=N18, COLSPAN=14, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP=LIGHT, JUSTIFY=CENTER,$ 

Please assist in getting either of these options to work.

In addition, the report above is Repeats the CUSTOM_BL line, as such:

BL1 | RAS 1
BL1 | RAS 2
BL2 | RAS 3
BL3 | RAS 4

Desired output would be the following:

BL1 | RAS 1
| RAS 2
BL2 | RAS 3
BL3 | RAS 4


Thank you in advance.

This message has been edited. Last edited by: <Emily McAllister>,

quote:

J2.TPRFINAL.CUR_USWPT1_PER AS ''
J2.TPRFINAL.CHAR_USWPCF AS ''

Hello drPib81

Welcome to Focal Point!

While we wait for others to assist with this question here is a link to the Technical Support Technical Content library:

Technical Content Library

You can choose your version since it is not clear on you signature which version you are using.

Within this link you can find the Reporting Language reference manual.


Your repetition might be due to the BY and the NOPRINT - remove the NOPRINT and see what the results are.

Also, search in the Forum for COLSPAN there are lots of links.


Here is a link using Headalign and colspan :
HEADING data to reflect each sort value per page-break.

Once you have found a resolution please update the subject line with the correct TAG word - found at the following: Tag your topic with keywords


Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.

* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit

Hi drPib81,

Your example is a bit convoluted.
Could you try to repro using the CAR or GGSALES or any other supplied file? In that way we could try to help.