SQL Server 2008 R2 introduced several new features in the SSRS arena. In the data visualization category, we now have three additional ways to display and visualize/analyze data in the reports: sparkline and data bars, indicators reports, and map reports. Arshad Ali shows you how to create a map report with drill down functionality.
2012-04-23
3,992 reads
I need to move all the objects off the 2005 Reporting Server to the 2008 Reporting Server. Is there an easy way to do this without saving each report file (edit report and save .rdl) then uploading the report to the new server? This would also mean recreating the data sources and subscriptions.
2012-04-16
4,495 reads
SQL Server 2008 R2 brought several new features into the SSRS (SQL Server Reporting Services) arena. In the data visualization category, we now have three additional ways to display and visualize/analyze data in the reports.
2012-03-23
4,108 reads
Learn how to pull the month names in a report drop down using a recursive common table expression (CTE).
2012-03-13
10,831 reads
Stored procedure to update SSRS Subscription owners to avoid email errors.
2012-03-13 (first published: 2012-02-28)
1,469 reads
Companies often need to generate reports and forms from scanned images and various government supplied formats. Proper knowledge of how to incorporate images in a report is a must.
2012-02-22
2,649 reads
A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.
2012-02-08 (first published: 2012-01-04)
1,947 reads
DBAs are usually charged with the administration of Reporting Services, but are often short on guidance on how to go about such tasks as planning, documenting and troubleshooting those aspects that are specific to the SSRS service. Feodor Georgiev gives some tips, custom SSMS reports, and useful TSQL queries, based on his experience.
2011-12-19
3,032 reads
DBAs are often short on guidance on how to go about such tasks as planning, documenting and troubleshooting those aspects that are specific to the SSRS service. Feodor Georgiev gives some tips, custom SSMS reports, and useful TSQL queries.
2011-11-30
2,633 reads
Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. How do I go about building a scale-out SQL Server 2008 R2 Reporting Services running on Windows Server 2008 R2?
2011-11-18
1,790 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Comments posted to this topic are about the item A Worse Computer; A Better...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers