Browse by Tags

• SQL Server

• Ensure best Excel export formating from SQL Server Reporting Services

  When designing reports it is important to be aware that the report may be exported to Excel. This is most apparent when data manipulation must be done to satisfy the reporting requirements. SSRS exports to excel using the underlying data source and not Read More... Posted Thursday, June 28, 2007 6:49 PM by mab | 3 Comments Filed under: Reporting Services

• How to create a hyperlink in Reporting Services that opens in a new window

  I was at a client and the question came up "Can I jump to another web based tool from my report?". The answer seemed obvious ... YES. What was not straightfoward was how to open the other web based tool in another window. Here is a solution a found (someone Read More... Posted Thursday, May 17, 2007 12:35 PM by mab | 4 Comments Filed under: SQL Server, Reporting Services

• SQL Server 2005 SP2 is now available

  For those anxiously awaiting, SQL Server 2005 SP2 is now available at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx Read More... Posted Tuesday, February 20, 2007 9:22 AM by mab | 0 Comments Filed under: SQL Server, Reporting Services

• Reporting Services and #ERROR in cells

  When writing a reporting services report sometimes it is impossible to evaluate all errors in desing mode. Occasionally, you may run across that the report runs but a single cell my return a #ERROR instead of the value expected. Sometimes this is caused Read More... Posted Tuesday, February 20, 2007 8:57 AM by mab | 0 Comments Filed under: Reporting Services