ReportViewer 2010 remote processing requires RS 2008 or later

Friday, 7 May 2010

I had an idea today that using the newly released ReportViewer 2010 controls might help with an unusual rendering issue we're having with a web page when displaying very large reports.

Turns out that you can use Report Viewer 2010 with Visual Studio 2008, though I did have to copy the files out of the GAC. Make sure you update the assembly references in the project file, web.config and also any .aspx pages so that they refer to Version=10.0.0.0.

Firing up the site to view one of the reports then resulted in the following error message:

"Remote report processing requires Microsoft SQL Server 2008 Reporting Services or later"

Checking the current MSDN documentation for Configuring ReportViewer for Remote Processing does indeed state that "to use a server report, you must have access to a SQL Server 2008 or later Reporting Services report server". Contrast that with the Visual Studio 2008 version of the same page which says SQL Server 2005 Reporting Services was the minimum.

Unfortunately in this case Reporting Services are still on 2005, but when that changes, using Report Viewer 2010 will be a viable option.

User-settable properties in Reporting Services

Tuesday, 4 May 2010

SQL Server Reporting Services reports have a number of properties that can be obtained via the GetProperties web method.

The full list of properties is documented in SQL Books Online in Report Server Item Properties. What it fails to mention is that some of these items are read-only. Try passing them in via CreateReport or SetProperties and you'll just get an exception for your trouble.

By trial-and-error (mostly error!) against an instance of the SQL 2005 Reporting Service Web Service I discovered that the following properties are user-settable:

Property User-settable
CreatedBy  
CreationDate  
Description Yes
Hidden Yes
ID  
ModifiedBy  
ModifiedDate  
Name  
Path  
Size  
Type  
VirtualPath  
Language  
ReportProcessingTimeout Yes
ExecutionDate  
CanRunUnattended Yes
HasParameterDefaultValues  
HasDataSourceCredentials  
IsSnapshotExecution  
HasScheduleReadyDataSources  
MimeType  

CodeCamps and other events

Monday, 3 May 2010

Looking to learn new things, network with colleagues, be inspired and maybe even have a bit of fun? Here's a list I've compiled of upcoming events. I'm aiming to attend and speak at CodeCampSA. I'll have to see whether I get to any of the others!

June 1-2nd

REMIX 10 - Australia's version of Microsoft's MIX conference - which has a particular focus on web design and development.

July 24-25th

Heading into its fourth year, CodeCampSA is on again this July. Whilst it's always been a bit smaller than the Wagga event (see below), it's always really encouraging to see a solid contingent of interstate speakers volunteer their time to come and support us locals to put on a great training weekend.

August 24-27th

Tech-Ed Australia, back again at the Gold Coast Exhibition Centre.

October 9-10th?

SQL Down Under Code Camp is traditionally held on the weekend after the October long weekend. Keep an eye on Greg Low's blog for any announcements.

November 8-11th

I'm told any SQL enthusiast worth their salt will be aiming to attend the 2010 PASS Summit. True, it is in Seattle, but apparently that has the nice side effect of allowing a lot of the Microsoft SQL team to attend and speak too.

November 20-21st

April has traditionally been the time keen .NET developers head to Wagga Wagga for CodeCampOz, but Mitch has announced that Australia's original Code Camp will be held this year in November.

Updated 5th May to add REMIX

Narelle is blogging again

Tuesday, 27 April 2010

Narelle has dusted off her blog and posted some new content after a short break of 5 years!

Subscribe to her feed if you're interested in a bit of craft and the odd recipe or two.

Seeing how the other half live

Tuesday, 27 April 2010

Over the weekend I had the chance to sit down with a friend who is studying a computer science degree and give some suggestions on their software engineering assignment. What made this interesting was that the assignment was in Java.

I hadn't used Java since the early days of Java 1.0/1.1 when we used it to create some browser applets to be used in teaching electrical engineering at UniSA, so I wasn't sure how much help I was going to be.

As someone who spends most of his professional life using Microsoft tools, I was pleasantly surprised to see that most concepts I use with C# and Visual studio have equivalents in Java language and IDE (NetBeans in this instance). That Java and C# are similar shouldn't be any surprise, but I certainly gained an appreciation of how C# has learned from it's older brother. It was only an hour or two so the comparison is certainly not extensive, but it is interesting to observe some of the subtle variations:

I think there's probably more the same than different, and I can understand how you could reasonably easily swap from one environment to another.

It did cause me to wonder how these languages and environments are going to change over the next few years. It does seem ironic that in many ways Microsoft may have some advantages in being able to innovate their language more easily than Oracle/Sun. On the other hand I think it is very healthy for there to be competition to encourage new features that will improve the development experience in both camps.

In the end we made some good progress on the assignment, though in my opinion it seemed it was trying to force the use of a particular design pattern into a scenario which didn't really need it, which probably ended up being more confusing and less useful to the students.