Browse by Tags

• 2005
• 2008
• business
• calendar
• data source
• database mirroring
• display
• grey
• information
• kba
• sample
• sap
• service pack2
• snapshot
• sql
• SQL Server
• SQL Server 2008
• toolbar
• tutorial
• view report

• Invalid namespace - Running SSRS against a named instance

  I recently went to check the configuration of my SQL Server 2008 Reporting Services instance (which is a named instance called "SQL08") and it came up with a "connect" dialog and when I clicked on the "find" button I got an "invalid namespace" error. Read More... Posted Thursday, September 04, 2008 8:21 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Reporting Services, SQL Server, SQL Server 2008

• Guide for new Report Builder users

  "They'll probably still just ask me for their reports..." I hear students say when I teach them about Report Builder in SQL Server 2005 Reporting Services (SSRS). It's a reasonable fear. Their managers have always asked them for reports. Read More... Posted Friday, December 14, 2007 6:42 PM from Rob Farley | (Comments Off) Filed under: Reporting Services

• How multi-value query parameters in SSRS are treated by SQL Server

  This is something that has bothered for me for a while. In SQL Server Reporting Services, you write a query against a data source, and that becomes the data set for the report. Brilliant. I like to write the query in Management Studio first, and then Read More... Posted Friday, November 23, 2007 8:48 AM from Rob Farley | (Comments Off) Filed under: sql, Reporting Services

• How to format the subtotals of a Reporting Services matrix differently, using InScope

  Here's the scenario. Your SQL Server Reporting Services (SSRS) report has a matrix, showing the sales of each salesperson per year. You put conditional formatting in place so that cells in the matrix that have sales over 1000000 are in a different Read More... Posted Thursday, November 22, 2007 12:54 PM from Rob Farley | (Comments Off) Filed under: sql, Reporting Services

• FIX: The calendar control in a SQL Server 2005 Reporting Services report may display incorrect values

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The calendar control in a SQL Server 2005 Reporting Services report Read More... Posted Wednesday, September 05, 2007 2:38 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, kba, calendar, display

• FIX: Error message when you display a report that uses SAP Business Information Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: “Can't find object <Object ID>”

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you display a report that uses SAP Business Information Read More... Posted Saturday, September 01, 2007 2:25 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, kba, service pack2, information, data source, business, sap

• FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View Report"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View Report" Read More... Posted Friday, August 31, 2007 4:48 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, kba, grey, toolbar, view report

• Report Building tutorials in SQL 2008 (CTP4)

  Within SQL 2008 I was looking for information on report building (GUI enhancement) as compared to SQL 2005 Reporting Services. I believe nothing much different by looking at the current CTP for SQL 2008, I expect a change when SQL 2008 RS is ready RTM. Read More... Posted Tuesday, August 21, 2007 2:26 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, tutorial, 2008, 2005, sample

• When to use mirrored server as a reporting server?

  IN the case of production server which is running 24/7 and can't afford any downtime, it is good to keep the mirrored server for reporting purpose. Say if the requriement is to have r eporting server that should be updated with data from production server Read More... Posted Wednesday, August 08, 2007 6:09 PM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, database mirroring, snapshot

• Reporting Services - Getting the Matrix to Display Two Subtotals for the Same Group

  This week I am switching gears to talk about a cool design technique for the Reporting Services matrix. At least it is cool to me J and hopefully it will be helpful to you. In some design scenarios, you may require two “subtotals” for the same group of Read More... Posted Saturday, July 22, 2006 9:55 AM from Elizabeth Vitt | (Comments Off) Filed under: Reporting Services