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,

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

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:

http://devwebfocus:8080/APPROO...val/other/redpin.png

Doesn't release 8 eliminate MR's HTTP-addressable folder structure, and place the MR library elements in a database?

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

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

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?