Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-05-23 : 12:55:53
|
| Hi all,My report has a number of tables.These table design is as [Total(numeric),Year(numeric),Month(varchar(15)].Each table on report is populated based on individual tables in Mngt Studio.My problem is.If table is empty,the table on report does not get populated/displayed.It is hidden.How do I return a message,Example {"No Value for table A"} instead and show the table in report only when the table has some value.I have written an expression like this.But it just hides the table if its empty,and im not able to return a value "No Value"instead.=IIF(Fields!Month.Value IS Nothing,"No Value for table A",False) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-23 : 13:20:54
|
| You set the hidden property of table as IIF(CountRows("YourDataset")>0,False,True)and add a new text box which just shows No value just above the table and set its hidden property as IIF(CountRows("YourDataset")>0,True,False) |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-23 : 13:44:47
|
| Thanks Visakh.I created and additional txt box.And toggled the table and text box with the same expression.This seemed to make it work. |
|
|
|
|
|
|
Hidden Expression for table