Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to hide report row 1

Status
Not open for further replies.

MKhanA

IS-IT--Management
Jul 24, 2003
4
US
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

 
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.
 
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
 
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
 
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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top