Category: SSRS

SSRS Tip: Hide a tablix if no rows returned

Post author By Jen McCown
Post date January 19, 2012
Categories In sqlserverpedia-syndication, SSC, SSRS, Tips
7 Comments on 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. Select Show or hide based […]

Little Workaround in Report Manager

Post author By Jen McCown
Post date September 9, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on Little Workaround in Report Manager

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 is that it wipes out initial report and its parameters…so every single time, I had […]

I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

Post author By Jen McCown
Post date September 8, 2011
Categories In sql server, sqlserverpedia-syndication, SSC, SSRS
5 Comments on I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

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 love on #sqlhelp (the Twitter hashtag for SQL help), so I thought I’d ask my […]