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 |
|
nana_81
Starting Member
9 Posts |
 Posted - 2005-01-18 : 04:25:55
|
| I have detail group to show bunch of rows and I want to show or hide some rows if rows is empty so hide otherwise show how can i do this using IIF or any other way |
|
|
mde
Starting Member
10 Posts |
Posted - 2005-01-18 : 04:56:22
|
| Have you tried something like this?Open up the dialog-box "details grouping" and go to the Visibilty tab, select Initial visibility -> Expression and write something like this:=iif(Fields!Typ.Value is nothing, true, false)// Maria |
 |
|
|
nana_81
Starting Member
9 Posts |
Posted - 2005-01-18 : 05:12:17
|
| what is Fields!Typ.Value it gave me an error |
|
|
|
nana_81
Starting Member
9 Posts |
Posted - 2005-01-18 : 05:17:19
|
| this is the errorThe hidden expression for the table ‘table1’ refers to the field ‘Type’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. |
|
|
|
mde
Starting Member
10 Posts |
Posted - 2005-01-18 : 05:29:02
|
| Sorry, Fields!Typ.Value is one of the fields I use in my table, change that to one of the fields in you table that can be empty and trigger the hide-function.// Maria |
|
|
|
nana_81
Starting Member
9 Posts |
Posted - 2005-01-18 : 05:47:44
|
| i've tried it but Unfortunately no action maybe i miss something |
|
|
|
mde
Starting Member
10 Posts |
Posted - 2005-01-18 : 06:36:04
|
| Maybe you have to test for something else than "nothing", like ' ' or system.dbnull.value?// Maria |
|
|
|
nana_81
Starting Member
9 Posts |
Posted - 2005-01-18 : 07:01:39
|
| i've tried everything but still |
|
|
|
|
|
|
show/hide detail group