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>,

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.

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.

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.

So there is nothing I can do in current version

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.

try
-SET &ECHO='OFF';
SET MSG=OFF

on top of your code.

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

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.