• User-settable properties in Reporting Services

    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

    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

    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.