is it possible to do this

is it possible to give this expression in 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

It seems you are trying to set some property that expects a boolean value (eitherTrue orFalse)

"Data Not Available" is a string and cannot be converted to a boolean value.

If you can post details of what you are trying to do, someone should be able to help you.

|||

Prashant thanks for your answer.

I have a line graph which is been populated by a stored procedure.. and the client wants no graph to appear if there just one value.. This is my sproc..

ALTER Procedure [dbo].[rpt_Growthof10K]@.Cusipvarchar(9)AS--==============================================================================-- Return the appropriate data.--==============================================================================SELECT Cusip, ChartHeader, GrowthDates, GrowthNAVFROMGrowthof10KWHERECusip = @.Cusip

IF there is just one record returned by the sproc the graph will plot.. but i would just end up getting the x axis and the y axis and they not enough data to be plotted so instead of showing that i want to show text message saying that "Data not avialable.

I also tried giving this expression =IIf(CountRows("Growth") = 1, True, false) so its displays nothing if it evaluates to True and if the expression is false it shows the Graph...

So i just wanted it to look a bit user friendly by displaying the message instead of the user calling up and saying i cannot see the graph..

any help will be appreciated

Regards

Karen

|||

Never mind. I solved it.

For the graph i set the visible property to true if countrows("growth") = 1

and then before the graph i put a text box and i gave this expression in it ...

=IIf(CountRows("Growth") = 1,"Data Not Avialable","")

Regards

Karen