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,

I posted something a while ago about styling the popup.

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.

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?

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,

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