Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

SQL Server Relational and Beyond

News

  • This posting is provided "AS IS" with no warranties, and confers no rights.
  • Technorati Profile

Browse by Tags

All Tags » Reporting Services   (RSS)
SQL Server 2008 Report Builder v2.0 RC1
As I mentioned a few weeks ago the end user reporting tool for SQL Server 2008, Report Builder v2 didn’t release with SQL Server 2008. There was an RC0 version of it with SQL Server 2008 RC0 and when SQL Server 2008 released this download disappeared Read More...
Who stole my Report Builder
Anyone who has tried Report Builder v2, aka Report designer Preview, blue etc. will have noticed that it isn’t fit for purpose yet.  By this I mean it is not in a state in which you could give it to a what Microsoft calls an information worker i.e. Read More...
Reporting Services drill-through for a matrix report
One of the great things about working in Microsoft is the huge e-mail threads with where we share problems and resolve them, as you get to learn loads of tips and tricks. One of the nightmares of working at Microsoft is the huge e-mail threads with where Read More...
SQL Server 2008 End User Reporting
I have been seeing a fair bit of confusion about the new end user reporting tools in SQL Server 2008, so I thought it would be good to try and clear it up. In SQL Server 2005 there is a Report Builder tool that relies on a Report Model.  The report Read More...
SQL Server 2008 RC0 feature pack
The sharp eyed amongst you will have noticed that there are a few things missing in RC0 that were in CTP6 and I was a bit annoyed that one of my favorites, the report designer preview had disappeared. Don’t panic it’s tucked away in the SQL Server 2008 Read More...
Deprecated Features in SQL Server 2008
My first ever post was about the features in SQL Server 2000 that were deprecated in SQL Server 2005 i.e. they wouldn’t be available in the next release (SQL Server 2008). In the same way there are SQL Server 2005 features that will be deprecated in SQL Read More...
Upgrading SQL Server Business Intelligence
Continuing my series of posts on upgrade, I thought it might be good to have a look at the business intelligence components of SQL Server, so here’s a simple grid that I have adapted from Scalability Experts for use in the upgrade workshops and Read More...
Word Reports from SQL Server 2008
I was doing a demo to the final year business students Aston University today , and I noticed that you can now render reports to Word from Reporting Services (it's in CTP 6 of SQL Server 2008). About time some of you would say but this really needed Word Read More...
SQL Server Reporting Services - Report Designer
I was at SQL Bits (the SQL) at Aston University on Saturday and as usual if I can't answer a question on the day you will find it here: Does SQL Express 2008 include Report Designer? Yes and in fact that's all you get as BIDS only comes with standard Read More...
Management Reporter - the new FRx
  One of the worst reporting headaches is producing output for the finance department.  The reports need to meet strict standards, be penny perfect, and the end user always wants the report to be in excel.  With reporting services in SQL Read More...
Monitoring Reporting Services
Reporting services, like many services, logs what is going on to to a log file, in this case the RS Report Execution Log.  Scanning that log for activity is a pain, so it would make sense to be able to query that and properly report on what's going Read More...
SQL Server 2008 Reporting Services cascading prompts.
Here's' a practical example of how Reporting Services (SSRS) in SQL Server 2008 has been modified.  Cascading prompts in SSRS 2005 re-query if the middle of the three parameters changes.  In case you aren't familiar with the term this is where Read More...
Heat maps in SQL Server Reporting Services 2005
Warm up your users this winter with heat maps in SQL Server 2005: This report was created by one of our testing gurus, Patrice Brassard, and uses a to show up a dll he has written in c#. The code was used to simplify the process of applying conditional Read More...
SQL Server 2008 Reporting Services no longer depends on IIS
It sometimes seems impossible to keep everyone happy all the time.  The Reporting Services predict team thought it would be a good idea to remove the dependency on IIS in SQL Server 2008, to make it easier to configure and to reduce the attack surface Read More...
SQL Server 2008 reporting takes off!
CTP5 has only been out for a week and so I was amazed that I got a comment on my blog from a specialist data and planning company operating in the aviation industry in the US.  The company, US Aviation Data and Planning Corp  (USADAP) are migrating Read More...
More Posts Next page »
Page view tracker