Hide a row based on criteria (1 Viewer)

[deanvilar]

Help Guys ....

I need to hide a row in my report for example (in Detail Format event of the report):

If me.txtReleased = "YES" then
hide row
endif

thanks in advance.

 

[CJ_London]

I would modify your source query to exclude records where txtReleased = "YES"

 

[deanvilar]

I did ... but the problem is that the query comes first to display the data and it cant fetch the value YES or NO generated from detail format event of the report.

 

[deanvilar]

I found it!!!!
if me.released = "YES" then
Cancel = True
end if

 

[CJ_London]

Excellent - you could rewrite as

Cancel=me.released = "YES"