I learned this from one of my co-workers. A quick tip for formatting SSRS reports. When you are in the SSRS report editor, and you want to move the currently selected object (or objects), you can move them with the arrow keys. Most people who have used SSRS know that one, but did you know that if you use the …
This is very useful if you are creating many reports based on a single template. To start with when you use the “Add new Item” functionality into a report project, this is all you get. Report Wizard, Report, and Data Source. Then searching Online Templates is not very useful. So how do I add my own SSRS rdl templates. Steps: …
This last week I had the opportunity to do some work with SSRS, determining some stats on report usage. I ended up digging up some queries that I wrote a couple years ago against the ReportServer database, and thought they would be worthwhile to share, so here they are. These have been tested against SQL Server 2008, and 2008R2 databases. …
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are a few of the twitter hash tags that I follow: #SQLServer The generic SQL Server hash tag. Most anything goes on this hash tag. #SQLHelp The #SQLHelp hash tag is great when you need to …
What twitter hash tags do you follow for SQL Server? Read more »
One of the common questions that I get asked after my Unleashing CTE Presentation is “Can we use CTEs in SSRS reports?” The answer is YES, Common Table Expressions work great in SSRS reports, one of my favorite ways of cleaning up some of those big ugly SSRS report queries is to use CTEs.
There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2012, instead it has been replaced with the SQL Server Data Tools that uses the core of Visual Studio 2010, with the Report Builder and Report Designer built in to the new Visual Studio. The UI has changed colors, and looks a bit sharper, but overall you have …
No more Business Intelligence Development Studio in SQL 2012 Read more »
As I have been working on my SQL Server Health Reports for my presentation at SQL Saturday 114 in Vancouver on March 17th, I have changed the way that I do things several times. After attending a SSRS class “SSRS Beyond the Basics ” at SQL Saturday 108 in Redmond presented by @sqlbelle I learned a few tricks to help make this happen. …
I learned this from one of my co-workers. A quick tip for formatting SSRS reports. When you are in the SSRS report editor, and you want to move the currently selected object (or objects), you can move them with the arrow keys. Most people who have used SSRS know that one, but did you know that if you use the …
This is very useful if you are creating many reports based on a single template. To start with when you use the “Add new Item” functionality into a report project, this is all you get. Report Wizard, Report, and Data Source. Then searching Online Templates is not very useful. So how do I add my own SSRS rdl templates. …