CODE Magazine / Articles
Reporting Services
Articles filed under Reporting Services
Articles
Showing 1–25 of 25
-
Power BI and R: A Visual Power Punch
Updated
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
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
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
Updated
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
Updated
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
Kevin looks at his favorite reporting tool (SSRS) and shows you how to maximize your users’ experience.
-
SQL Server Reporting Services: Seven Power Tips
Updated
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
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
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
Updated
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
Updated
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
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.
-
SQL Server Reporting Services Hits its Stride
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.
-
-
The Baker’s Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
Updated
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
Updated
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
Updated
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
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
Excerpt from Microsoft SQL Server 2005 Reporting Services by Michael Lisin and Jim Joseph
-
Enterprise Reporting with Excel
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
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
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.
-
-
Heard on .NET Rocks!: SQL Reporting Services
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
Updated
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.