Focal Point
Label Style report, footer repeats in each column

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5771050142

August 09, 2007, 11:29 AM
tryFOCUSing
Label Style report, footer repeats in each column
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!


Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
August 09, 2007, 04:24 PM
FortuneCookie
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


Prod: WebFOCUS 7.1.6, Windows 2003

Dev: WebFOCUS 7.6.2, Windows 2003
August 09, 2007, 04:30 PM
tryFOCUSing
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),
$



Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
August 10, 2007, 11:47 AM
tryFOCUSing
Anyone?


Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
August 10, 2007, 12:09 PM
Francis Mariani
How about giving us a report we can actually run that mimics yours? Then, perhaps we can tweak...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 10, 2007, 12:25 PM
ypatel
I would like to see an example that we can run and see the actual problem.
quote:
logoNBHFooter.gif,



-Yogesh Patel
------------------------------------------------------------------------
PROD: WF 764 on Linux Apache tomcat v5.5
DEV: WF 768 on Linux
August 10, 2007, 12:52 PM
tryFOCUSing
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



Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
August 10, 2007, 02:12 PM
Francis Mariani
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).


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 10, 2007, 02:29 PM
tryFOCUSing
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!


Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
August 12, 2007, 03:27 AM
susannah
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.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 12, 2007, 08:32 AM
FrankDutch
Or Prairi, see wants to write a book on PDF and compound reports.




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

August 12, 2007, 03:35 PM
susannah
oh she does? that's fabulous.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID