Subscribe to this blog
Archives: January 2012
SSRS Tip: Hide a tablix if no rows returned
I have a tablix in an SSRS report, populated by a query that might or might not return any rows. What I want to do is make that tablix invisible if there are no rows returned.
First off, to set conditional visibility.
- Right-click the tablix and select Properties.
- Click Visibility.
6 comments, 478 reads
Posted in SQL Awesomesauce on 19 January 2012
Answer the Question Asked
“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get an answer to a question like this on the first try. Why? The simple answer is that people don’t hear the question you ask. People hear a question through… Read more
4 comments, 449 reads
Posted in SQL Awesomesauce on 13 January 2012
DBAs@Midnight 6 week roundup
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us from publishing 8+ new hours of shows and interviews! For your consideration:
We LOVE Mark
10/13/2011. PASS Special: We make sure we talk to Mark Souza (Twitter, bio Read more
0 comments, 325 reads
Posted in SQL Awesomesauce on 12 January 2012