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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics