Building Effective data visualizations in Reporting Services 2008 R2

This is a live post from the session of Ronen Chen at Tech Ed Israel 2010 .

New to report builder 3.0 – we can be in local mode or server mode. We can check it in relation to performance on the server and save in directly on the server (rather than on my PC).

Zooming and moving my map . . . → Read More: Building Effective data visualizations in Reporting Services 2008 R2

SQL Server 2008 R2 Reporting Services – The World is But a Stage (T-SQL Tuesday #006)

Host Michael Coles (blog|twitter) has selected LOB data as the topic for this month’s T-SQL Tuesday, so I’ll take this opportunity to post an overview of reporting with spatial data types. As part of my work with SQL Server 2008 R2 Reporting Services, I’ve been exploring the use of spatial data types in the new map data region. You can . . . → Read More: SQL Server 2008 R2 Reporting Services – The World is But a Stage (T-SQL Tuesday #006)

Do-It-Yourself Map Gallery in SQL Server 2008 R2 Reporting Services

A common question that I get when introducing the map feature in SQL Server 2008 R2 Reporting Services is why the map gallery is limited to maps of the United States and individual states in the US. The reason as I’ve heard it explained is that the political boundaries for other countries are sometimes in dispute and . . . → Read More: Do-It-Yourself Map Gallery in SQL Server 2008 R2 Reporting Services

Using Dynamic MDX in Reporting Services: Part 2

In this post, I continue my exploration of approaches to working with dynamic MDX in a Reporting Services dataset when you are using Analysis Services as a data source. I began this series with a look at string conversion functions in Part 1. In Part 1, the dynamic MDX relied on parameters that work as a filter . . . → Read More: Using Dynamic MDX in Reporting Services: Part 2

Using Dynamic MDX in Reporting Services: Part 1

If you’re using Analysis Services as a data source for Reporting Services reports, you can build a simple dataset using the graphical query designer, but you’ll want to switch to the generic query designer to create the MDX query string manually when you have more advanced requirements. Using the generic query designer, you can:

· Impose greater . . . → Read More: Using Dynamic MDX in Reporting Services: Part 1

Changing Export Options for Reporting Services

Have you ever wanted to change the export options for Reporting Services?  Have you seen issues with report page headers being exported to Excel as non headers? Other times displaying all export options on the web is not the best idea.  An end user trying to figure out what a TIF is can be a more . . . → Read More: Changing Export Options for Reporting Services

Modify Reporting Services Export to CSV behavior

Aside from the default HTML rendering, SQL Server Reporting Services (SSRS) supports rendering extensions as well.
You can write your own extension if necessary, or you can use one of the rendering extensions that are included in SSRS.
These default extensions allow you export your report to the required format, i.e. PDF, EXCEL, CSV, etc.
Sometimes you come across a . . . → Read More: Modify Reporting Services Export to CSV behavior

Use Date Picker Control with MDX Based Reports

If you’ve done a couple cube based reports, you’ve run into the issue of the dates being in string format. Because the dates are strings inside your cube, you can’t use the neat little date picker control reporting services gives you for datetime parameters. While you as a developer may understand this issue, your “tech savvy” . . . → Read More: Use Date Picker Control with MDX Based Reports

An Overview of SQL Server 2005 Reporting Solutions

The primary focus of today’s IT systems is deriving information from collections of data, and several technologies exist for this purpose. With SQL Server 2005, we get all the modern analytical technologies, from basic reporting, through OLAP systems, to data mining applications. In this article and the next, I will present all available possibilities in SQL . . . → Read More: An Overview of SQL Server 2005 Reporting Solutions