See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
Analysis Services 2005
Free SQL Server Tools, Utilities and Addins
High Availability and Disaster Recovery
Performance Top Tips
Post Event Follow Up
SQL 64 bit
SQL Server 2000
SQL Server 2005
SQL Server Integration Services
SQL Server Security
Browse by Tags
Mat Stephen's SQL Server WebLog
Microsoft .NET Data Provider for SAP
After my recent SQL 2k5 BI session, here at TVP Reading, I had an enquiry asking for more info regarding the SAP provider I showed in the list of providers available to SQL Server Integration Services . The best public information I can find is @ http://msdn2.microsoft.com/en-us/library/ms216599 . The...
4 Oct 2005
Project REAL—Business Intelligence in Practice - great website!
For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005. The leasons learnt from all their work is being continually published to this website http://www...
30 Aug 2005
SQL Server Reporting Services Report Packs - looking for suggestions
when I was over in the US recently, I attended a 'Bill Baker and team unplugged' session, (Bill is the GM for SQL Server Business Intelligence). Reporting Services Report packs came up as a topic for discussion. The team asked the audience if the Report Packs had been well recieved, to which I quickly...
16 Aug 2005
Letter from America 3 - Mischievous reports and feeding the 5000
After all my messing around yesterday, I've decided to create this post in pocket word. I attended a securty session yesterday and was reminded of an issue that can send DBAs scuttling from the room when they learn of it's presence, the 'trojan report'. Reporting Services (RS) reports can use Windows...
4 Aug 2005
How Do You Deploy SQL Server Reporting Services?
A colleague of mine in the States, Rob Caron, is very keen to learn how our customers are deploying Reporting Services; specifically with respect to IIS. When we launched Reporting Services (RS) it was all too easy to say it was a ‘free’ addition to the SQL stack, indeed it was supposed to add value...
18 Jul 2005
Reporting Services: Two New (Free) Report Packs Released for Sharepoint and Axapta
Good news for the chap I met on the 'Ask the Experts' desk at TechEd, who was contemplating jumping through all sorts of hurdles to create reports form Sharepoint data. I couldn't really get my head round the (Sharepoint) problems he foresaw, but I was able to tell him that a report pack was in the pipeline...
15 Jul 2005
The QFE for SQL Server 2000 Reporting Services Service Pack 2 is now available.
The QFE for SQL Server 2000 Reporting Services Service Pack 2 is now available. The QFE is a generally distributed release that can be obtained from http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en . This software patch includes fixes for...
29 Jun 2005
Querying and Reporting on Report Execution Log Data
Well I didn't realise, or maybe I just plain forgot, that these reports and the necessary support infrastrucuture come with Reporting Services under the extras folder on the CD - all useful stuff for report heads. Longest Running Reports Most Executed Reports Report Exections By Hour Report Parameters...
22 Jun 2005
Reporting Services: How to stop IE striping out leading spaces in report data values
Reporting Services: How to stop IE striping out leading spaces in report data values: My thanks to Russell Christopher and Mike Schetterer who recently discussed the problem that IE will strip out leading spaces from data in a report. The solution: you have to replace the spaces with the ASCII code...
14 Jun 2005
Keep up-to-date with knowledge base articles coming out of Microsoft
I am very grateful to Andy Steer of Contemporary Plc for this useful tip. To keep up-to-date with knowledge base articles coming out of Microsoft, check out this web page containing RSS feeds for all Microsoft products: http://support.microsoft.com/selectindex/?target=rss
31 May 2005
SQL Server Reporting Services: How to do an aggregate, SUM(Field), and display it as a % of the total for a Table or Matrix column
SQL Server Reporting Services: How to do an aggregate, SUM(Field), and display it as a % of the total for a Table or Matrix column To do this we have to take advantage of the fact that the SUM function, and indeed all aggregate functions, have an optional scope parameter =Sum(Fields!A.Value) /...
26 May 2005
Webcast with Proclarity
If you were unable to connct to our webcast with Proclarity last month then please have another go, here is the corresponding missive from marketing: Last month you registered to attend the TechNet Webcast ‘Analysing and Presenting SQL Server Data with Proclarity – a Technical Overview’. Unfortunately...
12 May 2005
Top Tip - Dynamic Database connections for SQL Server 2000 Reporting Services reports
A question that crops up from time to time with SQL Server 2000 Reporting Services is 'how do I dynamically change the data source used buy a report - from within a report?' To do this is quite straight forward in SQL 2005 Reporting Services but not so with SQL 2000 Reporting Services. I am grateful...
4 May 2005
SQL Server Reporting Services: Secure reports, passing parameters and User!UserID
After taking a customer query regarding securing report parameters I found this blog entry from Tudor Trufinescu – I thought I would share it with you. The moral of the story is – don’t pass sensitive parameters. http://blogs.msdn.com/tudortr/archive/2004/07/20/189398.aspx
27 Apr 2005
Top Tip SQL Server Reporting Services fields cannot be used in headers or footers - work around
I'm grateful to Chris Hayes for this top tip. Reporting Services doesn't like you using data fields in its headers and footers - here are two ways to work around the problem Add a parameter to the report without a prompt (so the user doesn’t see it) and with a default value based on the field...
27 Apr 2005
Two new free Microsoft SQL Server Reporting Services Report Packs released for IIS and Great Plains
From the blog hits I received the last time I posted some info on free report packs available for SQL Server Reporting Services, I'm sure many of you will be pleased to find we've just posted two more for IIS and Great Plains. Objective: The Report Packs provide customers with templates of commonly...
4 Apr 2005
Microsoft SQL Server - Reporting Services Scripter - a free tool from sqldbatips.com
I’m grateful to Andy Steer of Contemporary, one of our Gold BI Partners here in the UK , for pointing me to this useful free utility from.sqldbatips.com Overview: Reporting Services Scripter is a .NET Windows Forms application that enables scripting of all Microsoft SQL Server Reporting Services catalog...
22 Mar 2005
Reporting Services : 21 Report packs released to the web for free download
Just incase you missed this freebie: Report Packs SQL Server 2000 Report Pack for Microsoft CRM Download this set of six predefined CRM-based reports and a sample database that let you easily visualize and author managed reports to support key sales activities SQL Server 2000 Report Pack...
14 Feb 2005
Blogcast - Creating a simple Microsoft SQL Server Reporting Services report using the Report Wizard
Following the trend I've created my first Blogcast - Creating a simple SQL Server Reporting Services report using the Report Wizard. It lasts about 6 minutes. It takes you through the simple steps required to create a simple report, making a little tweak with Visual studio and then shows you how to publish...
5 Feb 2005
Business Intelligence Portal Sample Application for Microsoft Office
A good number of people have told me just how useful this sample application is: Business intelligence portal sample application for Microsoft Office 2003 is an integrated, web-based OLAP solution that enables employees in an organization to create and share OLAP/Relational/XML based views, using SharePoint...
1 Feb 2005
Using Microsoft SQL Server Reporting Services against SAP - and other Application Partners for Reporting Services
Do you want to use Microsoft Reporting Services to report data from SAP R/3 and SAP BW? Then check out Software4You from the list of Application Partners for Reporting Services @ http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
1 Feb 2005
SQL Server Health and History Tool (SQLH2)
This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5. Realising such downloads have sometimes escaped me I’ve decided to subscribe to Download Notifications...
7 Jan 2005
Hitchhicker’s Guide to SQL Server Reporting Services author to present at IT Forum Highlights - Birmingham UK 13th Jan 05
Hitchhiker’s Guide to SQL Server Reporting Services is an excellent book in the Hitchhiker’s series of excellent books. The book is co written by Peter Blackburn (UK MVP) and William Vaughn (massive reputation). I think it is excellent for three reasons; it is comprehensive, practical and well written...
4 Jan 2005
3rd Party Report Builders for SQL Server Reporting Services that don't require Visual Studio know how.
A recurring concern for IT Pros looking to employ SQL Server Reporting Services is the apparent need to use Visual Studio as the report designer. This is not the case. There are a number of alternatives out there. Firstly, there are two alternatives that I’m aware of that can be used by normal ‘end users...
21 Dec 2004
MSDN Webcast: New Features in Reporting Services Service Pack 2 (Level 400)
Monday, January 10, 2005 - 9:00 AM - 10:00 AM Pacific Time Geoff Snowman, MSDN DEVELOPER COMM CHAMPION, Microsoft Corp. Service Pack 2 for Microsoft SQL Server Reporting Services contains two improved features: client-side printing and Microsoft SharePoint integration, in addition to the usual rollup...
20 Dec 2004
© 2014 Microsoft Corporation.
Privacy & Cookies