Hi,
Does anyone have any idea on how to get Hover text on the column titles in Excel and PDF format reports.
On searching, I got the codes to make it work on HTML format reports as follows:

  
-SET &TITLE_MSG =
-  '<span style="cursor: default;" ' | 'title=''This is a Country''>Country</span>';

TABLE FILE CAR
  SUM
    SALES           AS 'Sales'
    BY COUNTRY      AS '&TITLE_MSG'
  ON TABLE PCHOLD FORMAT HTML
END

But i need this functionality on Excel and PDF reports as well.

I tried something like this but it functions as Hyperlink which i doesn't want.

  
TYPE=TITLE,
COLUMN=N2,
JAVASCRIPT=#,
ALT= 'Retailer cost description',
STYLE=-UNDERLINE,
COLOR=BLACK,
$

If i use FOCEXEC = NONE and gave ALT attribute i am not getting the report itself.

Thank you.
Arun

This message has been edited. Last edited by: <Kathryn Henning>,

You should be able to do this in Excel, but PDF is another thing.

This will add comments to an EXL2K format report.

DEFINE  FILE CAR
Comments/A2000 = '<div style="mso-element:comment-list"><div style="mso-element:comment"><xml>'

               | '<v:shapetype id="_Comment1" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe"><v:stroke joinstyle="miter"/><v:path gradientshapeok="t" o:connecttype="rect"/></v:shapetype>'
               | '<v:shape id="comment1" type="#_Comment1" style="position:absolute;margin-left:107.25pt;margin-top:-7.5pt;width:96pt;height:55.5pt;z-index:1;visibility:hidden" fillcolor="infoBackground [80]" o:insetmode="auto">'
               | '<v:fill color2="infoBackground [80]"/><v:shadow on="t" color="black" obscured="t"/><v:path o:connecttype="none"/><v:textbox style="mso-direction-alt:auto"/><x:ClientData ObjectType="Note">'
               | '<x:MoveWithCells/><x:SizeWithCells/><x:AutoFill>False</x:AutoFill><x:Row>0</x:Row><x:Column>0</x:Column></x:ClientData></v:shape></xml>'
               | '<div v:shape="comment1" style="padding:.75pt 0pt 0pt .75pt;text-align:left" class=shape>This is the Country Column</div>'

               | '<v:shapetype id="_Comment2" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe"><v:stroke joinstyle="miter"/><v:path gradientshapeok="t" o:connecttype="rect"/></v:shapetype>'
               | '<v:shape id="comment2" type="#_Comment2" style="position:absolute;margin-left:107.25pt;margin-top:-7.5pt;width:96pt;height:55.5pt;z-index:1;visibility:hidden" fillcolor="infoBackground [80]" o:insetmode="auto">'
               | '<v:fill color2="infoBackground [80]"/><v:shadow on="t" color="black" obscured="t"/><v:path o:connecttype="none"/><v:textbox style="mso-direction-alt:auto"/><x:ClientData ObjectType="Note">'
               | '<x:MoveWithCells/><x:SizeWithCells/><x:AutoFill>False</x:AutoFill><x:Row>0</x:Row><x:Column>1</x:Column></x:ClientData></v:shape></xml>'
               | '<div v:shape="comment2" style="padding:.75pt 0pt 0pt .75pt;text-align:left" class=shape>This is the Car Column</div>'

               | '</div></div>' ;

END

TABLE   FILE CAR
 PRINT  
        COUNTRY   AS 'Country'
        CAR

 ON TABLE SUBFOOT
 "<Comments "

 ON     TABLE SET HTMLCSS ON
 ON     TABLE SET STYLE *
  TYPE=REPORT, TITLETEXT='Comments', $
  TYPE=TITLE, STYLE=BOLD, $
 ENDSTYLE
 ON   TABLE PCHOLD FORMAT EXL2K
END

-RUN

Thank you Waz. That works great in excel.

But that doesn't work when we have no data in our report and uses EMPTYREPORT ON.

I still keep this post open as i am working on how to get it in PDF format as well. Once i found i will post the codes and change the status of this post.

Thank you.
-Arun

I don't think you will find a solution for PDF - have you ever opened a PDF file that has a pop-up window when moving your cursor over text?

For Excel and PDF I would put the column title descriptions in a report footing (ON TABLE SUBFOOT). Alternatively, for Excel you could put them in a different tab by creating a compound report,

I suspect that PDF does support this, but WebFOCUS does not support the generation of the code in the PDF.

Back in 2011 I wanted tool tips for my graphs to appear in PDF so I opened a case with IBI and this was the result....

Updated: Apr 11, 2011 08:05 PM
Status/Action: RR/INFO

Support Group: IRT Rep: WILHELMINA HAGANS (WEH)
Severity: 3 - Application Issue

Michelle,
I've been informed by the graph division that tooltips is not supported in PDF
format. I will submit a new feature request for this functionality, you will
be contacted with additional information as it becomes available.
Regards,
Wilhelmina


and...


Updated: Dec 10, 2012 11:14 AM
Status/Action: CPGM/INFO

Support Group: RESWEB Rep: MONICA ROSA (MXV)
Severity: 3 - Application Issue

We have reviewed your request for a new feature with our engineering
staff and it has been determined that this feature will not be
implemented in the WebFOCUS product at this time.

Thank you for bringing this to our attention. If this decision
substantially impacts your business, please discuss with your local
account support team.

Sincerely,

Customer Support Services
Information Builders

It appears Tool Tips in Adobe Acrobat Reader are available, but only in JavaScript-based forms...

eHow: How to Create Mouseovers in Adobe Acrobat

I've got the PDf reference Guide, and it does state that some annotations can pop up.

But still back to square one, WF does not support it.

If I had the time I would write something similar to the PDF Effects I did a while ago, or add to it.

Thanks for the Info MAdams1.

Yes Francis, I am also looked at the same link you have shared. But I think we cannot implement javascript in PDF format through WebFOCUS.

Waz, If you can able to share some info about the annotations pop up i think i can give a try to that.

Meanwhile i am trying to hold and save the pdf file in disk and retrieve using HTMLFORMTYPE to use javascript, but it fails to use the javascript functionality in the file
I am not sure whether it will give me any positive side to use tooltip in pdf. Any thought about this? Whether this will work for us?

Thank you,
-Arun

Arun,

I would suggest downloading the PDF reference guide and checking out the annotations.

Keep in mind that the PDF document is quite complex and very structured.