is it possible to do this

is it possible to do give this expression is the visiiblity property

=IIF((CountRows("Growth")) = 1, "Data not Available",False)

If the CountRows("Growth") is greater than 1 the graph shows up as needed. But suppose if CountRows = 1 i want data not available to show up in the report

How can i do it

i tried converting it to Cbool("Data not available") but i get an error message

Any help will be appreciated.

Regards

Karen

There is no way you can convert the string "Data not Available" to a boolean. Instead, put that string into a textbox and place it behind the graph, so it shows if the graph is not visible. Or just set the visibility of the textbox to the opposite of the visibility of the graph. Or are you attempting to get the string to show up on an empty graph?

|||

Thanks Sluggy,

thats what i did tooo..

Regards,

Karen