BrianKMcDonald's BI Developer Network Community articles

briankmcdonald Articles

• • Email
  
  Group Level Page Numbering using Reporting Services 2008 R2
  In this article, Brian will show you how to include group level page numbering along with total report page numbering. This comes in handy when you have a large report with sets of grouped data.
  tags : Reporting Services, SSRS, Page Numbering, Group Page Numbering, ResetPageNumber, Brian K McDonald
  briankmcdonald   -  3/8/2011   -  Comments: 5  -  Views: 2711
• • Email
  
  Where Are My Records: Using the NoRowsMessage Property
  In this article, Brian will show you how to use the No Rows property group of data regions to inform the user that no records met their criteria.
  tags : SSRS, NoRowsMessage, No Results For Data Region, Brian K. McDonald
  briankmcdonald   -  10/22/2010   -  Comments: 13  -  Views: 3421
• • Email
  
  User Preferences and Styling
  In this article, Brian will show you how to create themes and use them withing SQL Server Reporting Services. These examples were created in SSRS 2005, but could easily be used in 2008 and R2 as well.
  tags : SSRS, Themes
  briankmcdonald   -  10/6/2010   -  Comments: 10  -  Views: 2035
• • Email
  
  Remove Duplicates from Tablix by Grouping
  In this article, Brian will show you one way that you can get a distinct listing of values in a Tablix. Although it is rare to have to use this method, I have had to resort to this to solve a unique problem.
  tags : SSRS, Remove Duplicates, Groups
  briankmcdonald   -  9/29/2010   -  Comments: 7  -  Views: 3870
• • Email
  Loading Parameter Values – Hard Way vs Easy Way
  In this article, Brian is going to show you how you can either choose the hard way and manually load a parameter list with many options or just write a script that loops through and creates the results for you.
  tags : Loading Parameter Values, SSRS
  briankmcdonald   -  7/29/2010   -  Comments: 5  -  Views: 2192
• • Email
  
  Edit/Select Top N Rows in SQL Server Management Studio
  In this article, Brian will show you how to quickly modify the default settings of SQL Server Management Studio (SSMS) to enable editing of more than top 200 rows. He will also show you how you can set the results to return more than the default 1000 rows...
  tags : SQL Server Management Studio, Edit top , Select Top
  briankmcdonald   -  7/29/2010   -  Comments: 0  -  Views: 2514
• • Email
  
  Creating a Hierarchy Using SSAS 2008
  In this article, Brian is going to walk you through the steps to create a date hierarchy in SQL Server Analysis Services 2008.
  tags : Hierarchies using SSAS 2008
  briankmcdonald   -  7/22/2010   -  Comments: 0  -  Views: 2848
• • Email
  
  Creating a New System Role in SSRS
  In this article, Brian will show you how to create a new system role that can be used to give permissions to see the report builder button when using the Report Manager application.
  tags : SSRS, System Roles, Report Builder Access
  briankmcdonald   -  7/16/2010   -  Comments: 0  -  Views: 2342
• • Email
  
  Using SSIS and WinRAR to Zip Files in a Folder
  In this article, Brian will walk you through step by step instructions on how to create a package that will utilize the SSIS Execute Process Task to run WinRAR in order to zip up the files in a folder.
  tags : SSIS, Execute Process Task, WinRAR, Zip Files
  briankmcdonald   -  6/17/2010   -  Comments: 11  -  Views: 3594
• • Email
  
  Reporting Services Parameters Not Updating
  In this article, Brian will show you how to map report parameters after modifying stored procedures that didn't have any (or after adding) parameters.
  tags : Reporting Services, Parameters Not Mapping
  briankmcdonald   -  6/13/2010   -  Comments: 0  -  Views: 2517
• • Email
  
  Report Services 2008 R2 - Data Bar
  In this article, you will learn how use the new data bar control in SQL Server Reporting Services 2008 R2 just released a few short weeks ago.
  tags : Reporting Services 2008 R2, SSRS, Data Bar
  briankmcdonald   -  5/26/2010   -  Comments: 2  -  Views: 3945
• • Email
  
  SSRS Parameters and Their Labels
  In this article, I will quickly show you an example of how to use the Label property of the Parameters collection.
  tags : Reporting Services, SSRS, Parameters, Parameter Labels
  briankmcdonald   -  5/17/2010   -  Comments: 5  -  Views: 2321
• • Email
  
  Local SQL Server Logins
  In this article, I explain how to troubleshoot permissioning issues when you create SQL Server Logins and are unable to log into the SQL Server instance.
  tags : SQL Server Logins, Security
  briankmcdonald   -  5/4/2010   -  Comments: 0  -  Views: 789