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.
If i use FOCEXEC = NONE and gave ALT attribute i am not getting the report itself.
Thank you. ArunThis message has been edited. Last edited by: <Kathryn Henning>,
April 11, 2013, 05:38 PM
Waz
You should be able to do this in Excel, but PDF is another thing.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 11, 2013, 07:50 PM
Waz
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
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 15, 2013, 04:30 AM
Arunkumar
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
April 15, 2013, 10:49 AM
Francis Mariani
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,
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
April 15, 2013, 05:53 PM
Waz
I suspect that PDF does support this, but WebFOCUS does not support the generation of the code in the PDF.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 16, 2013, 08:48 AM
MAdams1
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....
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
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
April 16, 2013, 02:17 PM
Francis Mariani
It appears Tool Tips in Adobe Acrobat Reader are available, but only in JavaScript-based forms...
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
April 16, 2013, 05:47 PM
Waz
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.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 17, 2013, 03:54 AM
Arunkumar
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
April 17, 2013, 05:45 PM
Waz
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.