Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error parsing report
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Error parsing report
 Login/Join
 
Member
posted
I have built a FOCUS temporary table by appending multiple reports using App Studio 8.2.01M. When I create a final report from this temporary table, I need to suppress zero values in aggregated columns. I'm trying to both suppress and include commas in my total values. This works until I attempt to open my procedure after saving. This generates an Error parsing report req... window with >/< TOTAL/I7CS displayed. I've tried to find my answer in FPF, but unable to do so. Can a number be formatted with both commas and zero suppression?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 26 | Location: Oklahoma City | Registered: January 27, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Can you share a simplified example? I7CS shouldn't be a problem.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
By ""suppress" do you mean "eliminate" or don't show/use those values in your display or in your calculations? the "I7CS" is only for formatting the result.
 
Posts: 3124 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
At top of fex:
SET NODATA = ''
then redefine the column.
Example:
D_YOUR_COLUMN_NAME/I7C MISSING ON = IF YOUR_COLUMN_TEST IS MISSING THEN MISSING ELSE YOUR_COLUMN_TEST;
OR
D_YOUR_COLUMN_NAME/I7C MISSING ON = IF YOUR_COLUMN_TEST EQ 0 THEN MISSING ELSE YOUR_COLUMN_TEST;

hth


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1973 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Sorry to just get back with this. Thank you all for your advice given. Before sending code to you, I decided to follow Mr. Flynn's example. Worked great! Thank you everyone!!!


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 26 | Location: Oklahoma City | Registered: January 27, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error parsing report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.