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     remove underline when sort field changes

Read-Only Read-Only Topic
Go
Search
Notify
Tools
remove underline when sort field changes
 Login/Join
 
Kamesh
Master
posted
hi,
I'm using UNDER-LINE when sort field changes. If I have only one value then I dont need underline. But it displays UNDER-LINE always.

example
TABLE FILE CAR
PRINT FIELD1
BY FIELD2 NOPRINT
ON FIELD2 UNDER-LINE
END

I need underline only when I have more than one record on FIELD2.

-Kamesh
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Stan
Gold member
posted Hide Post
I'm at home so I can't try it, but you might add the word MULTILINES after your underline. I think Multilines only works with subtotals, etc, so it probably won't work, but off the top of my head it was all I could think of.
 
Posts: 90 | Registered: April 15, 2004Report This Post
Kamesh
Master
posted Hide Post
Hi Stan, MULTILINES didn't work. -Kamesh
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
reFOCUSing
Guru
posted Hide Post
Try using the WHEN as part of the ON statement. Hope this code works for you.



TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST

COMPUTE LINE/I2 = IF COUNTRY EQ LAST COUNTRY THEN LAST LINE + 1 ELSE 0;
BY
COUNTRY
BY
CAR

ON COUNTRY UNDER-LINE
WHEN LINE GE 1;
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.000000,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Mabel>,
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
reFOCUSing
Guru
posted Hide Post
Here is another option you could do:


TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST

COMPUTE LINE/I2 = IF COUNTRY EQ LAST COUNTRY THEN LAST LINE + 1 ELSE 0;
BY
COUNTRY
BY
CAR

ON COUNTRY SUBFOOT
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.000000,
$
TYPE=SUBFOOT,
SIZE=1,
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
WHEN=N5 GE 1,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Mabel>,
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
<Pietro De Santis>
posted
DEFINE FILE CAR
CNT_MODEL/I4 = 1;
END
TABLE FILE CAR
SUM
MODEL
CNT_MODEL
BY COUNTRY NOPRINT
ON COUNTRY UNDER-LINE WHEN CNT_MODEL GT 1
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF,
FONT='VERDANA', SIZE=8, $
ENDSTYLE
END
 
Report This Post
Kamesh
Master
posted Hide Post
I tried the options you suggested but it didn't work properly. I can't do SUM, so, I'm using PRINT on my code.
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
<Sugiyama>
posted
I think so. Please try.

DEFINE FILE CAR
WCNT/I5 = 1;
END
TABLE FILE CAR
SUM WCNT NOPRINT
BY COUNTRY
PRINT CAR DCOST RCOST
BY COUNTRY
ON COUNTRY UNDER-LINE
WHEN WCNT GT 1;
ON TABLE SET STYLE *
GRID = OFF ,$
ENDSTYLE
END
 
Report This Post
reFOCUSing
Guru
posted Hide Post
Kamesh, both of the options I gave you should work with a PRINT instead of the SUM since they are doing a COMPUTE. Give it a try and let me know if it works.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report 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     remove underline when sort field changes

Copyright © 1996-2020 Information Builders