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     Error on trying to total on group/section Error

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Error on trying to total on group/section Error
 Login/Join
 
Gold member
posted
Have the below code and getting an error:

An error has been detected during server to client data transfer.
ERROR: -12: Pcb2.: java.net.SocketException: Connection reset

All I need to do is have a total per section???
TABLE FILE SMART_CONTRACT_HOLD
PRINT
'Company_Name' AS 'Cede Name'
'Contract_ID/A10' AS 'Contract '
'MGA_Name' AS 'MGA Name'
'Description_or_Insured/A50' AS 'Short Desc'
'Contract_Class_Desc' AS 'Class'
'Contract_Effective_Date/HMDY' AS 'Eff Date'
'Anniversary_Date/HMDY' AS 'Ann Date'
'FRC_Premium/P17N'
'FRC_Percent/D10.2' AS 'FRC Percent'
'Broker_Contact/A35' AS 'Broker Contact'
'Underwriter_Name/A35' AS 'Underwriter'
BY
'Broker_City'

ON Broker_City SUBTOTAL AS '*TOTAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N8,
SIZE=8,
$
TYPE=DATA,
COLUMN=N10,
SIZE=8,
$
TYPE=DATA,
COLUMN=N11,
SIZE=8,
$
TYPE=DATA,
COLUMN=N13,
SIZE=8,
$
TYPE=DATA,
COLUMN=N3,
SIZE=8,
$
TYPE=DATA,
COLUMN=N6,
SIZE=8,
$
TYPE=DATA,
COLUMN=N7,
SIZE=8,
$
TYPE=DATA,
COLUMN=N12,
SIZE=8,
$
TYPE=DATA,
COLUMN=N2,
SIZE=8,
$
TYPE=DATA,
COLUMN=N4,
SIZE=8,
$
TYPE=DATA,
COLUMN=N5,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N11,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N13,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N3,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N7,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N12,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N2,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N4,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=8,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=0.430556,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=0.555556,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=0.805556,
$
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=0.875000,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.805556,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=1.930556,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=1.250000,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=0.180556,
$
ENDSTYLE
END
 
Posts: 72 | Registered: April 03, 2006Report This Post
Virtuoso
posted Hide Post
Is there any reason you have a quote mark around your field names. If all you need are totals by the broker_city, do you need the detail lines? If not why not use sum.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Gold member
posted Hide Post
Forgive my ignorance. This is my first report. The data is coming from a sql stored procedure. I dragged and dropped the fields from the object inspector. I need to show the detail and then the total for the city, but only for the premium field. Have written reports in SQL report services and Crystal before. This is a paradigm shift for me. Any suggestion are greatly appreciated.
 
Posts: 72 | Registered: April 03, 2006Report This Post
Virtuoso
posted Hide Post
Here is a simple example using the CAR file:

TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST
BY COUNTRY
ON COUNTRY SUMMARIZE DEALER_COST
END

There are other ways to get customized subtotals as well. Good luck inyour new adventures with WebFOCUS.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Gold member
posted Hide Post
quote:
TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST
BY COUNTRY
ON COUNTRY SUMMARIZE DEALER_COST
END


Changed the code and still getting the error, below is the top portion of code.
SQL SQLMSS EX IRF_DE1.DBO.SmartCo 2004, '2006/02/10', 'AON';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SMART_HOLD FORMAT ALPHA
END
-RUN
-*TABLE FILE SMART_HOLD
-*END
TABLE FILE SMART_HOLD
PRINT
'SMART_CO.Ceding_Company_Name'
'SMART_CO.Contract_ID/A10'
'SMART_CO.MGA_Name'
'SMART_CO.Description_or_Insured/A50'
'SMART_CO.Contract_Class_Desc'
'SMART_CO.Contract_Effective_Date/HMDY'
'SMART_CO.Anniversary_Date/HMDY'
'SMART_CO.FRC_Premium/P17N'
'SMART_CO.FRC_Percent/D10.2'
'SMART_CO.Broker_Contact/A35'
'SMART_CO.Underwriter_Name/A35'
BY
'SMART_CO.Broker_City'
ON 'SMART_CO.Broker_City' SUMMARIZE 'SMART_CO.FRC_Premium'

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
 
Posts: 72 | Registered: April 03, 2006Report This Post
Virtuoso
posted Hide Post
Try removing the single quote marks around the actual field names.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Gold member
posted Hide Post
This works great. As soon as I comment out the ON it breaks and gives me an error.

SQL SQLMSS EX F_D1.DBO.SmartContract 2004, '2006/02/10', 'Baker';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SMART_CONTRACT_HOLD FORMAT ALPHA
END
-RUN
TABLE FILE SMART_CONTRACT_HOLD
PRINT SMART_CO.Ceding_Company_Name SMART_CO.FRC_Percent
SMART_CO.FRC_Premium

BY
SMART_CO.Broker_City
-*ON SMART_CO.Broker_City RECOMPUTE
-*ON SMART_CO.Broker_City SUBTOTAL

END

Any ideas????

This message has been edited. Last edited by: rc,
 
Posts: 72 | Registered: April 03, 2006Report This Post
Expert
posted Hide Post
Try using only one or the other - RECOMPUTE and SUBTOTAL - they do similar things:

SUBTOTAL subtotals the column at the specified Sort Break
RECOMPUTE Subtotls computed fields by rerunning the computed calculation for the subtotal (if that makes any sense!)


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
Solution found.
The field length of the BY field was coming back as 8000 long. Made a change in the sql stored procedure substring the field now it worked fine.

Thanks for the input.
 
Posts: 72 | Registered: April 03, 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     Error on trying to total on group/section Error

Copyright © 1996-2020 Information Builders