Hi All,

I am working on WF Dev Studio and displaying the data in InfoAssist... am trying to hide the values that has zero or blank numbers... tried many ways but ... i think am missing some step. I would really appreciate any help.
thanks
pats.

This message has been edited. Last edited by: <Kathryn Henning>,

Are you trying to hide rows or columns ?

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

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.

WHERE Sales NE 0;

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

thanks!

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

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.

Is this in Excel output?

Try this:

ON TABLE SET NODATA ''
ON TABLE SET EMPTYCELLS OFF

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.