Hide/Show
I would like to show a table once the data is avaibale for that table and hide it in case nothing returned from the query!
hussain
November 14th, 2010 8:18am
Cannot test it right now, but is it possible to have a parameter that indicates does the query retrun something?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2010 8:57am
Do Follwoing
Take any Key attribute in you report which can not be null unless your data set is emty or say no result.
Than
In table property, select Hidden property and use Following expression
=IIF( Count(Fields!YourKeyAttribute.Value) =0, TRUE,FALSE)Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
November 14th, 2010 2:11pm
Do Follwoing
Take any Key attribute in you report which can not be null unless your data set is emty or say no result.
Than
In table property, select Hidden property and use Following expression
=IIF( Count(Fields!YourKeyAttribute.Value) =0, TRUE,FALSE)Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2010 2:11pm
how i can identify which dataset??hussain
November 15th, 2010 4:47am
Hi Hussain,
As Gaurav Gupta posted, we can use an expression in the
Hidden property in order to hide the table when no data returns.
By generally, if we add data fields to the table, the
DataSetName property of the table will be filled to the dataset name which contains these fields automatically. After that, if we specify an expression in the
Hidden property like
=IIF( Count(Fields!YourKeyAttribute.Value) =0, TRUE,FALSE)
The Count function will use the dataset as a scope to calculate the count by default, so there is no need to specify a dataset in the expression.
If I have misunderstood, please point out.
Thanks,
Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2010 10:02pm