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] Trying to schedule an accordion report and get this????

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Trying to schedule an accordion report and get this????
 Login/Join
 
Silver Member
posted
This is the part that I don't understand:
BTP1020 Task error: EXPANDBYROW: Not supported with BORDER.

What is BORDER???


The entire log is below:

ReportCaster Log Report Schedule ID: S53e752a6s686cs4e9es8ba7s4884d2be9f94, Job Description: # All P0's


Process: Je8617fbbjed12j4677ja83ejda4f736a8a36
Schedule ID: S53e752a6s686cs4e9es8ba7s4884d2be9f94
Start Time: 2015-04-10 11:19:01
End Time: 2015-04-10 11:19:05


Message Code Message Text

BTP1010 Schedule Executed Due To NEXTRUNTIME at Bonneville:8200
BTP1010 Job placed in the waiting queue at 2015-04-10 11:19:01.015-0400 (1,428,679,141,015)
BTP1010 Job started running at 2015-04-10 11:19:01.016-0400 (1,428,679,141,016)
BTP1010 Job remained in waiting queue for 0.0010 seconds
BTP1020 Starting task: Task 1
BTP1020 Task type: WebFOCUS Report
BTP1020 Task domain: manufact/
BTP1020 Retrieving WebFOCUS Report: IBFS:/WFC/Repository/manufact/~kjohnson/customreports/custrep1417921865562641810/All_P0s_for_Lyman_Sale_90228a2c_02f6_49dc
BTP1020 Connecting to server EDASERVE with execution id kjohnson at 2015-04-10 11:19:01.251-0400 (1,428,679,141,251)
BTP1020 Connection to the Reporting Server EDASERVE established at 2015-04-10 11:19:01.495-0400 (1,428,679,141,495)
BTP1020 The time to establish a connection to the Reporting Server EDASERVE was 0.244 seconds
BTP1020 Executing focexec.
BTP1020 ...REPORT KILLED
BTP1020 Connection to the Reporting Server EDASERVE closed at 2015-04-10 11:19:05.037-0400 (1,428,679,145,037)
BTP1020 Job ran on the Reporting Server EDASERVE for 3.542 seconds
BTP1020 Task error: EXPANDBYROW: Not supported with BORDER.
BTP1010 No report to distribute.
BTP1010 Job finished at 2015-04-10 11:19:05.052-0400 (1,428,679,145,052)
BTP1010 Job time on distribution server after the report completed was 0.0 seconds
BTP1010 Total running time was 4.036 seconds
BTP1010 Total elapsed time (including the queue time) was 4.037 seconds

This message has been edited. Last edited by: <Kathryn Henning>,


Release: WebFOCUS 8
Windows
HTML, PDF, EXCEL
 
Posts: 40 | Registered: October 24, 2013Report This Post
Guru
posted Hide Post
Hi Pops,

I am following up with you regarding your question.

Usually a BORDER is referring to the stylesheet within the report. Do you have borders around fields or columns within the report. In the GUI tool did you add in borders? Remove the border and run the report Caster job again.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Silver Member
posted Hide Post
I'm using the default Stylesheet and it works with other reports, only difference in this report and the other reports that I've scheduled is the accordion feature.

Thanks.


Release: WebFOCUS 8
Windows
HTML, PDF, EXCEL
 
Posts: 40 | Registered: October 24, 2013Report This Post
Guru
posted Hide Post
Hi Pops,

Here is what I have found regarding your question about the error message you received within Report Caster.

The functionality of EXPANDBYROW within Report Caster is fixed in the WebFOCUS 8.1 release.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Silver Member
posted Hide Post
So there is nothing I can do in current version


Release: WebFOCUS 8
Windows
HTML, PDF, EXCEL
 
Posts: 40 | Registered: October 24, 2013Report This Post
Member
posted Hide Post
I'm using InfoAssist on 8.1.05M and am getting this exact same error message... so, I'm guessing that the fix didn't work.

Can't seem to figure out how to turn off the darn border either.


WebFOCUS 8.1.05,
Windows 7,
All output types
 
Posts: 13 | Location: Alpharetta, GA | Registered: May 30, 2014Report This Post
Platinum Member
posted Hide Post
try
-SET &ECHO='OFF';
SET MSG=OFF

on top of your code.


8.2.06
Windows, All Formats
 
Posts: 184 | Registered: December 27, 2013Report This Post
Member
posted Hide Post
I question the "SOLVED" assignment to this. We are currently using 8.1.05M

My report request in returning the same error code -
(FOC3330) EXPANDBYROW: Not supported with BORDER.

The only way I can get the error to go away is if I take all styling out of my style sheet. Has anyone had any luck getting this to work properly?





ON TABLE SET HTMLCSS ON
ON TABLE SET EXPANDBYROW ON
ON TABLE SET DROPBLNKLINE ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
-*
	     INCLUDE = endeflt,$
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.2500000,
TOPMARGIN=0.00000,
BOTTOMMARGIN=0.100000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
SQUEEZE=ON,
BORDER=OFF,$

     FONT='ARIAL',
     SIZE=9,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     RIGHTGAP=0.0800,
	 LEFTGAP=0.0800,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$

 TYPE = REPORT,FONT='ARIAL',COLOR='BLACK', $
TYPE=TABFOOTING,FONT='ARIAL',SIZE=7,STYLE=BOLD,$
TYPE=FOOTING,SIZE=8,FONT='ARIAL',COLOR='BLACK',STYLE=BOLD,$
-*TYPE=TITLE,JUSTIFY=CENTER,$
ENDSTYLE
END





~J
Prod: 8.2.03 | OS: AIX | Outputs: you name it...you got it
Dev: We don't need no stinkin dev box!
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I may not understand a darn thing you say, but I will defend to the death your right to confuse me.
 
Posts: 6 | Location: Texas | Registered: November 01, 2006Report This Post
Master
posted Hide Post
quote:
Originally posted by Tamra:
Hi Pops,

Here is what I have found regarding your question about the error message you received within Report Caster.

The functionality of EXPANDBYROW within Report Caster is fixed in the WebFOCUS 8.1 release.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.


I believe this is referring to one of my problem reports (23353543). When delivered via email, the report would not expand. In 8.0.08, the report in report caster run just fine and was delivered but it would not expand. This was reported to me to be fixed in 8201M.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report 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] Trying to schedule an accordion report and get this????

Copyright © 1996-2020 Information Builders