I have a procedure with a drilldown to 'URL from field'. When I run the fex and click on the drill down link I get an error rather than web browser opening the link.

Here is the error:

HTTP Status 404 - /approot/tedd/www.larmgroup.com/

--------------------------------------------------------------------------------

type Status report

message /approot/tedd/www.larmgroup.com/

description The requested resource (/approot/tedd/www.larmgroup.com/) is not available.


--------------------------------------------------------------------------------

Apache Tomcat/5.5.25

This message has been edited. Last edited by: Kathleen Butler,

A HTTP 404 message usually indicates an incorrect url (usually a misspelling).

Are you trying to link to an external website? (the 'www' makes me think you are)

If so, I think you need to remove the '/approot/tedd/' from the url.

Jeff is correct,
If you are still having a problem, share your code with us and we should be able to assist you more specifically.

It may be a Tomcat problem?

The field that I am directing the drill down to does not contain '/approot/tedd/' in it, WebFOCUS or Tomcat seems to be adding it.

Below is my code:


-SET &ECHO = ALL;
SET EMPTYREPORT = ON
SET NODATA = ''
JOIN
LISTING.LISTING.AUTHORIZATIONID IN LISTING TO UNIQUE
HOMESALE.HOMESALE.AUTHORIZATIONID IN HOMESALE AS J0
END
JOIN
LISTING.LISTING.AUTHORIZATIONID IN LISTING TO UNIQUE
AUTHORIZATIONS.AUTHORIZATIONS.AUTHORIZATIONID IN AUTHORIZATIONS AS J1
END
TABLE FILE LISTING
PRINT LISTING.LISTING.LISTINGPRICE
BY LISTING.LISTING.LISTINGPRICE NOPRINT
WHERE LISTING.LISTING.LISTINGTYPE EQ 'ORIGLIST';
WHERE AUTHORIZATIONID EQ '&AUTHORIZATIONID';
ON TABLE SAVE
END
-RUN
-IF &LINES GT 0 THEN GOTO ORIGLIST ELSE NO_ORIGLIST ;
-ORIGLIST
-READ SAVE &ORIGLISTING1.A21.
-GOTO RPT ;
-NO_ORIGLIST
-SET &ORIGLISTING1 = 0 ;
-RPT
DEFINE FILE LISTING
MLS_IMG/A50='';
END
TABLE FILE LISTING
PRINT
'LISTING.LISTING.LISTINGDATE/MDYY' AS 'Listing,Date'
'LISTING.LISTING.LISTINGTYPE' AS 'Listing,Type'
'LISTING.LISTING.LISTINGSTATUS' AS 'Listing,Status'
'LISTING.LISTING.LISTINGPRICE/P12CM' AS 'Listing,Price'
COMPUTE LISTPCT/D12.2% = LISTING.LISTING.LISTINGPRICE *100 /&ORIGLISTING1 ; AS '% of,Orignal List'
MLS_IMG AS ''
LISTUSER1 NOPRINT
BY 'AUTHORIZATIONS.AUTHORIZATIONS.AUTHORIZATIONID' AS 'Move,ID' NOPRINT
BY 'LISTING.LISTING.LISTINGDATE' NOPRINT
WHERE LISTING.LISTING.AUTHORIZATIONID EQ '&AUTHORIZATIONID';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=10,
STYLE=NORMAL,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
LINE=1,
COLOR='WHITE',
BACKCOLOR=RGB(79 38 131),
JUSTIFY=CENTER,
$
TYPE=HEADING,
SIZE=10,
$
TYPE=DATA,
COLUMN=N8,
TARGET='_blank',
JUSTIFY=CENTER,
URL=(LISTING.LISTING.LISTUSER1),
$
TYPE=FOOTING,
SIZE=8,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=8,
STYLE=NORMAL,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

quote:

www.larmgroup.com/

If you want to go to a URL that is not relative to the path that callled it then you must supply an absolute URL

so it should look like

http://www.larmgroup.com/

You would create this using a compute

LISTUSER1 NOPRINT

Would become COMPUTE LISTUSER_URL/A200= 'HTTP://'||LISTUSER1; NOPRINT

and your drilldown URL=(LISTUSER_URL),

JG, your solution does work. Although I still think IBI needs to look at Dev Studio further to find out why this is happening. This procedure was created using Dev Studio and its option to drill down to a field that contains a URL. I would think it should work automatically if that is the case.
Thanks for the assistance!

As JG has suggested, coding the http:// will make the URL work.

I just created a test fex with Dev Studio Report Painter and created a drilldown with this URL "http://www.cnn.com", just typed it in - no computed field, and it works as expected.

The code generated by Dev Studio Report Painter:

TABLE FILE CAR
SUM 
     LENGTH
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=DATA,
     COLUMN=N5,
     URL=http://www.cnn.com,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END

Good point, you need the raise a New Feature Request (NFR).

Dev Studio assumes that all URLs are relative to the ibi_apps application server setting.

There should be a check box when creating a URL drilldown such as 'absolute path'.

If you know about the issue it's easy, you just edit the code. However it's a GUI tool so it should really
be accommodated.

As I mentioned, you don't need to edit the code, just code the URL with the http://.

Hi Francis,

I just want to let you know that adding the http:// to the url does not solve this issue. It only solves the issue if you are hard-coding the URL in the CSS. If you're using a field value to pass the url, the presence of http:// doesn't eliminate the approot stuff.

Here's a code for you to try:

DEFINE FILE CAR
URLFLD/A255V='http://www.google.com';
END
TABLE FILE CAR
SUM 
     LENGTH
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
BY URLFLD NOPRINT
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=DATA,
     COLUMN=N6,
     URL=(N5),
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END

If anybody figured out a solution to this one using the URL= parameter, I'd appreciate it. I solved it by passing the url in the field to a fex as the drillmenuitem. Idiotic way to do it, but, alas, it's the only way I could find.