Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Borders Around ACROSS Groups
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Borders Around ACROSS Groups
 Login/Join
 
Member
posted
Hello!

I am trying to find the language to separate each option within an ACROSS using borders. In the below code, I can get the first ACROSS group segmented out, but it doesn't repeat for the remainder. Is there a way to dynamically create borders at each change in ACROSS? Please note that, in my actual data, the ACROSS is a date which can grow into perpetuity.

TABLE FILE GGSALES
SUM UNITS NOPRINT DOLLARS NOPRINT BUDUNITS NOPRINT BUDDOLLARS NOPRINT
COMPUTE intUnitDiff/I6 = UNITS - BUDUNITS; AS 'Budget Diff'
COMPUTE pctUnitDiff/D6.1% = (UNITS / BUDUNITS)*100; AS '%Units'
COMPUTE intDollarDiff/I6 = DOLLARS - BUDDOLLARS; AS 'Dollar Diff'
COMPUTE pctDollarDiff/D6.1% = (DOLLARS / BUDDOLLARS) * 100; AS '%Dollars'
BY REGION
ACROSS PRODUCT AS ''

ON TABLE SUMMARIZE AS 'Total'
ON TABLE SET ASNAMES ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
TYPE=ACROSSVALUE, JUSTIFY=CENTER,$

-*TOP BORDERS
TYPE=ACROSSVALUE, BORDER-TOP=MEDIUM,$

-*SIDE BORDERS
TYPE=ACROSSVALUE, BORDER-LEFT=MEDIUM, BORDER-RIGHT=MEDIUM,$
TYPE=TITLE, COLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
TYPE=DATA, COLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
TYPE=GRANDTOTAL, COLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
TYPE=TITLE, COLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$
TYPE=DATA, COLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$
TYPE=GRANDTOTAL, COLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$

-*BOTTOM BORDERS
TYPE=GRANDTOTAL, BORDER-BOTTOM=MEDIUM,$

ENDSTYLE
END

Thanks!
Jay

PS-This is my very first post on this forum! If there's anything I can do to clarify this or future questions, please let me know!-

This message has been edited. Last edited by: Jay Ervin,


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 20 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
TABLE FILE GGSALES
	SUM UNITS NOPRINT DOLLARS NOPRINT BUDUNITS NOPRINT BUDDOLLARS NOPRINT
	COMPUTE intUnitDiff/I6 = UNITS - BUDUNITS; AS 'Budget Diff'
	COMPUTE pctUnitDiff/D6.1% = (UNITS / BUDUNITS)*100; AS '%Units'
	COMPUTE intDollarDiff/I6 = DOLLARS - BUDDOLLARS; AS 'Dollar Diff'
	COMPUTE pctDollarDiff/D6.1% = (DOLLARS / BUDDOLLARS) * 100; AS '%Dollars'
	BY REGION
	ACROSS PRODUCT AS ''

	ON TABLE SUMMARIZE AS 'Total'
	ON TABLE SET ASNAMES ON
	ON TABLE SET PAGE-NUM NOLEAD
	ON TABLE SET HTMLCSS ON
	ON TABLE PCHOLD FORMAT HTML
	ON TABLE SET STYLE *
	TYPE=REPORT, GRID=OFF,$
	TYPE=ACROSSVALUE, JUSTIFY=CENTER,$

	-*TOP BORDERS
	TYPE=ACROSSVALUE, BORDER-TOP=MEDIUM,$

	-*SIDE BORDERS
	TYPE=ACROSSVALUE, BORDER-LEFT=MEDIUM, BORDER-RIGHT=MEDIUM,$
	TYPE=TITLE, ACROSSCOLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
	TYPE=DATA, ACROSSCOLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
	TYPE=GRANDTOTAL, ACROSSCOLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
	TYPE=TITLE, ACROSSCOLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$
	TYPE=DATA, ACROSSCOLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$
	TYPE=GRANDTOTAL, ACROSSCOLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$

	-*BOTTOM BORDERS
	TYPE=GRANDTOTAL, BORDER-BOTTOM=MEDIUM,$

	ENDSTYLE
END


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2236 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by MartinY:
TABLE FILE GGSALES
	SUM UNITS NOPRINT DOLLARS NOPRINT BUDUNITS NOPRINT BUDDOLLARS NOPRINT
	COMPUTE intUnitDiff/I6 = UNITS - BUDUNITS; AS 'Budget Diff'
	COMPUTE pctUnitDiff/D6.1% = (UNITS / BUDUNITS)*100; AS '%Units'
	COMPUTE intDollarDiff/I6 = DOLLARS - BUDDOLLARS; AS 'Dollar Diff'
	COMPUTE pctDollarDiff/D6.1% = (DOLLARS / BUDDOLLARS) * 100; AS '%Dollars'
	BY REGION
	ACROSS PRODUCT AS ''

	ON TABLE SUMMARIZE AS 'Total'
	ON TABLE SET ASNAMES ON
	ON TABLE SET PAGE-NUM NOLEAD
	ON TABLE SET HTMLCSS ON
	ON TABLE PCHOLD FORMAT HTML
	ON TABLE SET STYLE *
	TYPE=REPORT, GRID=OFF,$
	TYPE=ACROSSVALUE, JUSTIFY=CENTER,$

	-*TOP BORDERS
	TYPE=ACROSSVALUE, BORDER-TOP=MEDIUM,$

	-*SIDE BORDERS
	TYPE=ACROSSVALUE, BORDER-LEFT=MEDIUM, BORDER-RIGHT=MEDIUM,$
	TYPE=TITLE, ACROSSCOLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
	TYPE=DATA, ACROSSCOLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
	TYPE=GRANDTOTAL, ACROSSCOLUMN=intUnitDiff, BORDER-LEFT=MEDIUM,$
	TYPE=TITLE, ACROSSCOLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$
	TYPE=DATA, ACROSSCOLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$
	TYPE=GRANDTOTAL, ACROSSCOLUMN=pctDollarDiff, BORDER-RIGHT=MEDIUM,$

	-*BOTTOM BORDERS
	TYPE=GRANDTOTAL, BORDER-BOTTOM=MEDIUM,$

	ENDSTYLE
END


That's exactly what I was looking for. Thanks for your help!


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 20 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
My pleasure

Please update your first post then add [SOLVED] at the beginning of the subject


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2236 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Borders Around ACROSS Groups

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.