Welcome to TechNet Blogs Sign in | Join | Help

Reporting Services (RSS)

Useful info on Report Services
Tuesday, January 03, 2006 5:14 PM

SQL 2005 Metadata Samples Toolkit and whitepaper now available

Reposted 10/1/06 to include in 'free tools' category  I'm constantly asked "what's Microsoft doing about metadata and do we have a solution." In the old days (SQl 2000 and 7), Microsoft provided Meta Data Services, a platform designed to help tools
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Monday, January 02, 2006 5:15 PM

New SQL 2005 code samples available

I guess now the pressure is off to release the product we'll see more useful samples comming out of corp; here's a link to the latest December update: http://msdn.microsoft.com/sql/downloads/samples/default.aspx  
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Monday, November 28, 2005 5:47 PM

Feature Pack for Microsoft SQL Server 2005 - November 2005

Overview The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: Latest versions of redistributable components for SQL Server 2005 Latest versions of add-on providers for SQL
posted by Mat_Stephen | 3 Comments
Filed Under: , , , , ,
Tuesday, October 04, 2005 1:07 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Tuesday, August 30, 2005 4:27 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , , ,
Friday, August 19, 2005 11:24 AM

Reporting Services: Calling an aspx page from a report and passing a parameter

Sudhi recently asked me how to call an aspx page from a report and pass a parameter held in a textbox, or other control. My solution is: Drag a textbox control on to the report and enter the value "2005/07/28/408325" (without the the quotes) in to it. 
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Tuesday, August 16, 2005 11:49 AM

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
posted by Mat_Stephen | 5 Comments
Filed Under: , , , ,
Thursday, August 04, 2005 3:08 AM

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'.
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Monday, July 18, 2005 11:16 AM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Thursday, July 14, 2005 9:35 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Tuesday, June 28, 2005 10:22 PM

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.
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Tuesday, June 28, 2005 1:40 PM

SQL Server Reporting Services: Custom colour in charts

A frequently asked question is, 'how does one customise the colours in a chart?'  Below is a link to a blog post from Brian Welcker, which is actually a post on how to overcome the encumberence of the chart legend when it takes up too much space
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Wednesday, June 22, 2005 5:28 PM

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 ReportsMost Executed
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Tuesday, June 14, 2005 10:21 AM

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:
posted by Mat_Stephen | 1 Comments
Filed Under: , , ,
Friday, June 10, 2005 3:57 PM

SQL 2005 Express to get Report Server and Workgroup edition to get Report Builder

Good news! Due to popular demand we have added Report Server to the Express edition of SQL 2005 and added Report Builder to the Workgroup edition - there are some caviats though so check the small print at the bottom of this feature guide. http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
More Posts Next page »