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 |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2007-10-19 : 07:16:03
|
| hi, i have a table that returns all rows. But i need to hide the rows having the "Order"= false.But i don't wanna do it by querying in the dataset, i just wanna hide these rows."Order" is a column in my table. Does anyone know how this can be done?Thank you |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-19 : 08:28:19
|
| You could create a VIEW on the table which excluded the "Order"= false onesIf you don't want to chance any existing queries you could:Rename the TableCreate the View, as above, referencing the new table but give the View the name of the original tableKristen |
 |
|
|
Will H
Yak Posting Veteran
56 Posts |
Posted - 2007-10-19 : 14:45:16
|
| If you are trying not to modify the query directly, You can always filter data from the dataset itself in whatever component you are using. For example, say you are using a matrix. Right click on the matrix, go to properties, Filters Tab. Add in whatever fields and values you don't want to see. Toggling visibility may also work. I use the =iif function to do this frequently, say:visibility=iif(Fields!Orders.Value = true, true, false)However depending on the component this may turn out a little wonky.---------------------------------------------------------SSRS Kills Kittens. |
|
|
|
|
|
|
hide rows in a table