Browse by Tags
All Tags »
Reporting Services (RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
