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] DRILLMENUITEM formatting

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] DRILLMENUITEM formatting
 Login/Join
 
Member
posted
I have started setting up the DRILLMENUITEM option on my report, but wish to format how the hyperlink is shown.

Currently my title shows up in blue where as my data had an underline.

I'd like to keep the original formatting of my report which was black for the title and no underline for my data.

is this possible?

Here is the code so far
TYPE=DATA,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(204 204 204),
BORDER-BOTTOM-COLOR=RGB(204 204 204),
BORDER-LEFT-COLOR=RGB(204 204 204),
BORDER-RIGHT-COLOR=RGB(204 204 204),
BACKCOLOR='WHITE',
DRILLMENUITEM='Detailed Analysis',
FOCEXEC=pri_cube_view( \
AFF_GROUP=&AFF_GROUP.QUOTEDSTRING \
AFF_PARENT=&AFF_PARENT.QUOTEDSTRING \
AFFINITY=&AFFINITY.QUOTEDSTRING \
CHANNEL=&CHANNEL.QUOTEDSTRING \
COVER=&COVER.QUOTEDSTRING \
PRODUCT=&PRODUCT.QUOTEDSTRING \
QUOTE_MONTH=A2 \
QUOTE_YEAR=A1 \
),
TARGET='_self',
DRILLMENUITEM='Commission Code Breakdown',
URL=http://www.google.co.uk,
TARGET='_self',
$
TYPE=TITLE,
COLOR='BLACK',
BACKCOLOR=RGB(204 204 204),
DRILLMENUITEM='Detailed Analysis',
FOCEXEC=pri_cube_view( \
AFF_GROUP=&AFF_GROUP.QUOTEDSTRING \
AFF_PARENT=&AFF_PARENT.QUOTEDSTRING \
AFFINITY=&AFFINITY.QUOTEDSTRING \
CHANNEL=&CHANNEL.QUOTEDSTRING \
COVER=&COVER.QUOTEDSTRING \
PRODUCT=&PRODUCT.QUOTEDSTRING \
QUOTE_MONTH=A2 \
QUOTE_YEAR=A1 \
),
TARGET='_self',
DRILLMENUITEM='Commission Code Breakdown',
URL=http://www.google.co.uk,
TARGET='_self',
$

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


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Expert
posted Hide Post
I posted something a while ago about styling the popup.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
Mike

You can change the multidrill.css in ibi\WebFOCUS77\ibi_html\javaassist\ibi\html\js, but this will be overwritten on upgrade, as you have discovered.

Otherwise set CSSURL, in report or in a profile, to, something like:

SET CSSURL = ../../approot/baseapp/mymultidrill.css

in the css have
  DIV.clsMDMenu {
    background-color: #cccccc !important;
  }
  DIV.clsMDMenu A span {
    font-family: lucida !important;
    font-size: 9pt !important;
    text-decoration: none !important;
    color: #666666 !important;
    font-weight: normal !important;
  }
  DIV.clsMDMenu A:hover span {
    font-family: lucida !important;
    text-decoration: underline !important;
    color: #666666 !important; 
    font-weight: normal !important;
  }

or whichever values you prefer.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Member
posted Hide Post
This is not about styling the pop-up. This is about styling the links created within the report that allow for the drill-thru.

Or are you saying that multidrill.css controlls this as well?


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Expert
posted Hide Post
Multi or single drilldown, these are links on an HTML page and unless you style them otherwise, they take on the default styling of the web browser, which is blue underlined hyperlinks.

The quickest method is as below - add HTMLFORM BEGIN and END and add styling to the anchor tag:

TABLE FILE CAR
PRINT
*
ON TABLE SET STYLE *
TYPE=DATA,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(204 204 204),
BORDER-BOTTOM-COLOR=RGB(204 204 204),
BORDER-LEFT-COLOR=RGB(204 204 204),
BORDER-RIGHT-COLOR=RGB(204 204 204),
BACKCOLOR='WHITE',
DRILLMENUITEM='Detailed Analysis',
FOCEXEC=pri_cube_view( \
AFF_GROUP=&AFF_GROUP.QUOTEDSTRING \
AFF_PARENT=&AFF_PARENT.QUOTEDSTRING \
AFFINITY=&AFFINITY.QUOTEDSTRING \
CHANNEL=&CHANNEL.QUOTEDSTRING \
COVER=&COVER.QUOTEDSTRING \
PRODUCT=&PRODUCT.QUOTEDSTRING \
QUOTE_MONTH=A2 \
QUOTE_YEAR=A1 \
),
TARGET='_self',
DRILLMENUITEM='Commission Code Breakdown',
URL=http://www.google.co.uk,
TARGET='_self',
$
TYPE=TITLE,
COLOR='BLACK',
BACKCOLOR=RGB(204 204 204),
DRILLMENUITEM='Detailed Analysis',
FOCEXEC=pri_cube_view( \
AFF_GROUP=&AFF_GROUP.QUOTEDSTRING \
AFF_PARENT=&AFF_PARENT.QUOTEDSTRING \
AFFINITY=&AFFINITY.QUOTEDSTRING \
CHANNEL=&CHANNEL.QUOTEDSTRING \
COVER=&COVER.QUOTEDSTRING \
PRODUCT=&PRODUCT.QUOTEDSTRING \
QUOTE_MONTH=A2 \
QUOTE_YEAR=A1 \
),
TARGET='_self',
DRILLMENUITEM='Commission Code Breakdown',
URL=http://www.google.co.uk,
TARGET='_self',
$

ENDSTYLE
END
-RUN

-HTMLFORM BEGIN
<style>
A {text-decoration: none; color: black;}
A:visited {color: black;}
A:hover {text-decoration: underline;}
</style>
-HTMLFORM END

This message has been edited. Last edited by: Francis Mariani,


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
Member
posted Hide Post
Thanks for that. I am looking at putting together a style sheet for our report. Looks like I can embedd this into it as well.

Thanks guys


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report 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] DRILLMENUITEM formatting

Copyright © 1996-2020 Information Builders