Last post Jul 18, 2011 09:16 AM by Steelymar
Jul 18, 2011 08:36 AM|MyronCope|LINK
using report builder 2.0
I have a textbox on my report and I would like to hide the textbox when no records are returned by the report query.
I tried the syntax at the bottom but got the "expression expected" error.
I want to do one of the following to determine if records are returned to hide textbox
1. do a record count on number records returned (how to do this?) OR
2. check a column to see if a value is returned.
what I have now that is giving me the "expression expected" error is:
=Not(Fields!MyColumn.Value <> '' )
Jul 18, 2011 09:16 AM|Steelymar|LINK
=iif( First(Fields!MyColumn.Value) is nothing,true,false)