Post reply

Advice on going from 2005-2000 reports

  • January 23, 2007 at 3:45 am

    #171986

     

    Hi,

    I am at a bit of an impasse at the moment. I've discovered that 2005 has some RDL that isn't compatible with 2000, and I started trying to manually edit the XML to try and make the 2005 reports compatible with 2000 reports, I got the namespace sorted then hit a load of resizable column definitions....

    Hmmm.. Then I thought, well it might be quicker to rewrite them.

    Then I found out that SQL 2000 Reporting Services isn't compatible with SQL 7.0 (whereas 2005 is), so I'm thinking the only way I can get the £*(%& things to work is to run through a linked server on my 2000 server. This is working OK, but of course it'd be nicer for performance if I could get a direct line into SQL 7.0.

    Any salient thoughts appreciated - I let my no. 2 write this stuff and he went at it with such great gusto he immediately got offered a better job, and I'm left having to get them up quickly without a good grounding or frame of reference.....

    At least nobody can accuse me of not offering good career progression

    Thanks

    Rich

  • January 23, 2007 at 5:46 pm

    #685115

    I'm pretty sure that the only things you need to do in the RDL files is...

    - change the namespace.

    - delete the entries for interactive width and interactive height.

    I've had to do it a few times (don't ask why) and that was all that needed done.

    but of course this assumes you are not using any features that are only available in 2005, Like multi-select parameters.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply