The Curious Engineer

All blogs / Databases

Russell Christopher's Semi-Useful BI Musings

learn.microsoft.com/en-us/archive/blogs/bimusings

This blog contains random one-off solutions to various problems I've encountered while using Microsoft's Business Intelligence tools SQL Server 2005 / Katmai

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
148 from 15 Jun 2005 to 20 Jul 2011
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/bimusings/feed.xml

2011 2

  1. A new Tableau-focused blog: Tableau Love
  2. Russell Christopher's two websites

2009 1

  1. SQL Server 2008 R2 CTP2 hits the streets and I am psyched!

2008 14

  1. Where did the Reporting Services 2008 Add-in for SharePoint go?
  2. Proof positive that SSRS 2008 is superior to SSRS 2005
  3. SQL Reporting Services: What does that “Thread pool pressure” warning mean?
  4. Language Packs and the PerformancePoint add-in for Excel
  5. Problems making web reference to ReportService2006: Unable to import operation "SetReportHistoryOptions"
  6. SQL Analysis Services error processing ROLAP partitions against Teradata
  7. PerformancePoint: Why can’t I see values for my KPI’s Actual and Target metrics in a scorecard?
  8. Save your SSAS browser queries for re-use: new add-in
  9. Moving On…
  10. Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer
  11. What I like about SQL Server 2008 Reporting Services: The Configuration Manager
  12. SSRS File Share provider in a Workgroup
  13. SQL Server 2-D Matrix Builder available on CodePlex
  14. RSPreviewPolicy.config: Change in behavior for BIDS 2008?

2007 43

  1. What does an exported PerformancePoint scorecard look like in Reporting Services report designer?
  2. Minor idiosyncrasy exporting a PerformancePoint Scorecard to SQL Reporting Services
  3. How to really, really remove PPS Dashboard Designer
  4. Orcas/VS 2008 ReportViewer redist now available
  5. SQL Server 2008 "Katmai" CTP5 released
  6. Alerting without SQL Server Notification Services
  7. Bad password trying to process an SSAS cube against Oracle
  8. SAP buys Business Objects
  9. PerformancePoint Server 2007 Ships! (as in, you can download it)
  10. Dell and Microsoft engineer BI offering
  11. Mosha Pasumansky releases new Analysis Services MDX tool
  12. At SQL PASS? Don't miss these sessions!
  13. File under: Cool feature in Reporting Services editor I never knew existed
  14. Hot off the presses: resolving MDX query performance bottlenecks
  15. AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction
  16. Microsoft acquires Dundas’s data visualization components, SQL 2008 news & download CTP3!
  17. Holy Snikes the Dundas OLAP Services stuff is nice!
  18. OfficeWriter functionality could be included in Katmai
  19. SAP Acquires OutlookSoft
  20. How do you set “(Select All)” as the default for multi-value parameters in Reporting Services?
  21. MDX Script Performance Analyser on CodePlex
  22. SQL Analysis Services Load Simulator released on CodePlex
  23. PPS CTP2 VPC now available, too!
  24. First Cumulative Update for SQL Server2 2005 SP2 Released
  25. The curious saga of “(Select All)” and multi-valued parameters in Reporting Services
  26. PerformancePoint CTP2 now available for download
  27. New SQL Server Reporting Services Guided Tours
  28. How to use URL Access in Reporting Services SharePoint integration mode
  29. Installing SSRS (via SQL Server Express Advanced Edition) on Vista 64-bit
  30. Using the “old” Reporting Services web parts in MOSS 2007
  31. SQL 2005 SP2 most likely available this Monday, 2/19
  32. rsWindowsIntegratedSecurityDisabled error when running Reporting Services report in SharePoint integrated mode
  33. Reporting Services: Why aren’t all my report columns exporting to CSV and/or XML?
  34. Reporting Services Login dialog appears when deploying to MOSS/WSS
  35. Can’t see “Reporting Services” on the SPS Application Management page after installing SPS/SSRS add-in
  36. Mixed Bag: Troubleshooting Reports and Viewing MDX in Excel 2007
  37. Reporting Services and MOSS/WSS integration in a farm deployment
  38. Compress PDFs exported from the ReportViewer control
  39. Publishing Reporting Services reports to MOSS
  40. Microsoft & Teradata to collaborate on BI solutions
  41. Reporting Services and MOSS SSO?
  42. Here's the RDL
  43. Happiness is automatic SQL Reporting Services localization

2006 35

  1. SQL Server 2005 SP2 CTP3 (December) is live!
  2. Data Refresh in Excel Services fails with "SSO has failed with the following error code -2140995579, exception: Error in the application"
  3. Custom Report Items not supported in SQL Express & Workgroup Editions
  4. A very cool (new) Report Designer from 90 Degree Software
  5. Confessions of a reformed SPS hater - MOSS and Microsoft Business Intelligence
  6. Saving SQL Server Reporting Services Reports inside MOSS
  7. Where are the @#!$!?*& Floating Headers in SQL Reporting Services?
  8. Reading the web.config file in SQL Reporting Services
  9. Changing your gridsize in the SQL Reporting Services Report Designer
  10. Can't install SQL Reporting Services 2005 on Vista?
  11. SQL Reporting Services and the Unattended Execution Account
  12. Reporting Services rendering performance improvements in Katmai
  13. SQL 2005 Books Online refresh #3 and updated samples for July just released
  14. More fun with expression-based connection strings in Reporting Services
  15. Using a parameterized SSIS package as a data source for SQL Reporting Services
  16. Unloading & Loading Reporting Services 2005 perfmon counters
  17. Modifying label and tooltip text in the SQL Server Report Viewer controls (and a localization workaround!)
  18. Where did "Select All" go in SQL Reporting Services 2005 SP1?
  19. Unable to launch Report Builder from Report Manager when running Internet Explorer 7 Beta 2
  20. SQL 2005 BOL Refresh 2 now available
  21. "Internet Explorer cannot download <filename>" in Report Viewer controls
  22. Microsoft accquires ProClarity!
  23. Using SQL 2000 for SSRS 2005 metadata storage
  24. Using the XML Data Extension to leverage an ADO.NET dataset in your SQL Reporting Services Report.
  25. SQL Server 2005 Express Edition and Reporting Services -- At last!
  26. Good articles around using the ReportViewer control by Teo Lachev
  27. SQL Server 2005 SP1 CTP Available
  28. Good post on Model Security
  29. SSL and SQL Reporting Services 2005
  30. Using "Scale-Out" deployments In SQL Server Reporting Services 2005
  31. Deploying a SQL Server Reporting Services 2005 report via an MSI
  32. Can’t see “Import Reports” in SQL Server Reporting Services Report designer
  33. Can I still download SQL Server 2000 Reporting Services even though 2005 has released?
  34. Yeah, yeah, it's not really BI -- Who cares
  35. Changes in SSRS 2005 FindString HTMLViewer Command (URL Access)

2005 53

  1. I want to render HTML / RTF *as* HTML / RTF inside a SQL Reporting Services Report
  2. Updated SQL 2005 books online now available
  3. Where are the Reporting Services samples in 2005?
  4. The (un)official guide to SQL Reporting Services 2000 & 2005 interop
  5. Creating a template report in SQL Reporting Services 2005
  6. Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider
  7. Report Builder and Forms Authenticaton in SQL Server Reporting Services 2005
  8. SQL Express and SQL Reporting Services 2005 – Soon, but not yet
  9. (Almost) everything you need to know about the Report Viewer control in one place
  10. Browsing Reporting Services 2005 Reports without IE for Windows
  11. SQL Server 2005 Samples and Sample Databases Available for DL
  12. Impersonating another user with the Web Form Report Viewer control and SQL Server Reporting Services 2005
  13. New Reporting Add-In for Microsoft Visual Web Developer 2005 Express
  14. SQL Server 2005 Report Builder and Basic Authorization
  15. Impersonating another user with the Windows Form Report Viewer control and SQL Server Reporting Services 2005
  16. Using Forms Authentication with the Report Viewer control and SQL Server Reporting Services 2005
  17. Launching Report Builder from a Winform or Webform Application in SQL Reporting Services 2005
  18. Using a Report Builder Model as a Report Designer data source in SQL 2005
  19. Installing and Localizing the Visual Studio 2005 Report Viewer Controls
  20. SQL 2005 CTP 16 is here
  21. Fun with Date Functions in SQL Reporting Services Report Builder
  22. Sharing Forms Authentication cookies in SQL Reporting Services
  23. A couple of post IDW15 changes when building Report Builder Models in SQL Server Reporting Services 2005
  24. 2005 report farms and the Surface Area Configration tool. The horror! The horror!
  25. Tuning scheduled/delivery-related processes in a SQL Server Reporting Services Reporting Farm
  26. Random SSRS nuggets from all over
  27. Querying ExecutionLog in SQL Server Reporting Services: discretion is the better part of valor
  28. Creating Report Subscriptions via SQL Managment Studio in SQL Server 2005
  29. SQL Server Integration Services: Sometimes BCP is "good enough".
  30. Forms authentication and the ReportingService Web Service
  31. Field Name Resolution in SQL Reporting Services 2005's Report Builder
  32. Bet you don't know about these SQL Reporting Services perfmon counters
  33. Checking the version of Reporting Services you're running 2000/2005
  34. Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element
  35. Multi-column interactive sort in SQL Reporting Services 2005
  36. Is SQL Reporting Services 2000 / 2005 cluster aware?
  37. What to do after renaming your Report Server
  38. How to hide items in the HTML Toolbar control for SQL Server 2000 Reporting Services
  39. RGDI and the Winform Report Viewer control in SQL Server 2005 Reporting Services
  40. Good information on using the Report Viewer controls with SQL Reporting Services 2005
  41. "A data source instance has not been supplied for the data source" exception w/ Report Viewer Control
  42. Report name with spaces and the ReportEmbeddedResource property of the Whidbey Report Viewer control
  43. Displaying text vertically in SQL Server Reporting Services 2000
  44. Displaying Report Builder to non-admin users in SQL Server Reporting Services 2005
  45. All about SQL Server Reporting Services 2000 Logs:
  46. Another way to deal with defaults and snapshots in SQL Reporting Services
  47. How to preview a report without direct access to its data source in SQL Server Reporting Services 2000
  48. Reporting Services Features by SQL Server 2005 version
  49. How to force multiple lines of text into a textbox in SQL Reporting Services
  50. Accessing a report anonymously in SQL Reporting Services 2000
  51. Where do I deploy my custom assemblies when working with SQL Reporting Services 2005?
  52. #Error when using a custom assembly in SQL Reporting Services
  53. Missing Leading Spaces in SQL Reporting Services Reports