Hide the values of a column in report

3174977

Hi All,

I have a report with three columns as Project name, Actual hours & Plan hours. my requirement is I don't want to show the projects where actual and plan hours both are equal to zero. How to achieve this ..

Thanks !

choracy69

Hi,

If you don't show project with actual hours and plan hours equal to zero, you must create something likt that in filter:

Principle of operation: NOT ( A and == (NOT A) or (NOT

Or add this two filters with sql:

(Actual Hours <> 0 OR  Plan Hours <> 0)

3174977

Hi,

That's how I am not able to understand how to put that in filter. when I am giving like this it's throwing me error.

choracy69

Hi,

You past this code in wrong place.

When you click PPM on for exmaple Actual Hours Column and choose Filter, when next you must click Convert this filter to sql and click OK.

And it opens a new windows: Advanced SQL filter and there past code.

And end view:

If I helped, then give the correct answer.

3174977

Thank you. It woked..

Thanks !