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. I found a few threads on the MSDN forums about this and eventually a Microsoft guy came ...

"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. Sometimes they just ask for data and then manipulate it in Excel to make it look the way ...

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 paste it across. But this doesn't always work, and multi-value parameters is why. ...

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 colour - which is done by putting a formula in the property 'color', like =iif(me.value ...

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 may display incorrect values http://support.microsoft.com/kb/940382/en-US...(read more)

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 Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: ...

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'' http://support.microsoft.com/kb/940149/en-US...(read more)

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. Meanwhile if you are willing to go through this refer to the Tutorials links as follows: ...

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 at least by every 30 minutes. Bear in mind b oth Log shipping and Replication can't be used ...

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 data that point to different ...