Hi,
I have a report(parent report) which opens in excel and the output format is
EXCEL and Iam using the below format :

Parent report:

SET FOCEXURL = 'http://MYCLM/ibi_apps/WFServlet?'

TABLE FILE CAR
.....
.....
.....
.....
ON TABLE HOLD FORMAT HTMTABLE
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=ON, FONT='ARIAL', SIZE=9, $
TYPE=TITLE, STYLE=BOLD, $
TYPE=HEADING, SIZE=12, STYLE=BOLD, HEADALIGN=BODY, $
TYPE=HEADING, LINE=1, OBJECT=FIELD, ITEM=1, COLSPAN=2, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=1, OBJECT=FIELD, ITEM=2, COLSPAN=3, CLASS=headstyle, $
TYPE=HEADING, LINE=1, OBJECT=FIELD, ITEM=3, COLSPAN=3, CLASS=headstyle, $
TYPE=DATA,
     COLUMN=N4,
     FOCEXEC=IBFS:/WFC/Repository/Development/Report/Drilldown.fex(CAR=N1 COUNTRY=N2 DATA=N3 SEATS='&SEATS'),TARGET=_blank,
	 $
ENDSTYLE
END

SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
<style type="text/css">
.headstyle {font-family:Arial; font-size:12pt; font-weight:bold; text-align:center; background:rgb(210,210,210); border: 1px solid black;}
</style>
!IBI.FIL.HOLD;
-HTMLFORM END

Child report:Drilldown.fex
TABLE FILE CAR
....
....
END
-EXIT  

And I have the drilldown on the data values in my parent report and once I try opening the hyperlinks on the drilldown values,I get this message :

Unable to open: http://myclm/ibi_apps/WFServle........................
...................................................................................
Cannot locate the Internet Server or proxy server.

Please let me know what am I doing wrong.
Thanks a lot in advance!

Regards,
IP

This message has been edited. Last edited by: info4pal,

What version of WebFOCUS are you using? Is there a FOC error associated with this? Has this worked in the past? I'm also wondering why you're not using ON TABLE PCHOLD FORMAT XLSX?

Hi BabaNYC,

Iam using webfocus dev studio 8105 version.
Since excel borders are not getting formatted properly,Iam using this method.

Iam trying this method in excel for the 1st time now and I haven't encountered anything in the past earlier as such with respect to the drilldown.

Hope this answers your question.

Thanks!

Hi Info4pal

Just want to verify that your web server port is port 80. By default WebFOCUS assumes you are using Apache Tomcat which by default is port 8080. Try changing your SET FOCEXURL = 'http://MYCLM/ibi_apps/WFServlet?' to SET FOCEXURL = 'http://MYCLM:8080/ibi_apps/WFServlet?'

Hi Chuck,

I tried with this as you suggested :
SET FOCEXURL = 'http://MYCLM:8080/ibi_apps/WFServlet?'

But Iam getting the same error message as earlier.
Cannot locate the Internet Server or Proxy server.

Any suggestions on how to resolve this?

Thanks a lot in advance.

Regards,
IP

info4pal,

When you say the borders are not getting formatted properly - please explain or show a screenshot of the issue.

You should not need the HTMLFORM logic, you can drilldown directly from your XLSX report.

Unless there is particular reason for the way you have it set up.

Using Excel Display Formats: XLSX, EXL2K, EXL97, EXCEL

Borders/drilldown are all working in WebFOCUS 8105M - are you using the latest version of the software.


Thank you for participating in the Focal Point Forum!
Tamra Colangelo
Focal Point Moderator
Information Builders

Hi,

I tried using Excel versions and the borders aren't working as expected(Sometimes I don't get the bottom border and also the color coding disappears for few of the headings).Hence Iam using this method(HTMTABLE).

Iam using webfocus developer studio 8105 version.

Here is a sample code using the CAR file.
Drilldown report(parent):

-SET &ECHO='ALL';

SET FOCEXURL = 'http://myclm/ibi_apps/WFServlet?'

DEFINE FILE CAR
FIRST_HEAD1/A20='Car heading';
SECOND_HEAD2/A10='Period';
A/A3='';
THIRD_HEAD3/A15='Target deadline';
HEAD1/A10='15% to 39%';
HEAD2/A10='40% to 69%';
HEAD3/A11='70% to 100%';
END

TABLE FILE CAR
PRINT 
COUNTRY
CAR  
MODEL 
BODYTYPE
SEATS 
DEALER_COST 
RETAIL_COST  
SALES 
LENGTH
WIDTH 
HEIGHT 
WEIGHT 
WHEELBASE 
FUEL_CAP
BHP 
RPM 
HEADING
"Car Categories report"
"SOURCE:CAR Data"
"Data Current as of TODAY"
" "
"<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3"
"<A<HEAD1<HEAD2<HEAD3"
ON TABLE HOLD AS HOLD_FILE FORMAT HTMTABLE
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=12,GRID=ON,TITLETEXT='Car Report',WRAP=OFF,BORDER=.1,$
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,BORDER=.1,$
TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,BORDER=.1,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,BORDER=.1,$
TYPE=HEADING,LINE=4,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=9,BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=2,COLOR='BLACK',FONT='ARIAL',SIZE=9,BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=6,JUSTIFY=CENTER,COLOR=RGB(139 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=2,COLOR='BLACK',FONT='ARIAL',SIZE=9,BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,BORDER-COLOR=BLACK,$
TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=+BOLD-UNDERLINE,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$
TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,BORDER=.1,$
FOCEXEC=IBFS:/WFC/Repository/Folder_Reporting/Development-Folder/Sample_report_folder/Car_file/car_file_sample/Car_drilldown2.fex(SEATS=N5),TARGET=_blank,
$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
<style>
table, th, td {
    border: 1px solid black;
	border-collapse: collapse;
	}
td {
    padding-left: 8px;
    padding-right: 8px;
}
</style>
!IBI.FIL.HOLD_FILE;
-HTMLFORM END
-EXIT


  

Drilldown2(child) report:

 TABLE FILE CAR
PRINT CAR 
BODYTYPE 
MODEL 
DEALER_COST
SEATS
WHERE SEATS EQ &SEATS
ON TABLE PCHOLD FORMAT EXL07
END
-EXIT 

myclm is the name of my server and that is the reason I have used it in the FOCEXURL.

Once I click on the hyperlink in the parent report,I do not get the child report(drilldown2) opened instead Iam getting an error message saying : "Cannot locate the Internet server or the proxy server".

Can anyone please let me how to make this work?

Regards,
IP

This message has been edited. Last edited by: info4pal,

Hi InfoPal

I am a little confused. Is myclm where WebFOCUS is installed or is it your machine?

Also I don't see any styling in the drill down report.

Hi IP

I took you code and changed ON TABLE HOLD AS HOLD_FILE FORMAT HTMLTABLE with ON TABLE PCHOLD FORMAT EXL07
and eliminated the htmlform code. I also removed the SET FOCEXURL code. I got the first report just fine and when I drilled down got a couple of warning messages but the output from the drill down displayed just fine.

Hope this helps.

Hi Chuck,

MYCLM is the name of my data server.
When we use the ON TABLE PCHOLD FORMAT EXL07,I still get the drilldowns not working and my major concern is the borders not appearing for the headings "Car Categories report,SOURCE:CAR Data,Data Current as of TODAY, Car heading, Period, Target deadline,15% to 39%,40% to 69%and also for 70% to 100%.

Due to the border issues in the heading only,Iam using the HTMLFORM method with the SET HTMLFORMTYPE=XLS.

Hope you got this point.

Regards,
IP

Hi IP

Please try the following code. I think it is what you want the results to look like.


DEFINE FILE CAR
FIRST_HEAD1/A20='Car heading';
SECOND_HEAD2/A10='Period';
A/A3='';
THIRD_HEAD3/A15='Target deadline';
HEAD1/A10='15% to 39%';
HEAD2/A10='40% to 69%';
HEAD3/A11='70% to 100%';
END

TABLE FILE CAR
-*ON TABLE PCHOLD FORMAT EXL07
PRINT
CAR.ORIGIN.COUNTRY
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.BODYTYPE
CAR.BODY.SEATS
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
CAR.SPECS.LENGTH
CAR.SPECS.WIDTH
CAR.SPECS.HEIGHT
CAR.SPECS.WEIGHT
CAR.SPECS.WHEELBASE
CAR.SPECS.FUEL_CAP
CAR.SPECS.BHP
CAR.SPECS.RPM
HEADING
"Car Categories report"
"SOURCE:CAR Data"
"Data Current as of TODAY"
" "
" <+0> <+0> <+0> <+0> <+0> <+0> <+0> <+0> <+0> "
" <+0> <+0> <+0> <+0> <+0> <+0> <+0> <+0> <+0> <+0> "
ON TABLE SET PAGE NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
SQUEEZE=ON,
TITLETEXT='Car Report',
$
TYPE=REPORT,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
FONT='ARIAL',
SIZE=12,
FOCEXEC=IBFS:/WFC/Repository/Sandbox/Car_drilldown2.fex( \
SEATS=N5 \
),
TARGET='_blank',
$
TYPE=DATA,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR=RGB(169 169 169),
STYLE=-UNDERLINE+BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
HEADALIGN=BODY,
$
TYPE=HEADING,
LINE=1,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=10,
COLSPAN=16,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLSPAN=16,
STYLE=BOLD+ITALIC,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=3,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLSPAN=16,
STYLE=BOLD+ITALIC,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=4,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLSPAN=16,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=3,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=4,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=5,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=6,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=7,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=8,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=9,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=10,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=11,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=4,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=5,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
ITEM=1,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLSPAN=2,
$
TYPE=HEADING,
LINE=5,
ITEM=2,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
BACKCOLOR=RGB(210 210 210),
COLSPAN=1,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=5,
ITEM=3,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
BACKCOLOR=RGB(210 210 210),
COLSPAN=1,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=5,
ITEM=4,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLSPAN=6,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=5,
ITEM=5,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLOR=RGB(139 0 0),
BACKCOLOR=RGB(210 210 210),
COLSPAN=6,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=3,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=4,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=5,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=6,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=7,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=8,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=9,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=10,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=11,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=12,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=4,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
ITEM=1,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
COLSPAN=2,
$
TYPE=HEADING,
LINE=6,
ITEM=2,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
BACKCOLOR=RGB(210 210 210),
COLSPAN=4,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=6,
ITEM=3,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
SIZE=9,
BACKCOLOR=RGB(210 210 210),
COLSPAN=4,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=6,
ITEM=4,
BORDER-TOP=0.10,
BORDER-BOTTOM=0.10,
BORDER-LEFT=0.10,
BORDER-RIGHT=0.10,
BORDER-TOP-COLOR='BLACK',
BORDER-BOTTOM-COLOR='BLACK',
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
SIZE=9,
BACKCOLOR=RGB(210 210 210),
COLSPAN=6,
STYLE=BOLD,
JUSTIFY=CENTER,
$
ENDSTYLE
END
-RUN


IP

I had changed the drill down so it worked on my machine. You will want to replace my line of code


FOCEXEC=IBFS:/WFC/Repository/Sandbox/Car_drilldown2.fex( \


with this...


FOCEXEC=IBFS:/WFC/Repository/Folder_Reporting/Development-Folder/Sample_report_folder/Car_file/car_file_sample/Car_drilldown2.fex( \


Hi Chuck,

Sorry for the delay in response.
Iam working EXL97 format and your code worked.

Thanks a lot again for all your help

Regards,
IP