-
Power BI and R: A Visual Power Punch
By:
Helen Wall
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - July/August
Data Visualization can be the best way to get your message across. Helen shows you how, using Power BI and R.
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data, Part 2
By:
Kevin Goff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - September/October
Developers should know their data before they spend a lot of effort analyzing it. For example, at face value, you should know if your data is in the millions or billions, and know "that's what the data said" is not the right answer if the data is bizarre. This article in Kevin Goff's Stages of Data series using PowerBI introduces a new state profile page with ranking formulas, new trend-based measures, defining custom filter groups, and more.
-
Best Practices for Data Visualizations: A Recipe for Success
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2019 - November/December
Helen shows you the ins and outs of creating really useful charts and graphs with Tableau. You’ll never make a boring old pie chart again.
-
Creating Embedded Reports in Your Web Apps with Power BI Embedded
By:
Brian Noyes
Last updated: Thursday, April 1, 2021
Published in: CODE Magazine: 2019 - May/June
Brian shows you that Power BI Embedded makes it possible to have great visuals as part of your app. He also helps you figure out which of the many flavors is the right one for you.
-
Refactoring a Reporting Services Report with Some SQL Magic
By:
Last updated: Monday, April 26, 2021
Published in: CODE Magazine: 2018 - May/June
The point of showing data in graphical form is to make things clear, right? Keven shows you how the best of intentions can go wrong and how to repair the damage.
-
SQL Server Reporting Services: Eight Power Tips
By:
Last updated: Friday, May 7, 2021
Published in: CODE Magazine: 2017 - November/December
Kevin looks at his favorite reporting tool (SSRS) and shows you how to maximize your users’ experience.
-
SQL Server Reporting Services: Seven Power Tips
By:
Last updated: Wednesday, May 19, 2021
Published in: CODE Magazine: 2017 - May/June
You already know that SQL Server’s Reporting Services tools are useful. Kevin shows you some nifty work-arounds and extra-credit tricks that will make your reports sing.
-
Azure Skyline: Using WebJobs for Event-Driven, Asynchronous Services
By:
Mike Yeager
Last updated: Friday, June 4, 2021
Published in: CODE Magazine: 2016 - November/December
If your call to services times out after four minutes, you can have a problem if the process needed to retrieve the data or a fire-and-forget operation takes longer than that. What if the user makes a request and then wanders away from the computer? Mike solves it for you, with WebJobs in Azure Skyline.
-
Azure Skyline: Visual Studio Reports in the Cloud
By:
Last updated: Wednesday, June 9, 2021
Published in: CODE Magazine: 2016 - September/October
Every company requires reports. They’re one of the constants of the business world. Mike shows us how to use Azure and VS to get just what you need without the drudgery you’ve come to expect.
-
The Baker’s Dozen State of the Union: 13 Points on SQL Server Data Warehousing and Business Intelligence
By:
Last updated: Thursday, July 15, 2021
Published in: CODE Magazine: 2015 - May/June
Kevin takes a look at SQL Server “then and now,” and shows us just how important it is to understand the various tools involved in BI.
-
The Baker’s Dozen: 13 Power Tips for Using SQL Server Reporting Services 2008 R2
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2011 - July/August
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.
-
Building Line-of-Business RIA in Silverlight Using Microsoft SQL Server 2008 Reporting Services
Last updated: Saturday, January 18, 2020
Published in: CODE Magazine: 2011 - January/February
While the development community has accepted the inevitable future of Line-of-Business RIAs and indispensable role of Silverlight in their creation, many of them have started looking for ways to use Microsoft SQL Server Reporting Services in Silverlight applications. It is logical: Reporting Services is reasonably capable and the most-used reporting engine on the market. Millions of developers are Reporting Services professionals and of course they would like to continue using the tool in their RIAs as well.
-
Incorporating ASP.NET MVC and SQL Server Reporting Services, Part 2
By:
John Petersen
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - November/December
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - September/October
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
By:
Litwin, Paul
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2009 - September/October
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
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2008 - July/August
July August 2008 MVP Corner by Kevin S. Goff
-
The Baker’s Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2008 - July/August
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2008 - May/June
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2008 - March/April
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2007 - November/December
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).
-
Chapter 3: Reporting Services Architecture
Last updated: Tuesday, February 19, 2019
Published in: Book Excerpts
Excerpt from Microsoft SQL Server 2005 Reporting Services by Michael Lisin and Jim Joseph
-
Enterprise Reporting with Excel
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2007 - January/February
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.
-
Integrating .NET Code and SQL Server Reporting Services
By:
Rod Paddock
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2007 - January/February
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.
-
The Baker’s Dozen: 13 Productivity Tips for Crystal Reports Redux
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2007 - January/February
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
By:
Doc Detective
Last updated: Saturday, January 18, 2020
Published in: CODE Magazine: 2006 - May/June
-
Heard on .NET Rocks!: SQL Reporting Services
By:
Franklin, Carl
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2004 - September/October
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
By:
Last updated: Wednesday, February 20, 2019
Published in: CODE Magazine: 2004 - July/August
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.
- Home
Articles filed in category 'Reporting Services'