 |
|||||
|
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
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. | |||||
Go  | Search | Tools |
| [CLOSED] getting the column total in the next line,want in same line... (in WebFOCUS/FOCUS Forum on Focal Point ) by kiran Hi all,when i am generating a sample report in pdf format,and when i use on table column-total to get the report total,the total clause is coming in one line and the actual totals(calculations)are coming in the next(below) line.i want the totals next to the 'TOTAL' clause eg:i am getting in the... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Issue with Displaying the "Total" (in WebFOCUS/FOCUS Forum on Focal Point ) by Gobinath Velusamyan issue with displaying the TOTAL.If you see,"TOTAL" is being displayed in the first line followed by the DATA in the next line.We want the "TOTAL" and DATA in the sameline.ANy suggestions ... Hi*********************************************December . 19803028233.41 December 9978554.15 Total... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
grand total on one line (in WebFOCUS/FOCUS Forum on Focal Point ) by mgrackin,$ENDSTYLEENDAlso,ON TABLE COLUMN-TOTAL AS ''will keep the number on one line but you will not have the word "Total" appearing on the line. ... Pam,Here's a simplier example.TABLE FILE CARPRINT COUNTRYBODYTYPESALESON TABLE SUBFOOT"TOTAL+0 TOT... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Why does the total on a by show one row below (in WebFOCUS/FOCUS Forum on Focal Point ) by LeahUsually I've seen that happen when the value of the by field is longer when the *TOTAL ..... is generated, so FOCUS puts the totals on another line to line up with the columns.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Why does the total on a by show one row below (in WebFOCUS/FOCUS Forum on Focal Point ) by mgrackinIf you are hiding (NOPRINT) the BY fields then the "TOTAL" will appear on a seperate line for ANY output format.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point Report caster subject line (in WebFOCUS/FOCUS Forum on Focal Point ) by DaveZWhen a report is delivered to a user via email is there any way to put a column(s) total on the subject line.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] How to skip a line between two RECOMPUTE lines? (in WebFOCUS/FOCUS Forum on Focal Point ) by JohnBI tried these 2 techniques and subfoot, but they do not put a blank line between the last subtotal line and the grand total line.Any other suggestions?... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] How do you get a total to print on one line? (in WebFOCUS/FOCUS Forum on Focal Point ) by JohnKI would like to print a simple column-total on one line. I do not have any sort fields. When I attempt to do this, the phrase 'TOTAL' prints on one line, and the total amounts on the second line ... that prints on two lines. TABLE FILE CAR PRINT MODEL SALES ON TABLE COLUMN-TOTAL AS 'TOTAL' ON TABLE... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] COLUMN-TOTAL line wraps onto 2 lines in PDF, but not in HTML or Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by JBKnumeric column being totaled. The first column is an A12 field. To total the numeric column, the sysntax, ON TABLE COLUMN-TOTAL AS 'TOTAL' is used.The problem is in PDF this grand total line is wrapping onto 2 lines: The word TOTAL is one one line and the numeric value is on the line below it. This... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
a different report format (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony AApart from the [ code] tags you used, no lines and the fact that you've missed off the total line?T... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Creating a blank column for 'total' heading on subfoot (in WebFOCUS/FOCUS Forum on Focal Point ) by rsYou need to use a BY clause to sort the report and use the Total it should come on the same line... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Help with recompute (in WebFOCUS/FOCUS Forum on Focal Point ) by GamPThere are many posts on this subject in the forum. Search for 'total one line' and you'll find a number of posts with possible solutions to this problem.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
summarize and .TOT (in WebFOCUS/FOCUS Forum on Focal Point ) by Rafael.AZDan thank you this kinda does what I want except that this will cause the 2 line on total issue... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] RECOMPUTE and SKIP-LINE (in WebFOCUS/FOCUS Forum on Focal Point ) by MattCSorry if I am not clear. I am looking to add a blank line between the last row and the total.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point Hide lines from a report (in WebFOCUS/FOCUS Forum on Focal Point ) by AbdessHi, it's possible to hide lines on the report and keep only the total line ??Thanks in advance... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Help a newbie out (in WebFOCUS/FOCUS Forum on Focal Point ) by Big GuyYes, that was my typographical error. I do get a line that says Total and nothing else.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED] subfoot and total lines is not aligned and extra space in PDF report (in WebFOCUS/FOCUS Forum on Focal Point ) by mgrackinplacing values on a TOTAL line. If there isn't enough room on the same line for the value of the field for which the TOTALS are being calculated and the total values themselves, FOCUS will use two lines for ... lines, not force the TOTAL line to always appear on one line.... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] How to only print column total line (in WebFOCUS/FOCUS Forum on Focal Point ) by JveselkaHow do I code this so that only the Grand Total Line prints? I don't want to see the headings or data, only Grand Total line. TABLE FILE CAR SUM DCOST RCOST BY COUNTRY ON TABLE SET PAGE-NUM ... 2Report 3 I need to be the one line Grand total which is the total of LOB1 and LOB2This seems like is... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Adding an average line after grand totals (in WebFOCUS/FOCUS Forum on Focal Point ) by JJWhen I add an average line after grand total, it drops off grand total line. Can someone help me to add average line right below grand total line? I want to have RECOMPUTE by sort break and then grand total and average.SET SUMMARYLINES=EXPLICIT TABLE FILE MOVIESPRINT COPIES LISTPR WHOLESALEPR... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Calculate group total and use in detail report (in WebFOCUS/FOCUS Forum on Focal Point ) by HCallI need to calculate the total for a group, and have it show on the detail line and use it in some calculations for the detail line.TABLE FILE ACCTTRANSACTIONPRINT ATSELLAMT/P12.2M AS 'SELL AMT'BY ... detail line, and then use that to determine a rebate percent based on total purchases for the store.How... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point | » Refine Search » New Search |
| Powered by Social Strata | Page 1 2 3 4 5 ... 58 |
 | Please Wait. Your request is being processed... |
Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |