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] Need to Post Excel File on HTML in MRE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Need to Post Excel File on HTML in MRE
 Login/Join
 
Gold member
posted
We have a dashboard where we would like to post a hyperlink on the HTML page to an excel file that is located in "Managed Reporting/Domains/[domain_name]/other/file.xlsx"

I could not figure out how to link this in the HTML composer.

I did see a few discussions but did not find a resolution.

I tried accessing it using the URL address : http://devwebfocus:8080/approo..._name]/filename.xlsx but could not get any variant of this URL to work.

Can someone reveal the URL necessary needed to link to a file in the Managed Reporting tree? Or is this only posssible through a procedure? I do not want to create a proc if we can get away with inserting the URL..

Thank you for your help,

This message has been edited. Last edited by: Joey Sandoval,




Prod/Dev: WebFOCUS 8.0.08 on Windows Server 2008/Tomcat , WebFOCUS DevStudio 8.0.08 on Windows 7 Pro


 
Posts: 94 | Location: Austin, TX | Registered: August 08, 2012Report This Post
Master
posted Hide Post
I have also had the same issues. We've always had to put it in a path on the APP side (c:\ibi\apps\ibinccen\ is where our "web stuff" resides).

From there, the link looks like you've said and we can write the output in WebFOCUS and link it in the results page.

I'm interested to see if there is a solution as this is definitely a workaround.

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Gold member
posted Hide Post
ABT,
So you post in an app directory? What is the URL address you use?

For example, I tried the following to bring up a n image with no success

quote:




Prod/Dev: WebFOCUS 8.0.08 on Windows Server 2008/Tomcat , WebFOCUS DevStudio 8.0.08 on Windows 7 Pro


 
Posts: 94 | Location: Austin, TX | Registered: August 08, 2012Report This Post
Virtuoso
posted Hide Post
Doesn't release 8 eliminate MR's HTTP-addressable folder structure, and place the MR library elements in a database?


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Master
posted Hide Post
Couple examples:

As a logo in a stylesheet:
TYPE=REPORT,
     GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=8, STYLE=NORMAL,
    RIGHTGAP=0.05000, LEFTGAP=0.05000,
$
TYPE=HEADING,
  IMAGE=http://server:8080/approot/ibinccen/images/my_logo.gif,
  POSITION=(0 0), SIZE=(2.30 0.62),$
TYPE=HEADING, SIZE=10,STYLE=BOLD, COLOR=RGB(0 0 128),$



As an image display in HTML output (DEFINE)
	IMGFREQ/A3000V         = IF PRIORITYIDSORT EQ '1' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/d1_' | D1_ACTIVE_YN   | '.gif'' alt=''Daily 1'' height=''20'' width=''20'' />'  ELSE
                             IF PRIORITYIDSORT EQ '2' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/d2_' | D2_ACTIVE_YN   | '.gif'' alt=''Daily 2'' height=''20'' width=''20'' />'  ELSE
                             IF PRIORITYIDSORT EQ '3' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/d3_' | D3_ACTIVE_YN   | '.gif'' alt=''Daily 3'' height=''20'' width=''20'' />'  ELSE
                             IF PRIORITYIDSORT EQ '4' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/w_'  | W_ACTIVE_YN    | '.gif'' alt=''Weekly'' height=''20'' width=''20'' />'   ELSE
                             IF PRIORITYIDSORT EQ '5' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/bi_' | BI_ACTIVE_YN   | '.gif'' alt=''BiWeekly'' height=''20'' width=''20'' />' ELSE
                             IF PRIORITYIDSORT EQ '6' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/m_'  | M_ACTIVE_YN    | '.gif'' alt=''Monthly'' height=''20'' width=''20'' />'  ELSE
                             IF PRIORITYIDSORT EQ '7' THEN '<img src=''http://server:8080/approot/ibinccen/images/pulse/infostat/6w_' | SIXW_ACTIVE_YN | '.gif'' alt=''Six Week Planning Period'' height=''20'' width=''20'' />';



As a redirect to a file produced in an earlier step:
-* This Code heavily borrowed from the 'Poor man's reporting library' article.

-SET &PGMNAME = UPCASE(64,&MR_ITEM_HANDLE,&MR_ITEM_HANDLE);
-SET &REMOTESERVER = GETTOK(&SERVER_NAME,&SERVER_NAME.LENGTH,1,'.',&SERVER_NAME.LENGTH,'A50');
-SET &REMOTESERVER = UPCASE(50,TRUNCATE(&REMOTESERVER),TRUNCATE(&REMOTESERVER));



-***********************************************************************
-SET &APPFILE = &PGMNAME||'.PDF';
APP FILEDEF &PGMNAME DISK LIBRARY/&APPFILE
-***********************************************************************

TABLE FILE CAR
PRINT
*

-***********************************************************************
ON TABLE HOLD AS &PGMNAME FORMAT PDF
-***********************************************************************

END




-***********************************************************************
-SET &FILENAME = LOCASE(10,&PGMNAME,&PGMNAME);
-SET &LINK = 'http://' || &REMOTESERVER || ':8080/approot/library/'||&FILENAME||'.pdf';
-HTMLFORM BEGIN
<html> <head> <meta HTTP-EQUIV="REFRESH" content="0; url=&LINK"/> </head> <body> !IBI.FIL.REPORT; </body> </html>
-***********************************************************************




Same as above but with HTML output user sees and can interact with:
-* This Code heavily borrowed from the 'Poor man's reporting library' article.

-SET &PGMNAME = UPCASE(64,&MR_ITEM_HANDLE,&MR_ITEM_HANDLE);
-SET &REMOTESERVER = GETTOK(&SERVER_NAME,&SERVER_NAME.LENGTH,1,'.',&SERVER_NAME.LENGTH,'A50');
-SET &REMOTESERVER = UPCASE(50,TRUNCATE(&REMOTESERVER),TRUNCATE(&REMOTESERVER));



-***********************************************************************
-SET &APPFILE = &PGMNAME||'.PDF';
APP FILEDEF &PGMNAME DISK LIBRARY/&APPFILE
-***********************************************************************

TABLE FILE CAR
PRINT
*

-***********************************************************************
ON TABLE HOLD AS &PGMNAME FORMAT PDF
-***********************************************************************

END




-***********************************************************************
-SET &FILENAME = LOCASE(10,&PGMNAME,&PGMNAME);
-SET &LINK = 'http://' || &REMOTESERVER || ':8080/approot/library/'||&FILENAME||'.pdf';

-HTMLFORM BEGIN
<html> 
<head> </head>
<a href="&LINK"> Click here for &PGMNAME output.</a> 
</body> 
</html>
-HTMLFORM END
-***********************************************************************


- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Master
posted Hide Post
quote:
Originally posted by j.gross:
Doesn't release 8 eliminate MR's HTTP-addressable folder structure, and place the MR library elements in a database?


I hope so. I've been disappointed with IBI's adoption of RDBMS backends to support it's internal functionality (i'm talking to you MRE). I want *everything* to be structured like ReportCaster's RDBMS. Users, Roles, Domains , etc -- everything. Minus those ^%$&^$&^-ing epoch based dates cast as chars...

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Gold member
posted Hide Post
So ABT do you have to use a procedure to accomplish this? If I open up the HTML composer and add a hyperlink to the page, would it be possible to somehow paste the url code directly into the html?




Prod/Dev: WebFOCUS 8.0.08 on Windows Server 2008/Tomcat , WebFOCUS DevStudio 8.0.08 on Windows 7 Pro


 
Posts: 94 | Location: Austin, TX | Registered: August 08, 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] Need to Post Excel File on HTML in MRE

Copyright © 1996-2020 Information Builders