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.
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'
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, 2004
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.
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, $
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!)
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
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.