SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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. 

  1. Right-click the tablix and select Properties. 
  2. Click Visibility.

Read more

6 comments, 1,521 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, 825 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 (Twitterbio Read more

0 comments, 679 reads

Posted in SQL Awesomesauce on 12 January 2012