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     [CLOSED] Using ACROSS to carry background color to multi-year report
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Using ACROSS to carry background color to multi-year report
 Login/Join
 
Member
posted
I am trying to carry over the color background formatting to a multi year report with school_year as ACROSS. I have tried ACROSSVALUE and ACROSSCOLUMN but background colors will not display. Here is original code snipet N6=SPLACCOUNTABILITY A100V

TYPE=REPORT,
COLUMN=N6,
BACKCOLOR=RGB(0 161 224),
WHEN=N6 EQ 'Exceeding Expectations',
$
TYPE=REPORT,
COLUMN=N6,
BACKCOLOR=RGB(0 161 224),
WHEN=N6 EQ 'Exceeding Alternative School Expectations',
$
TYPE=REPORT,
COLUMN=N6,
BACKCOLOR='ORANGE',
WHEN=N6 EQ 'Not Meeting Expectations',
$
TYPE=REPORT,
COLUMN=N6,
BACKCOLOR='ORANGE',
WHEN=N6 EQ 'Not Meeting Alternative School Expectations',
$ This is a multi output report but mainly is HTML 8204 Webfocus version 3

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 9 | Registered: March 30, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
Try using Conditional Formatting, AKA: Stop lighting, in the TYPE=DATA section?

The issue with that code is that column N6 will be reset and displayed with the attributes of the last reference to it. WebFOCUS is parsed / interpreted line by line.
 
Posts: 3066 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Is that what you're looking for ?
DEFINE FILE GGSALES
DYR  /YY    = DATE;
DMTH /MONTH = DATE;
TEST /A1    = DECODE PRODUCT ('Coffee Pot' 'C' 'Latte' 'L' 'Mug' 'M');
END
TABLE FILE GGSALES
SUM DOLLARS
    TEST       NOPRINT
BY DMTH        AS 'Month'
ACROSS DYR     AS ''
ACROSS PRODUCT AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

     DEFMACRO=DMAC_CPOT,
     MACTYPE=RULE,
     WHEN=TEST EQ 'C',
$
     DEFMACRO=DMAC_LATTE,
     MACTYPE=RULE,
     WHEN=TEST EQ 'L',
$
     DEFMACRO=DMAC_MUG,
     MACTYPE=RULE,
     WHEN=TEST EQ 'M',
$
TYPE=DATA,
     ACROSSCOLUMN=DOLLARS,
     BACKCOLOR=RGB(0 161 224),
     MACRO=DMAC_CPOT,
$
TYPE=DATA,
     ACROSSCOLUMN=DOLLARS,
     BACKCOLOR=RGB(0 161 224),
     MACRO=DMAC_LATTE,
$
TYPE=DATA,
     ACROSSCOLUMN=DOLLARS,
     BACKCOLOR='ORANGE',
     MACRO=DMAC_MUG,
$
ENDSTYLE
END


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2293 | 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     [CLOSED] Using ACROSS to carry background color to multi-year report

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