 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point is there a way to mass suppress zero with on table?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point is there a way to mass suppress zero with on table? Read-Only TopicGo | Search | Notify | Tools |
| is there a way to mass suppress zero with on table? | Login/Join |
| Platinum Member |
Hi There I have a report with a ton of fields and I need to add an option for the user to suppress zero or not. Sometimes they want to see zeros and sometimes they want to see blanks. It is a runtime choice. Is there an on table setting for that that I am not aware of? Or do I need to use an amper for every single field one by one.. like COMPUTE X/I6&sup where &sup is "S" or "". Obviously this will work.. but I am looking for a faster way. Note that I am talking about actual 0 values. I cannot use on table set nodata. There is data and the actual value is 0. Also, for reasons that I won't get into, I cannot simply use a different master file depending on the user's choice. Thanks! WF 8.0.0.5M | ||
|
| Virtuoso |
I think you've already come up with the only answer. The format of each fo the fields needs to be treated individually, so there isn't a way to change them all-at-once to a zero-suppress. Your &var on the format for each field is probably the only way to go. Sorry for the bad news, but I do like your idea. Hadn't thought of using the &var for modifying formats based on user preference. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Platinum Member |
Hi Darin That is what I was afraid of. It will work, but there are around 750 possible fields that I will need to add that to. :-( Thanks. WF 8.0.0.5M | |||
|
| Virtuoso |
You could set &vars to be the actual fieldnames and include a Dialogue Manager loop to create all those COMPUTEs. This would save on code and not have to manually change anything except the &vars. Just an idea.. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Master |
You should be able to change the print format in your report without having to compute a new field by stating the format after the field. This will not work on a BY field. TABLE FILE CAR SUM DEALER_COST/D12.2S END Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Virtuoso |
It can be done.... -DEFAULT &ZERO='N'; -SET &Z1=IF &ZERO EQ 'Y' THEN 'S' ELSE ''; DEFINE FILE XXX FMAT1/A8='D12.2&Z1'; FMAT2/A8='D15.1&Z1'; ... and some others you need in the report END TABLE FILE CAR SUM SALES/FMAT1 SALES/FMAT2 BY COUNTRY ACROSS MODEL END I'm not sure if table has zero values....
| |||||||
|
| Platinum Member |
Hi Frank. That is exactly what I did. But I had to do it for approx 750 differenct fields. I was wondering if there was a one line command I could use to alter every one all at once. Sort of like "on table supress all zeros". I have this in the end... -SET &XXX=IF (bunch of conditions here) THEN 'MYFIELDNAME/P12&SUP_ZERO.EVAL' ELSE ''; where &SUP_ZERO is 'S' or ''. Thx. JodyeThis message has been edited. Last edited by: jodye, WF 8.0.0.5M | |||
|
| Virtuoso |
You have 750 different fields, but the format won't be that much diffences I think. You can do a find and replace on all your fields that has a format type like "/D". If you have 10 different types it could be done within 5 min.
| |||||||
|
| Expert |
Jodye, You could let WF take the strain for you although it could be overkill. Just perform a CHECK FILE with the HOLD option and then parse the fields and formats - -SET &DUMMY = &SupZero.(<Suppress Zeroes,S>,<Leading Zeroes, >).Zero Choice.; CHECK FILE CAR HOLD TABLE FILE HOLD PRINT FORMAT BY FIELDNAME WHERE SEGNO EQ 5 ON TABLE SAVE END -RUN TABLE FILE CAR SUM -READ SAVE &Fieldname.A66 &Format.A8 -REPEAT :Loop WHILE &IORETURN EQ 0; -SET &Printfield = IF &Format LIKE 'D%' THEN TRUNCATE(&Fieldname)||'/'||TRUNCATE(&Format)||&SupZero - ELSE TRUNCATE(&Fieldname)||'/'||&Format; &Printfield -READ SAVE &Fieldname.A66 &Format.A8 -:Loop BY COUNTRY BY CAR BY MODEL ON TABLE SET HTMLCSS ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * GRID=OFF, SIZE=9, $ ENDSTYLE END T
| |||||||||
|
| Master |
You may be able to do it in your stylesheet. This really doesn't suppress the zero, it just keeps it from showing up. The original -SET for &N is the first column that may contain zero. The COLOR should be your background color. It will work with HTML, PDF or EXL2K, but not with EXCEL (97). -SET &N=1 -REPEAT DATALOOP 750 TIMES TYPE=DATA, COLUMN=C&N, COLOR=WHITE, WHEN=C&N EQ 0, $ -SET &N=&N+1; -DATALOOP -ENDREPEAT Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Platinum Member |
Pat, However, if the report is printed, then the 0s will appear, which might not be desirable. And online, this acts like invisible ink. The user could highlight the white text (click and drag), and the 0s will appear. Sean ------------------------------------------------------------------------ PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode | |||
|
| Master |
Was this not clear? Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Platinum Member |
Thanks for the excellent replies everyone! Frank: Took more like 6 mins. :-). I was going to do that all along, was just wondering whether there was an on table command. Tony: Excellent idea. But you are right.. a bit overkill. Pat: Nice idea.. but I needed the fields to be truly empty. Not just look empty. In case people are wondering, the rationale behind this request is that some of our users want to see zeros in excel and some do not. The zero, obviously, has a huge effect on averages. Sometimes it is important to factor in the zero and sometimes it should be treated as an empty cell. Thanks again everyone. WF 8.0.0.5M | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point is there a way to mass suppress zero with on table?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point is there a way to mass suppress zero with on table?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 |