[CLOSED] Hide Blank or Zeros Values

Are you trying to hide rows or columns ?

Please provide a sample with car file or your own code.

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Member

posted

Thanks for your reply.

Am having a report that has:

Date Market Sales
Apr-1 USA 100
Apr-2 UK 0
Apr-2 USA 200
Apr-3 UK 100
Apr-3 USA 0

What I don't like to see is the Sale that has 0 value... I can change that 0 in the Dev Studio to show as empty, but still will have the row, with no data, no 0. it will be like
Apr-3 USA
the record still is in the report with no data.
So, would like to find a way to hide the 0 or the empty metrics.

thanks, hope is clear.
Pats.

WebFOCUS 7.6
Windows, All Outputs

Posts: 15 | Registered: February 11, 2014

Ignored post by Pats posted

Wep5622

Virtuoso

posted

WHERE Sales NE 0;

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :

Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010

Ignored post by Wep5622 posted

Member

posted

thanks...
Yup, But can I have that inside the Dev Studio ? or should be only added directly in InfoAssist, report designer ?

thanks!

WebFOCUS 7.6
Windows, All Outputs

Posts: 15 | Registered: February 11, 2014

Ignored post by Pats posted

diogopc

Gold member

posted

You can leave it either in the Dev Studio or add it in InfoAssist, whichever is easier for you to edit later I guess.

WebFOCUS App Studio 8103
Windows7
All outputs

Posts: 58 | Location: London, UK | Registered: May 09, 2011

Ignored post by diogopc posted

Member

posted

thanks for your reply.
I am working with Report Painter at this moment, I changed what I was doing before...
Now the data is showing a DOT, the missing default value, I can change to Blank or NA etc... but what i would like to do, is to totally hide it... I am having more than one Metric in the view, so, if its just one metric is easy, but having 2 metrics, but a dimensions across and 2 dims in rows...
is there a way to not show any Missing data ?
I have the where clause saying :

WHERE (Sales IS-NOT MISSING OR COST IS-NOT MISSING ) , but still, if one of this has data, it will show the missing for the other col, like:
Jan01 Jan02
Market Process Sales Cost Sales Cost
USA PP . 100 2 50
UK JJ . 100 3 40

it is not hiding when Missing is there..

thanks,
Any comment , solution would be more than appreciate!
Also, I have used the ON TABLE SET HIDENULLACRS ON, but nothing is doing on it.

WebFOCUS 7.6
Windows, All Outputs

Posts: 15 | Registered: February 11, 2014

Ignored post by Pats posted

Anatess

Guru

posted

Is this in Excel output?

Try this:

ON TABLE SET NODATA ''
ON TABLE SET EMPTYCELLS OFF

WF 8.1.05 Windows

Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006

Ignored post by Anatess posted

Member

posted

Anatess, thanks for your reply ... it is similar post as the other one with my name...
am trying to find 2 diffs way for the solution. one is to Hide entire things and if cant be done., second is to reduce the height of the cells, rows, or cols ... anything possible.

It is not an excel output, is just a report.

thanks.

WebFOCUS 7.6
Windows, All Outputs

Posts: 15 | Registered: February 11, 2014

Ignored post by Pats posted