Tags
Articles in SQL Reporting Service (SSRS)
What does an exported PerformancePoint scorecard look like in Reporting Services report designer?
I was curious what would happen when I opened an RDL file created by PerformancePoint in Report Designer, so I tried it. Here is what I discovered: 1. For whatever reason...
From : Russell Christophers Semi-Useful BI Musings
2007 Nov 28
Readability
Readability Stats: Word Count: 341; Sentence Count: 25; Grade Level: 6.7
Reporting Services Login dialog appears when deploying to MOSS/WSS
Brian Welcker does it again! In this post he describes a situation that's been causing me a great deal of angst. Essentially, after getting MOSS/SSRS integration working, you get prompted to login wh...
From : Russell Christophers Semi-Useful BI Musings
2007 Feb 07
Readability
Readability Stats: Word Count: 76; Sentence Count: 6; Grade Level: 4.3
Reporting Services: Why aren’t all my report columns exporting to CSV and/or XML?
Don’t be surprised if reports exported to CSV or XML are missing several columns of data you otherwise see when viewing the report as HTML, PDF, etc. PDF, HTML, and Excel export leverage “layout renderers” –...
From : Russell Christophers Semi-Useful BI Musings
2007 Feb 07
Readability
Readability Stats: Word Count: 323; Sentence Count: 11; Grade Level: 12.0
Publishing Reporting Services reports to MOSS
(Many, many thanks to Heidi Steen of the super-duper UE team at Microsoft for providing the material below. Hell, she even created screen shots!) Now that lots of folks are happily playing around with SSRS/...
From : Russell Christophers Semi-Useful BI Musings
2007 Jan 16
Readability
Readability Stats: Word Count: 371; Sentence Count: 31; Grade Level: 4.9
Happiness is automatic SQL Reporting Services localization
Many people understand that you can leverage User!Language in order to grab the regional / language settings of a user, then use this information to localize your report data & label text. If you don’t, ...
From : Russell Christophers Semi-Useful BI Musings
2007 Jan 11
Readability
Readability Stats: Word Count: 411; Sentence Count: 31; Grade Level: 7.5
Reporting Services - Add a logo to the Report Manager
The SQL Server Reporting Services Report Manager is functional, but it's not very customizable. The ASPX pages just reference compiled assemblies, so the only real way to modify them is via CSS. What makes th...
From : JonGalloway.ToString()
2006 Dec 13
Readability
Readability Stats: Word Count: 1479; Sentence Count: 139; Grade Level: 6.5
SYSK 219: Solution for SQL Reporting Services Problem Described in SYSK 203
In http://blogs.msdn.com/irenak/archive/2006/09/22/766164.aspx post, the following problem was described: if you have a SSRS report parameter that is multi-value and of one of the labels in the “available valu...
From : AppDev: Something You Should Know by Irena Kennedy
2006 Oct 16
Readability
Readability Stats: Word Count: 105; Sentence Count: 9; Grade Level: 5.4
Reporting Service Updates in SQL 2005 Service Pack 2
SQL Server 2005 Service Pack 2 is coming out soon. The very important piece of SP2 is support of SSRS and SharePoint 2007 Integration. There are many bug fixes and enhancements in the service pack but here ...
From : William Lis Enterprise Reporting
2006 Oct 13
Readability
Readability Stats: Word Count: 248; Sentence Count: 9; Grade Level: 12.0
Use Reporting Service Itself to Monitor Customers' Reporting Activities
The list of reports requested in Requirement or Functional Specification by customers is one thing, the actual list of reports used for day-to-day business after Production is another thing...
From : William Lis Enterprise Reporting
2006 Oct 02
Readability
Readability Stats: Word Count: 519; Sentence Count: 24; Grade Level: 11.2
Can't install SQL Reporting Services 2005 on Vista?
See this article: http://support.microsoft.com/kb/920201
From : Russell Christophers Semi-Useful BI Musings
2006 Sep 25
Readability
Readability Stats: Word Count: 9; Sentence Count: 2; Grade Level: K
SYSK 203: Mind That Label Length in SQL Reporting Services
Another possible (but unconfirmed) bug in SQL 2005 Reporting Services: If you have a SSRS report parameter that is multi-value and of one of the labels in the “available values” list exceeds 25 charac...
From : AppDev: Something You Should Know by Irena Kennedy
2006 Sep 22
Readability
Readability Stats: Word Count: 137; Sentence Count: 4; Grade Level: 12.0
SQL Server 2005 Reporting Services Training Resources
I have collected many free training resources here for people to learn about SQL 2005 Reporting. This list includes various levels of materials including some introduction and advanced topics. Ple...
From : William Lis Enterprise Reporting
2006 Sep 18
Readability
Readability Stats: Word Count: 987; Sentence Count: 132; Grade Level: 4.4
A Typical Enterprise Reporting Architecture
The most typical implementation of Enterprise Reporting architecture includes the following four tiers: Client Tier – Business front-end application and technologies. Web Browser is the most typi...
From : William Lis Enterprise Reporting
2006 Sep 18
Readability
Readability Stats: Word Count: 216; Sentence Count: 12; Grade Level: 12.0
SQL Reporting Services and the Unattended Execution Account
Thanks to John Gallardo and Radu Grama for engaging in a very interesting conversation from which I’m cribbing the following information! Scenario: After changing the password on the user you are using for S...
From : Russell Christophers Semi-Useful BI Musings
2006 Aug 16
Readability
Readability Stats: Word Count: 475; Sentence Count: 22; Grade Level: 12.0
Problems rendering Reporting Services reports with IE 7 Beta 3
There have been some internal discussions about IE 7 Beta 3 hanging while displaying SSRS reports, and Lukasz has a write-up on same. Long story short, sounds like Beta 3 won't play with SSRS nicely. htt...
From : Russell Christophers Semi-Useful BI Musings
2006 Aug 04
Readability
Readability Stats: Word Count: 48; Sentence Count: 5; Grade Level: 2.4
