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

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.

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.

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.

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

Try removing the single quote marks around the actual field names.

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,

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!)

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.