×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to hide report row

How to hide report row

How to hide report row

(OP)
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

RE: How to hide report row

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.

RE: How to hide report row

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

RE: How to hide report row

(OP)
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

RE: How to hide report row

Great thanks just what I wanted.

RE: How to hide report row

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...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close