When I use any form of the BORDERS styling command it results in a crashed agent. If I take the BORDER command out it works fine. Code is below. Any suggestions?


DEFINE FILE T6_VS_T6B_SUPPORT_SCHED_VW
NET_TRAN_SBH/A16 = 'Net Transactions';
-*ACCT_BAL_M_SBH/A29 = 'Account Balances[$ millions]';
-*ACCT_BAL_A_SBH/A41 = 'Account Balances [actual monetary amount]';
FYTD/A19 = 'Fiscal Year to Date';
BEG_OF/A12 = 'Beginning Of';
CLS_OF/A8 = 'Close Of';
THIS_MO/A10 = 'This Month';
THIS_YR/A9 = 'This Year';
PR_YR/A10 = 'Prior Year';
END

-SET &SBHD3 = 'Table 6 vs. Supporting Schedules B, D, E - Total Line Comparisons:';

TABLE FILE T6_VS_T6B_SUPPORT_SCHED_VW
-*HEADING CENTER
-*"Item 1 <+0> Item 2 <+0> Item 3"
PRINT REPORT_DESCRIPTION NOPRINT
BY ACCTNG_PRD NOPRINT
WHERE ACCTNG_PRD EQ '&REPORTING_PERIOD';
ON ACCTNG_PRD SUBHEAD
-*ON TABLE SUBHEAD
" "
"&SBHD3"
" "
"Description: "Comparison: " "
"<3>Net Transactions "
-*<+0> Account Balances - $ millions <+0> Account Balances - actual monetary amount"
-*"<3>-*"<6>-*"-*"<0>-*"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT HTML
-*ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
RIGHTMARGIN=0.15,
LEFTMARGIN=0.50,
$
-*TYPE=REPORT, BORDER=LIGHT, $
TYPE=REPORT, FONT='ARIAL', SIZE=9, $
-*
-*TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, BORDER=LIGHT, $
-*
TYPE=SUBHEAD, BY=ACCTNG_PRD, LINE=7, OBJECT=TEXT, ITEM=1, BORDER=LIGHT, $
-*TYPE=SUBHEAD, BY=ACCTNG_PRD, LINE=4, OBJECT=FIELD, ITEM=2, BORDER=LIGHT,$
-*TYPE=SUBHEAD, BY=ACCTNG_PRD, LINE=4, OBJECT=FIELD, ITEM=3, BORDER=LIGHT,$
-*
-*ENDSTYLE
END
-EXIT

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

WebFOCUS 7.7.02
Unix
All Output

Hi Antione,

Here is the suggestion from our product manager.

It is very difficult to assess since I cannot run this without a workable data source.

The only thing I think I see that is off is that internal borders in headings are only supported when HEADALIGN=BODY is defined to create an alignment grid. The subhead definition is attempting to border a single item within that heading. We would not expect this to crash but I would not expect this to give you the results you are seeking either. I would suggest that you can try adding HEADALIGN=BODY to any styling nodes where youwant to define internal borders. In this case it would appear you will need to add:

TYPE=SUBHEAD, HEADALIGN=BODY, $

This could be more reliably assessed with a repro we could run. If this suggestion does not resolve the issue, please contact Customer Support Services to open a case and provide a repro where we can review the behavior together with you. If we can see the crash we will try to prioritize resolving it and in the meantime work with you to find the appropriate workaround. To open a case, you may call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

Kerry, thanks for posting a response to this issue. I do not have detail print lines in the report as I am really only using SUBHEADS to create the report. I had to end up taking out my beginning markers in the SUBHEAD that moves the text over (ie..<3>) while using the BORDERS command. This was a work-a-round fix. This is what was causing the crashed agent strangely enough.

[Solved]Originally posted by MCKELPA99:
When I use any form of the BORDERS styling command it results in a crashed agent. If I take the BORDER command out it works fine. Code is below. Any suggestions?


DEFINE FILE T6_VS_T6B_SUPPORT_SCHED_VW
NET_TRAN_SBH/A16 = 'Net Transactions';
-*ACCT_BAL_M_SBH/A29 = 'Account Balances[$ millions]';
-*ACCT_BAL_A_SBH/A41 = 'Account Balances [actual monetary amount]';
FYTD/A19 = 'Fiscal Year to Date';
BEG_OF/A12 = 'Beginning Of';
CLS_OF/A8 = 'Close Of';
THIS_MO/A10 = 'This Month';
THIS_YR/A9 = 'This Year';
PR_YR/A10 = 'Prior Year';
END

-SET &SBHD3 = 'Table 6 vs. Supporting Schedules B, D, E - Total Line Comparisons:';

TABLE FILE T6_VS_T6B_SUPPORT_SCHED_VW
-*HEADING CENTER
-*"Item 1 <+0> Item 2 <+0> Item 3"
PRINT REPORT_DESCRIPTION NOPRINT
BY ACCTNG_PRD NOPRINT
WHERE ACCTNG_PRD EQ '&REPORTING_PERIOD';
ON ACCTNG_PRD SUBHEAD
-*ON TABLE SUBHEAD
" "
"&SBHD3"
" "
"Description: "Comparison: " "
"<3>Net Transactions "
-*<+0> Account Balances - $ millions <+0> Account Balances - actual monetary amount"
-*"<3>-*"<6>-*"-*"<0>-*"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT HTML
-*ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
RIGHTMARGIN=0.15,
LEFTMARGIN=0.50,
$
-*TYPE=REPORT, BORDER=LIGHT, $
TYPE=REPORT, FONT='ARIAL', SIZE=9, $
-*
-*TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, BORDER=LIGHT, $
-*
TYPE=SUBHEAD, BY=ACCTNG_PRD, LINE=7, OBJECT=TEXT, ITEM=1, BORDER=LIGHT, $
-*TYPE=SUBHEAD, BY=ACCTNG_PRD, LINE=4, OBJECT=FIELD, ITEM=2, BORDER=LIGHT,$
-*TYPE=SUBHEAD, BY=ACCTNG_PRD, LINE=4, OBJECT=FIELD, ITEM=3, BORDER=LIGHT,$
-*
-*ENDSTYLE
END
-EXIT[/QUOTE]

WebFOCUS 7.7.02
Unix
All Output