How to hide report row 1

[MKhanA]

I have a report coulmn named %Complete on my report. I want to hide complete row if %Complete=100.
How do I do that?
Thanks

 

[gdwood]

If everthing you want to hide is contained in a frame then override the buildfromrow method of the frame and set the size.height = 0 when the value is 100.

 

[mjross]

Hi,

Is there any chance you could post an example of the code to do this? I'm new to coding Actuate and struggling with this.

My situation is I have two columns and if the value of both are 0 I want to hide the row.

Thanks

 

[MKhanA]

In frame properties, click Methods tab and select BuildFromRow function by double clicking on functions name. You will see following Built-in function:

Function BuildFromRow( row As AcDataRow ) As AcBuildStatus
BuildFromRow = Super::BuildFromRow( row )
' Insert your code here
If (Col1=0 and Col2=0) Then
size.height = 0
End If
End Function

 

[mjross]

Great thanks just what I wanted.

 

[wannalrn]

This response is kind of late!

why not set the condition in sql;
%complete !=100
unless you want to fetch that row for some reason, and not display it for some other reason...