Post reply

SQL Server Reporting Services 2008 R2 Toolbox Item

  • November 23, 2011 at 8:11 pm

    #263386

    Hi my name is Ryan, I have some question 'bout SSRS 2008 R2. I have SSRS 2008 R2 in my laptop, I see, it have some new interesting tools in the toolbox such as Maps, Indicator, databar, and sparkline. i've tried it in my laptop and it was quite good. In the other hand I've got SSRS 2008 on my production server, not 2008 R2 but just 2008, so what I want to ask is, can I add the new tools from the 2008 R2 like maps, indicator etc from my laptop to my SSRS 2008 toolbox in my production server, can I just choose item from my SSRS 2008 toolbox and add the SSRS 2008 R2 tools or should I just upgrade the SQL 2008 on my production server to 2008 R2, can you guys give me some solution ?

    Thanks before 🙂

  • November 24, 2011 at 1:00 am

    #1412573

    Ryan,

    in order for you to be able to use the new features on your production server you need to upgrade the server to R2.

    Also in case you create a report on your laptop using the new R2 features you cannot deploy it to your production server. Actually the deployment might work, but you cannot run the reports. Reason for this is a change in the xml schema used in the .rdl files.

    Here you find a pretty good overview of all the differences between 2008 and 2008 R2

    http://www.simple-talk.com/sql/reporting-services/new-features-in-reporting-services-2008-and-2008-r2/

    [font="Verdana"]Markus Bohse[/font]

  • November 24, 2011 at 8:09 pm

    #1412832

    Hi Markus, thanks for replying, and of course thanks for the advice I'll look into that. By the way, about ur advice to upgrade my production server sql server to R2, I already have some report made using the SSRS SQL server 2008 not the R2 and the reports already deployed to the SSRS Report Server and already running, so what will happen to all my reports if I upgrade my server to SQL Server 2008 R2, will it be ok just fine or it will not run at all ?

    Thanks in advance 🙂

  • November 25, 2011 at 12:44 am

    #1412861

    Since I've never done a in-place upgrade of SSRS I can't say for sure if everything will keep working.

    But here you should find all the information you need:

    http://technet.microsoft.com/en-us/library/ms143747.aspx

    [font="Verdana"]Markus Bohse[/font]

  • November 25, 2011 at 2:14 am

    #1412895

    Markus, thanks for the reply, I've checked the link you gave me, but I still don't have any confidence yet to upgrade my SQL Server 2008 to the R2, of course I already have a job in the SQL Server to do some backup for the SystemDB's including the report server DB, but i'm still not sure about the cause if I upgrade the SSRS will my already made report still gonna run on the new SSRS 2008 R2 environment. Probably I should do some more searching, but if anyone here have another suggestion or solution for my problems, please feel free to drop in.

    Thanks 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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