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     [SOLVED]Drilldown error in excel

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Drilldown error in excel
 Login/Join
 
Guru
posted
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,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Guru
posted Hide Post
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!


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Virtuoso
posted Hide Post
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?'


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Guru
posted Hide Post
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


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Guru
posted Hide Post
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


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Guru
posted Hide Post
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,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Guru
posted Hide Post
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


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Virtuoso
posted Hide Post
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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
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( \


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Guru
posted Hide Post
Hi Chuck,

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

Thanks a lot again for all your help Smiler

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report 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     [SOLVED]Drilldown error in excel

Copyright © 1996-2020 Information Builders