I've created a pdf report using the label formatting, but the footer repeats under each column. The report includes a company standard footer that has an image of a blue and green line across the bottom, the company logo and a propritary and confidential statement. The bar is the only thing that is being duplicated. The report is landscape and each column is about 5 inches wide. So the image/bar starts at the bottom of the page left aligned to the first column and then starts again at 5.0 inches across the page left aligned at the second column. The proprietary and conf. statement doesn't duplicate?!?!?


Anyone else had this issue? This is my first pass at using the label formatting.

Thanks!

you may want to try to run the report with
SET PRINTPLUS=ON

If that doesn't work, paste in the code for us to review

The final report is actually in a compound report and this is where I include the footer information.

-* File zzzTest2Col.fex
-SET PRINTPLUS = ON;
-INCLUDE Properties

TABLE FILE VW_REPORTDESCRIPTIONS
PRINT
     REPORTPAGEORDER NOPRINT
     REPORTPAGEDESCRIPTION AS ''
BY SECTIONORDER NOPRINT
BY SECTIONDESCRIPTION NOPRINT
BY REPORTORDER NOPRINT
BY REPORTNAME NOPRINT
BY REPORTPAGENAME NOPRINT
ON SECTIONDESCRIPTION SUBHEAD
"<SECTIONDESCRIPTION "
ON REPORTPAGENAME SUBHEAD
"<BLANK <BLANK <REPORTPAGENAME "
WHERE GROUPCODE EQ 'NMH';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
     PAGEMATRIX=(2 1),
      ELEMENT=(4.75 6.555556),
      GUTTER=(0.0 0.0),
      MATRIXORDER=HORIZONTAL,
 $
     LABELPROMPT=OFF,
 $
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N5,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N7,
     WRAP=4.500000,
$
-****************************************************
-* Standard heading and footing
-****************************************************
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=5.0,
  SIZE=10,
  STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=RIGHT,
     WIDTH=4.0,
    SIZE=8,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.500,
    SIZE=8,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=4.0,
  SIZE=14,
  STYLE=BOLD,
  COLOR=RGB(243 143 29),
$
TYPE=HEADING,
    SIZE=10,
     TOPGAP=-0.01,
     BOTTOMGAP=-0.01,
$

ENDSTYLE
END
  

Compound report that includes the above code:

  -* File cpdRptDscrpt.fex
-* Default Mode: ResourceLayout

-INCLUDE Properties

COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, $
pagelayout=1, name='Layout page 1', $
component='report1', type=report, position=(.75 1.05), dimension=(6 6.1), $
-*
-* Standard Includes
-*
-SET &&FootLine1='';
-SET &FootLine2='';

-INCLUDE cpdHeader
-INCLUDE cpdFooter

object=string,
 name='txtReportTitle',
 text='Report Descriptions',
 position=(.75 1.15),
 font='ARIAL',
 color=RGB(243 143 29),
 size=14,
 style=BOLD,
$

END
SET COMPONENT='report1'
-*component_type report
-INCLUDE zzztest2col
COMPOUND END

Footer include:

-* File cpdFooter.fex

object=string,
	name='txtFooter1',
	text='&FootLine2',
	position=(1.95 7.8),
	WRAP=ON,
	dimension=(6.461 0.2),
	font='ARIAL',
	color=RGB(0 0 0),
	size=8,
$
object=string,
	name='txtFooter4',
	text='&PropConf',
	position=(.25 7.80),
	WRAP=ON,
	dimension=(3.542 0.042),
	font='ARIAL',
	color=RGB(0 0 0),
	size=8,
	style=ITALIC,
$
object=image,
	name='logoNBHFooter',
	image=logoNBHFooter.gif,
	position=(9.250 7.8),
	dimension=(1.417 0.625),
$
object=image,
	name='lineBottomBar',
	image=footer_bar.gif,
	position=(0.25 7.5),
	dimension=(10.5 0.25),
$
  

Anyone?

How about giving us a report we can actually run that mimics yours? Then, perhaps we can tweak...

I would like to see an example that we can run and see the actual problem.

quote:

logoNBHFooter.gif,

This example uses the Employee table to create a 2 column mailing label style report. If you limit the records returned to only populate 1 column of the report the images do not repeat in the footer.

Compound PDF Report (wrapper)

****Replace any_image.gif (in 2 places) with any image that you may have available.******

-* File cpd2col.fex
-* File cpdRptDscrpt.fex
-* Default Mode: ResourceLayout

COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, $
pagelayout=1, name='Layout page 1', $
component='report1', type=report, position=(.75 1.05), dimension=(6 6.1), $
-*
-* Standard Includes
-*

-* ***********************************************************************************
-* Footer info that repeats
-* ***********************************************************************************

object=string,
 name='txtFooter1',
 text='',
 position=(1.95 7.8),
 WRAP=ON,
 dimension=(6.461 0.2),
 font='ARIAL',
 color=RGB(0 0 0),
 size=8,
$
object=string,
 name='txtFooter4',
 text='Footer Text',
 position=(.25 7.80),
 WRAP=ON,
 dimension=(3.542 0.042),
 font='ARIAL',
 color=RGB(0 0 0),
 size=8,
 style=ITALIC,
$
object=image,
 name='logoNBHFooter',
 image= [COLOR:RED]any_image.gif[/COLOR],
 position=(9.250 7.8),
 dimension=(1.417 0.625),
$
object=image,
 name='lineBottomBar',
 image= [COLOR:RED]any_image.gif[/COLOR] ,
 position=(0.25 7.5),
 dimension=(10.5 0.25),
$

-* ***********************************************************************************
-* End Footer info
-* ***********************************************************************************

object=string,
 name='txtReportTitle',
 text='Report Descriptions',
 position=(.75 1.15),
 font='ARIAL',
 color=RGB(243 143 29),
 size=14,
 style=BOLD,
$

END
SET COMPONENT='report1'
-*component_type report
-INCLUDE 2coltest
COMPOUND END

Underlying label style report:

-* File 2coltest.fex
TABLE FILE EMPLOYEE
BY DEPARTMENT NOPRINT
BY LAST_NAME NOPRINT

ON DEPARTMENT SUBHEAD
"<DEPARTMENT "

ON LAST_NAME SUBHEAD
"<FIRST_NAME  <LAST_NAME "
"<ADDRESS_LN1 "
"<ADDRESS_LN2 "
"<ADDRESS_LN3 "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
     PAGEMATRIX=(2 1),
      ELEMENT=(4.750000 6.555556),
      GUTTER=(0.000000 0.000000),
      MATRIXORDER=HORIZONTAL,
 $
     LABELPROMPT=OFF,
 $
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END

Oh well, I can't help. I have never seen code like the "COMPOUND LAYOUT" portion of the code and it does not work in 5.3.2 (the level of my expertise).

Thanks Francis, but that doesn't leave me with a very warm and fuzzy feeling knowing that you can't do it. You are one of FOCUS folk's that I look to for answers.

Thanks for taking a peek!

Michael...
see if you can get ahold of Mickey Grackin...
he's quite the PDF guru for us all..
send him a pm and ask his advice on this one.

Or Prairi, see wants to write a book on PDF and compound reports.

oh she does? that's fabulous.