Select the column in the report designer, then set the Hidden property under Visibility in the Properties window to an expression. Set that expression to contain the logic you desire.
Hope that helps,
-Lukasz
Select the column in the report designer, then set the Hidden property under Visibility in the Properties window to an expression. Set that expression to contain the logic you desire.
Hope that helps,
-Lukasz
sql
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