I am having trouble with the formatting on the first line of the label I want to center and make the background color orange or something.
when I try to apply the formating on the first line it throws my labels and image off. Here is my code.

 
JOIN
 SFM3T004.SFMST004_PLAN_LOOKUP.NO_PLAN_NPI_ID_PK IN SFM3T004 TO MULTIPLE
 SFM3T001.SFMST001_PROVIDER.NO_HLTH_PLAN_NPI IN SFM3T001 AS J9
 END
JOIN
 SFM3T001.SFMST001_PROVIDER.NO_PROV_MOCK_ID_PK IN SFM3T004 TO MULTIPLE
 SFM3T003.SFMST003_PROV_LOCATION.NO_PROV_MOCK_ID_FK IN SFM3T003 AS J10
 END
JOIN
 LEFT_OUTER SFM3T003.SFMST003_PROV_LOCATION.NO_PROV_MOCK_ID_FK IN SFM3T004 TO MULTIPLE
 SFM3T002.SFMST002_PROV_CODES.NO_PROV_MOCK_ID_FK IN SFM3T002 AS J11
 END
JOIN
 SFM3T002.SFMST002_PROV_CODES.TX_PROV_SPEC_CODE IN SFM3T004 TO MULTIPLE
 SFM3T006.SFMST006_SPEC_CODES_LOOKUP.NO_PROV_CODE_ID_PK IN SFM3T006 AS J14
 END
TABLE FILE SFM3T004
PRINT *
BY AD_COUNTY_CODE NOPRINT
ON TABLE HOLD AS SFM3H005
END
JOIN AD_COUNTY_CODE IN SFM3H005 TO ALL NO_CNTY_ID_PK IN SFM3T005 AS J8
END
DEFINE FILE SFM3H005
PROVID/A4=EDIT(NO_PROV_MOCK_ID_PK,'$$$$$$$9999');
PROV_NAME/A34=(NA_PROVIDER_LAST|NA_PROVIDER_FIRST|NA_PROVIDER_MIDDLE|' - '|PROVID|' - '|SW_EST_PATNT_INDICTR);
PHONE/A14=EDIT(AD_PCP_PH,'(999) 999-9999');
ADDR2/A53=(AD_CITY|', '|AD_STATE|' '|AD_ZIP_5|' - '|PHONE);
END
TABLE FILE SFM3H005
PRINT PROV_NAME
	  TX_PROV_CODE_DESC
	  COMPUTE TX_OTHER/A75 = IF TX_OTHER EQ '' THEN 'ENGLISH' ELSE TX_OTHER;
	  TX_PLAN_NAME
 	  AD_ADDRESS
 	  ADDR2
      TX_COUNTY_NAME
      PROV_NAME
	  TX_OTHER
WHERE TX_REGION EQ 'CENTRAL';
ON TABLE HOLD AS TEST1
END
TABLE FILE TEST1
PRINT COMPUTE COUNTER/D5 = IF COUNTER EQ 24 THEN 1 ELSE COUNTER + 1; NOPRINT
      COMPUTE COUNTY/A15 = IF TX_COUNTY_NAME EQ LAST TX_COUNTY_NAME THEN '' ELSE TX_COUNTY_NAME ; NOPRINT
BY TX_COUNTY_NAME NOPRINT
BY PROV_NAME NOPRINT
ON TX_COUNTY_NAME PAGE-BREAK
HEADING
"<COUNTY"
"<PROV_NAME"
"<TX_PROV_CODE_DESC"
"<TX_OTHER"
"<TX_PLAN_NAME "
"<TX_PROV_CODE_DESC"
"<AD_ADDRESS "
"<ADDR2 "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='Letter', LEFTMARGIN=0.100000, RIGHTMARGIN=0.100000, TOPMARGIN=1.250000, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $
PAGEMATRIX=(4 6), ELEMENT=(2.65 1.0), GUTTER=(0.180556 0.0), MATRIXORDER=VERTICAL, $
LABELPROMPT=OFF, $
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=7, $
TYPE=HEADING, IMAGE=app/ppmoh.gif, POSITION=(+0.0 -1.5), WHEN=COUNTER EQ 1, $
TYPE=TABHEADING, FONT='ARIAL', SIZE=1, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

 

This message has been edited. Last edited by: Kerry,

Can you duplicate this with the CAR or other sample tables so we have something we can run?

I think the problem lies in the SQUEEZE=ON. If you set it to off, everything (colors, justification, etc.) appear correctly, but then the column may be too wide. See if you can turn it off and change you colum widths to make it work.

I made the adjustment and it looks fine, is there a way to apply the back color on the line if there is text present only and if no text no backcolor. I am suppressing the county name to show only one time.

This message has been edited. Last edited by: baxj89,

It's called conditional styling and well-documented in the help files.

Problem fixed thanks