Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Label Style report, footer repeats in each column

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Label Style report, footer repeats in each column
 Login/Join
 
Silver Member
posted
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
 
Posts: 37 | Location: Baltimore, MD, USA | Registered: September 06, 2006Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 140 | Registered: May 02, 2007Report This Post
Silver Member
posted Hide Post
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
 
Posts: 37 | Location: Baltimore, MD, USA | Registered: September 06, 2006Report This Post
Silver Member
posted Hide Post
Anyone?


Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
 
Posts: 37 | Location: Baltimore, MD, USA | Registered: September 06, 2006Report This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
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
 
Posts: 42 | Location: Edison, New Jersey | Registered: January 30, 2007Report This Post
Silver Member
posted Hide Post
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
 
Posts: 37 | Location: Baltimore, MD, USA | Registered: September 06, 2006Report This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
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
 
Posts: 37 | Location: Baltimore, MD, USA | Registered: September 06, 2006Report This Post
Expert
posted Hide Post
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
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
oh she does? that's fabulous.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Label Style report, footer repeats in each column

Copyright © 1996-2020 Information Builders