16 Articles
found and displayed in this view.

• The Baker’s Dozen: 13 Power Tips for Using SQL Server Reporting Services 2008 R2
  
  Magazine/Issue: CoDe Magazine, 2011 Jul/Aug
  Release Date: Sunday, July 03, 2011
  Quick ID: 1108101
  With each new version of SQL Server Reporting Services, Microsoft continues to offer new functionality for reporting. SQL Server 2008 R2, released to manufacturing in mid-2010, represents Microsoft’s fourth major release of Reporting Services in the last 10 years. This fourth release focuses on map generation and various business intelligence/data visualization features. In this article, I’ll demonstrate 13 significant features in SSRS.
  
  
• Incorporating ASP.NET MVC and SQL Server Reporting Services, Part 2
  
  Magazine/Issue: CoDe Magazine, 2010 Nov/Dec
  Release Date: Friday, October 22, 2010
  Quick ID: 1011131
  In the last issue, I introduced you to the basics of incorporating SQL Server Reporting Services into your ASP.NET MVC applications. In this issue, I’ll finish the series by illustrating how we can transfer data between the ASP.NET MVC context and the SSRS report context. In addition, I will also cover deployment issues such as authentication.
  
  
• Incorporating ASP.NET MVC and SQL Server Reporting Services, Part 1
  
  Magazine/Issue: CoDe Magazine, 2010 Sep/Oct
  Release Date: Friday, August 20, 2010
  Quick ID: 1009061
  Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.
  
  
• SQL Server Reporting Services Hits its Stride
  
  Magazine/Issue: CoDe Magazine, 2009 Sep/Oct
  Release Date: Sunday, August 16, 2009
  Quick ID: 0909071
  We’ve all heard that version 3 of a Microsoft product is when that product really hits its stride.And while I’m not sure of the truth of that software urban legend, I do have to say that Microsoft, with the release of SQL Server 2008 Reporting Services (which happens to be its 3rd major version), has released a gem of a reporting solution that is sure to please users of prior versions and bring more converts into the Reporting Services fold. The newest version of SQL Server Reporting Services is faster, can handle larger reports, supports a wider variety of browsers, and is more flexible thanks to the new Tablix data region, support for rich text content, and Microsoft Word as an output format.
  
  
• MVP Corner: A Baker’s Dozen of Reflections
  
  Magazine/Issue: CoDe Magazine, 2008 Jul/Aug
  Release Date: Friday, June 06, 2008
  Quick ID: 0807021
  July August 2008 MVP Corner by Kevin S. Goff
  
  
• The Baker’s Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
  
  Magazine/Issue: CoDe Magazine, 2008 Jul/Aug
  Release Date: Friday, June 06, 2008
  Quick ID: 0807041
  A major software release either contains a substantial number of enhancements, or a small number of substantial enhancements.The last two releases of SQL Server remind me of the two types of Christmas: SQL 2005 was like receiving a large number of presents, and SQL Server 2008 is like receiving a smaller number of big gifts. Those of you who asked Santa for the ability to INSERT/UPDATE/DELETE in one SQL statement, or to specify multiple GROUP BY statements in a single SQL query, you will be very happy. If you wanted a hierarchical data type, you will be ecstatic. SQL Server 2008 also includes a new and completely re-written version of SQL Server Reporting Services (SSRS)-complete with a new interface, new charting features, and (get ready to applaud) no more reliance on Internet Information Services (IIS). So while the temperatures are getting warmer, it’s Christmas Day here at the Baker’s Dozen, and we’re about to unwrap thirteen major SQL Server/SSRS 2008 gifts from Microsoft.
  
  
• The Baker’s Dozen: 13 Tips for Building Database Web Applications Using ASP.NET 3.5, LINQ, and SQL Server 2005 Reporting Services
  
  Magazine/Issue: CoDe Magazine, 2008 May/Jun
  Release Date: Friday, April 18, 2008
  Quick ID: 0805071
  Are you moving a Windows desktop application to the browser, and sweating bullets, or perhaps just not quite sure about how all the new Web and data tools work together?With each passing year, Microsoft offers newer and more powerful tools for building rich database applications on the Web. So many and so frequently, in fact, that it can be hard to keep up with the new tools and still meet the requirements of your job! This article will show you how to get the most out of the new features in ASP.NET 3.5. The article will also show how you can use features in LINQ, even if you only use stored procedures for data access. And finally, since most applications use reporting, I’ll throw in a few nuggets on using SQL Server Reporting Services.
  
  
• The Baker’s Dozen: 13 Tips for Building Dashboards with Microsoft BI Tools
  
  Magazine/Issue: CoDe Magazine, 2008 Mar/Apr
  Release Date: Friday, February 29, 2008
  Quick ID: 0803051
  Scorecards, test results, report cards, summaries-nearly everyone wants to skip past the details and see the bottom line. Whether it is “pass or fail”, “go or no go”, managers evaluate professional efforts based on performance. Microsoft’s Business Intelligence tools provide developers and power users with the tools and methodologies to produce scorecards and other summaries that graphically represent performance. This article will create a Web-based Dashboard using several Microsoft products, including the newest product in the BI stack, PerformancePoint Server.
  
  
• The Baker’s Dozen: 13 Comparisons Between Crystal Reports and SQL Server Reporting Services
  
  Magazine/Issue: CoDe Magazine, 2007 Nov/Dec
  Release Date: Friday, October 26, 2007
  Quick ID: 0711041
  Recent polls show that nearly fifty percent of applications with reporting functionality use Crystal Reports, and about twenty percent use SQL Server Reporting Services. This article will cover some of the major reporting tasks that developers face, and how the two reporting tools (Crystal and SQL Server Reporting Services) handle the tasks. Finally, I’ll provide a sneak preview at the next scheduled releases of both products (the next version of Crystal Reports and SQL Server Reporting Services 2008).
  
  
• Integrating .NET Code and SQL Server Reporting Services
  
  Magazine/Issue: CoDe Magazine, 2007 - Jan/Feb
  Release Date: Friday, December 29, 2006
  Quick ID: 0701061
  SQL Server Reporting Services versions 2000 and 2005 (SSRS) has many powerful features. SSRS has a well-designed data access engine, a great set of layout tools, and an excellent expression system for creating complex formulas. While the expression system is quite powerful it is not suitable for all applications. This is where SSRS shines. SSRS gives developers the ability to add custom code to their report layouts. This article demonstrates adding custom code to SQL Server Reporting Services reports.
  
  
• Enterprise Reporting with Excel
  
  Magazine/Issue: CoDe Magazine, 2007 - Jan/Feb
  Release Date: Friday, December 22, 2006
  Quick ID: 0701051
  When it comes to analysis and reporting, managers love Excel. Just give them the raw data and they have a field day. For enterprise-level reporting, however, you want everybody to have the same data and the same interpretation of that data. With some effort this can be achieved without having to say goodbye to Excel.
  
  
• The Baker’s Dozen: 13 Productivity Tips for Crystal Reports Redux
  
  Magazine/Issue: CoDe Magazine, 2007 - Jan/Feb
  Release Date: Friday, December 22, 2006
  Quick ID: 0701031
  This article presents a follow-up to my January/February 2005 article, The Baker's Dozen: 13 Productivity Tips for Crystal Reports and .NET, where I presented productivity tips for developers who use Crystal Reports for .NET. In this sequel article, Crystal Reports Redux, I’ll offer some changes to the original article and will present some new material for Crystal Reports development. While I’ll focus on the version of Crystal Reports that ships with Visual Studio 2005 Professional, I’ll mention some of the capabilities found in the latest version, Crystal Reports XI.
  
  
• Ask the Doc Detective
  
  Magazine/Issue: CoDe Magazine, 2006 - May/Jun
  Release Date: Friday, April 21, 2006
  Quick ID: 0605101
  
  
  
• Heard on .NET Rocks!: SQL Reporting Services
  
  Magazine/Issue: CoDe Magazine, 2004 - September/October
  Release Date: Friday, August 20, 2004
  Quick ID: 0409111
  I am the host of .NET Rocks!, an Internet audio talk show for .NET developers online at www.franklins.net/dotnetrocks and msdn.microsoft.com/dotnetrocks. My co-host, Rory Blyth (www.neopoleon.com), and I interview the movers and shakers in the .NET community. We now have over 60 shows archived online, and we broadcast a new show every Thursday night from 10PM to Midnight, Eastern Standard Time (GMT-5). For more history of the show check out the May/June 2004 issue of CoDe Magazine, in which this column first appeared.
  
  
• Creating Custom Data Extensions for SQL Server 2000 Reporting Services
  
  Magazine/Issue: CoDe Magazine, 2004 - July/August
  Release Date: Sunday, June 20, 2004
  Quick ID: 0407051
  In early 2004, Microsoft released a new set of extensions to SQL Server 2000 called SQL Server 2000 Reporting Services.SQL Server Reporting Services provides a comprehensive platform for creating, managing, securing, scheduling, and outputting data from SQL Server, Oracle, OLE DB and ODBC data sources. When Microsoft created SQL Server Reporting Services they created it as an extendable platform. You can create your own data extensions and your own output extensions. In this article, I'll show you how to create your own custom data extensions for SQL Server Reporting Services.
  
  
• Chapter 3: Reporting Services Architecture
  
  Magazine/Issue: Online CoDe Magazine, Book Excerpts
  Release Date: Monday, January 01, 1753
  Quick ID: 070103
  Excerpt from Microsoft SQL Server 2005 Reporting Services by Michael Lisin and Jim Joseph