Category Archives: SSRS

SSRS Tip: Hide a tablix if no rows returned

Posted on January 19, 2012 by Jen McCown

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 … Continue reading →

Posted in sqlserverpedia-syndication, SSC, SSRS, Tips | 2 Comments

Little Workaround in Report Manager

Posted on September 9, 2011 by Jen McCown

I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report), and from there clicking a link to generate and export a subreport (say, Individual Widget Report). The problem with this … Continue reading →

Posted in Random helpfulness, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips | 1 Comment

I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

Posted on September 8, 2011 by Jen McCown

Edit: See end of blog for solution. I have MS Visual Studio 2008 (BIDS) x86 with SP1.  Recently it’s started shutting down without warning whenever I hit “preview” on a SSRS report. Google hasn’t helped, and I didn’t get much … Continue reading →

Posted in sql server, sqlserverpedia-syndication, SSC, SSRS | Tagged | 3 Comments