Tag: Reporting Services

Hide and Group Columns in SSRS Using a Parameter

  By , , ,

Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like have multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I’ve embedded some links to MSDN to help you along the way. Current Report The report gives summarized counts by invoice date.  It currently has… Continue Reading

SSRS Report Won’t Render in VS Preview

  By

I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying. Last week, I was lucky enough to get a new one and spent two days getting it setup just right. At least so I thought…. once I started working on it of course, BAM I hit my first road block. Visual Studio using SQL Server Data Tool will not render any reports in the Preview tab. Let the trouble shooting commence! Error Message? No help… gives me nothing useful Can I deploy report to SharePoint and View? (We use SSRS Integrated Mode)-… Continue Reading