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?
WebFOCUS 8206, Unix, Windows
June 19, 2017, 09:47 AM
info4pal
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.
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?'
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 20, 2017, 01:52 AM
info4pal
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.
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
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
June 22, 2017, 05:08 AM
info4pal
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, IPThis message has been edited. Last edited by: info4pal,
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.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 26, 2017, 03:30 PM
FP Mod Chuck
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.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 27, 2017, 01:48 AM
info4pal
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.
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