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     [CLOSED] EXCEL FORMATTING BORDER ISSUE WITH SEQUENCE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] EXCEL FORMATTING BORDER ISSUE WITH SEQUENCE
 Login/Join
 
Srinivasan_Munuswamy
Gold member
posted
I am creating an excel report with some conditional styling and the report has three BY verbs. Where I want one of the BY column to be at the end for which I have used the SEQUENCE.
EVERYTHING is fine except the border and the backcolor. Any help is greatly appreciated.

 

TABLE FILE CAR
PRINT
SEATS	
DEALER_COST	
MODEL	

BY CAR	
BY COUNTRY	
BY BODYTYPE	

HEADING
"ODS Load Status Report"
"Report Run Date and Time : &DATE &&TIME<+0> "
FOOTING
""
"* Dash (--) Represents No Data Available."

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
	 BORDER=LIGHT,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=BODYTYPE EQ 'SEDAN',
$
     DEFMACRO=COND0002,
     MACTYPE=RULE,
     WHEN=BODYTYPE EQ 'COUPE',
$
     DEFMACRO=COND0003,
     MACTYPE=RULE,
     WHEN=BODYTYPE EQ 'HARDTOP',
$

TYPE=REPORT,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N6,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N6,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N6,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N6,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=TITLE,
     COLUMN=N1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$
TYPE=TITLE,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$
TYPE=TITLE,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     MACRO=COND0001,
$
TYPE=TITLE,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     MACRO=COND0002,
$
TYPE=TITLE,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     MACRO=COND0003,
$
TYPE=TITLE,
     COLUMN=N2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$
TYPE=TITLE,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$
TYPE=TITLE,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$
TYPE=TITLE,
     COLUMN=N6,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$

TYPE=REPORT,
     COLUMN=N1,
     SEQUENCE=2,
$
TYPE=REPORT,
     COLUMN=N3,
     SEQUENCE=6,
$
ENDSTYLE
END



Screen shot of the excel report is uploaded.

This message has been edited. Last edited by: Kerry,


WF 8.0.0.9 Database : oracle

CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i

 
Posts: 51 | Registered: September 20, 2007Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Changing the column sequence by using the StyleSheet seems to confuse WebFOCUS. I used BY NOPRINT to place the columns.

TABLE FILE CAR
 PRINT CAR
       SEATS
       DEALER_COST
       MODEL
       BODYTYPE
 BY CAR      NOPRINT
 BY COUNTRY
 BY BODYTYPE NOPRINT
 HEADING
  "ODS Load Status Report"
  "Report Run Date and Time : &DATE "
 FOOTING
  ""
  "* Dash (--) Represents No Data Available."
 ON TABLE NOTOTAL
 ON TABLE PCHOLD FORMAT EXL2K
 ON TABLE SET STYLE *
    UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, BORDER=LIGHT, $
    DEFMACRO=COND0001, MACTYPE=RULE, WHEN=BODYTYPE EQ 'SEDAN', $
    DEFMACRO=COND0002, MACTYPE=RULE, WHEN=BODYTYPE EQ 'COUPE', $
    DEFMACRO=COND0003, MACTYPE=RULE, WHEN=BODYTYPE EQ 'HARDTOP', $
 TYPE=REPORT, FONT='TIMES NEW ROMAN', SIZE=10, $
 TYPE=DATA, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $
 TYPE=DATA, BACKCOLOR='GREEN',  MACRO=COND0001, $
 TYPE=DATA, BACKCOLOR='YELLOW', MACRO=COND0002, $
 TYPE=DATA, BACKCOLOR='RED',    MACRO=COND0003, $
 TYPE=TITLE, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BACKCOLOR='SILVER', $
 ENDSTYLE
END


If you don't want the repeating values in the CAR column that result from the above code, then you can set the sequence for CAR in the StyleSheet, but must also style that column specifically. For some reason, general styling rules don't seem to apply to re-sequenced columns.

TABLE FILE CAR
 PRINT SEATS
       DEALER_COST
       MODEL
       BODYTYPE
 BY CAR
 BY COUNTRY
 BY BODYTYPE NOPRINT
 HEADING
  "ODS Load Status Report"
  "Report Run Date and Time : &DATE "
 FOOTING
  ""
  "* Dash (--) Represents No Data Available."
 ON TABLE NOTOTAL
 ON TABLE PCHOLD FORMAT EXL2K
 ON TABLE SET STYLE *
    UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, BORDER=LIGHT, $
    DEFMACRO=COND0001, MACTYPE=RULE, WHEN=BODYTYPE EQ 'SEDAN', $
    DEFMACRO=COND0002, MACTYPE=RULE, WHEN=BODYTYPE EQ 'COUPE', $
    DEFMACRO=COND0003, MACTYPE=RULE, WHEN=BODYTYPE EQ 'HARDTOP', $
  TYPE=REPORT, FONT='TIMES NEW ROMAN', SIZE=10, $
  TYPE=DATA, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $
  TYPE=DATA, BACKCOLOR='GREEN',  MACRO=COND0001, $
  TYPE=DATA, BACKCOLOR='YELLOW', MACRO=COND0002, $
  TYPE=DATA, BACKCOLOR='RED',    MACRO=COND0003, $
  TYPE=TITLE, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BACKCOLOR='SILVER', $

  TYPE=REPORT, COLUMN=CAR, SEQUENCE=2, $
  TYPE=DATA, COLUMN=CAR, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $
  TYPE=DATA, COLUMN=CAR, BACKCOLOR='GREEN',  MACRO=COND0001, $
  TYPE=DATA, COLUMN=CAR, BACKCOLOR='YELLOW', MACRO=COND0002, $
  TYPE=DATA, COLUMN=CAR, BACKCOLOR='RED',    MACRO=COND0003, $
  TYPE=TITLE, COLUMN=CAR, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BACKCOLOR='SILVER', $
 ENDSTYLE
END

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Clinton Side-Kick
Platinum Member
posted Hide Post
Regarding the backcolor of column N3 (BODYTYPE), you are receiving the correct result based on your Macro condition. Maybe you want to explain what you want to achieve by applying conditional styling to this specific column title?
Regarding the border, I got the same result as you in release 7.6.10. However when I add a BLANK DEFINE field (see code below), then the border is properly painted (granted you get an extra unwanted "blank" column).
I would open a case with IB techsupport.
code:
DEFINE FILE CAR
BLANK/A1='';
END
TABLE FILE CAR
PRINT
SEATS
DEALER_COST
MODEL
BLANK AS ''
BY CAR
BY COUNTRY
BY BODYTYPE
....


--------------------------------------------------------------------------------
prod: WF/AS 8.2.05; OmniGen;
In FOCUS since 1991
 
Posts: 104 | Location: United Kingdom | Registered: February 07, 2008Report 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     [CLOSED] EXCEL FORMATTING BORDER ISSUE WITH SEQUENCE

Copyright © 1996-2020 Information Builders