|
|
|
|
Browse by Tags
All Tags » SSRS (RSS)
-
In SQL Server 2008 R2 Reporting Services, you can now create maps for reports using the built-in map gallery of the United States or individual states, ESRI shapefiles, or a spatial query. In a previous post , I explained how to obtain an ESRI shapefile Read More...
|
-
I had to troubleshoot a problem with a mysterious extra page appearing in a PDF this week. My first thought was that it was likely to caused by one of the most common problems that people encounter when developing reports that eventually get rendered Read More...
|
-
A nice feature that appeared first in SQL Server 2005 (not SQL Server 2008 - I mis-remembered!) is the ability to allow the user to click a column header to sort that column. It defaults to an ascending sort first, but you can click the column again to Read More...
|
-
When you combine multiple filters, Reporting Services uses AND logic. Once upon a time, there was actually a drop-down list for selecting AND or OR between filters which was very confusing to people because often it was grayed out. Now that selection Read More...
|
-
This week I stumbled upon an undocumented “feature” in SQL Server 2008 R2 Reporting Services as I was preparing a demonstration on how to set up and use report snapshots. If you’re familiar with the main changes in this latest release of Reporting Services, Read More...
|
-
A question came in from a reader asking about how to create a NOT IN filter. You can see in the first of this series of blog posts about Reporting Services filters , NOT IN is not available in our list of operators for filters. However, it's still possible Read More...
|
-
Thus far in this series, I have described using the IN operator and the LIKE operator . Today, I’ll continue the series by reviewing the TOP and BOTTOM operators. Today, I happened to be working on an example of using the TOP N operator and was not successful Read More...
|
-
In the first post of this series , I introduced the use of filters within the report rather than in the query. I included a list of filter operators, and then focused on the use of the IN operator. As I mentioned in the previous post, the use of some Read More...
|
-
There are two ways that you can filter data in Reporting Services. The first way, which usually provides a faster performance, is to use query parameters to apply a filter using the WHERE clause in a SQL statement. In that case, the structure of the filter Read More...
|
-
Another PASS Summit has come and gone, and a good time was had by all. The song at the opening keynote sums up the experience quite nicely, "Simply the Best." My favorite quote of the week comes from Andy Leonard ( blog | twitter ) who tweeted on November Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
If you have any experience at all with Reporting Services, you have probably developed a report using the matrix data region. It's handy when you want to generate columns dynamically based on data. If users view a matrix report online, they can scroll Read More...
|
-
On April 14, 2010, Microsoft Press ( blog | twitter ) released my latest book, co-authored with Ross Mistry ( twitter ), as a free ebook download - Introducing Microsoft SQL Server 2008 R2 . As the title implies, this ebook is an introduction to the latest Read More...
|
|
|
|
|
|