Report Visible Property

fermerius · May 14th, 2011, 08:03 AM

Hi!
I have a report, it contains fields Player and winnings. So each Player has a winning. And it looks like this:

Player_id - winnings
Jack - 50000
John - 25000
Ros - 45000
Joey - 31000

And I want to hide player_id field, for players whose winnings is less than 30000.
I've tried this:

Code:

If Reports!Player!winnings < 30000 Then Reports!Player!Player_ID.Visible = 0

As I understand it this condition can't be met because it operates with the whole column of values... and thus condition Reports![Player1]![winnings]<30000 is incorrect. It would work fine if you want to hide the whole Player_id column, but I need to hide just some of them.

Is there anyway I can do it ?

HiTechCoach · May 14th, 2011, 10:15 AM

I assume that Player_id - winnings is printing in the detail section.

Use the Detail section's on Format event like this:

Code:

If Me.winnings < 30000 Then 
  ' Turn if off it not needed
    Me.Player_ID.Visible = False

Else
 ' Turn it on if needed
    Me.Player_ID.Visible = True

End If

or this shorthand

Code:

 Me.Player_ID.Visible = (Me.winnings >= 30000)

The key is that you have to always set the visible property to on (true) or off (false) each time.

fermerius · May 14th, 2011, 01:46 PM

Thanks a lot, mate )

HiTechCoach · May 14th, 2011, 02:14 PM

You're welcome.

Cheers.