Browse by Tags

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

• Infinite Drill-through in a single SSRS report

  Grant Paisley of Angry Koala and Report Surfer put me onto this a while back, and I have to admit I’m a bit of a fan. The idea comes from the fact the way that SQL Server Reporting Services (both 2005 and 2008) handles parameters with Analysis Services, Read More... Posted Monday, December 21, 2009 8:18 PM from Rob Farley | (Comments Off) Filed under: sql, adssug, Reporting Services, ssas, mdx

• SSRS: Removing the Navigation link using an Expression

  There are times when you want to have a Navigation property of a textbox (typically providing a link to a URL or other report), but you don’t always want the link to be there. Sometimes you just want it to be an ordinary textbox. This particularly applies Read More... Posted Tuesday, August 04, 2009 11:22 PM from Rob Farley | (Comments Off) Filed under: sql, Reporting Services

• A review: "Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy

  A while back I got asked if I’d review this book, but as they could only get me a copy in PDF format, it’s taken a while to get to it. Whilst I like having electronic copies of books, I generally prefer to read them in paper form, and just have the electronic Read More... Posted Saturday, July 25, 2009 10:19 PM from Rob Farley | (Comments Off) Filed under: Reporting Services, book review

• 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