Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. The Finals: MS Reporting Services vs XtraReports

The Finals: MS Reporting Services vs XtraReports

Scheduled Pinned Locked Moved The Lounge
sql-serverquestioncareercsharpdatabase
40 Posts 20 Posters 2 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    Christopher Duncan
    wrote on last edited by
    #1

    After a little poking around and a lot of help from my friends here, I've come down to two paths. Turns out my hosting company "doesn't support Crystal reports," i.e. if you wanna use that tool, you need stuff installed / configured on the host server. I was happy to hear their response as it validated my assumptions that this particular dog just won't hunt, and perhaps that I'm not quite as stupid as I thought I was (though the jury is still out on that). What my hosting folks (enthusiastic endorsement: Applied Innovations[^]) do support is Sql Server 2005 Reporting Services (SSRS), which they provide for free. Sometimes Free is actually cheaper than Not Free, so I thought I'd give it a try. Looks like all the basics are there. In the Not Free category, I downloaded the eval of XtraReports after hearing good things from many of you. It seems like a quality product and also gets the job done for my web reporting needs. That said, in this particular case $350 appears to be exactly $350 more than Free, which makes me lean towards SSRS. So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

    Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

    J L G E A 8 Replies Last reply
    0
    • C Christopher Duncan

      After a little poking around and a lot of help from my friends here, I've come down to two paths. Turns out my hosting company "doesn't support Crystal reports," i.e. if you wanna use that tool, you need stuff installed / configured on the host server. I was happy to hear their response as it validated my assumptions that this particular dog just won't hunt, and perhaps that I'm not quite as stupid as I thought I was (though the jury is still out on that). What my hosting folks (enthusiastic endorsement: Applied Innovations[^]) do support is Sql Server 2005 Reporting Services (SSRS), which they provide for free. Sometimes Free is actually cheaper than Not Free, so I thought I'd give it a try. Looks like all the basics are there. In the Not Free category, I downloaded the eval of XtraReports after hearing good things from many of you. It seems like a quality product and also gets the job done for my web reporting needs. That said, in this particular case $350 appears to be exactly $350 more than Free, which makes me lean towards SSRS. So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

      Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

      J Offline
      J Offline
      Jorgen Andersson
      wrote on last edited by
      #2

      If you ever decide to change hosting provider you might find it worth $350 to not be locked to SSRS. Just my two cents, for what it's worth.

      C 1 Reply Last reply
      0
      • J Jorgen Andersson

        If you ever decide to change hosting provider you might find it worth $350 to not be locked to SSRS. Just my two cents, for what it's worth.

        C Offline
        C Offline
        Christopher Duncan
        wrote on last edited by
        #3

        Well, I'm not locked to SSRS as I can buy most any of the reporting solutions out there. The only limitation is that I can't use Crystal. Having worked with it a bit, that's not really a heartbreaker. Is there a down side to SSRS that I'm overlooking?

        Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

        J L E 3 Replies Last reply
        0
        • C Christopher Duncan

          Well, I'm not locked to SSRS as I can buy most any of the reporting solutions out there. The only limitation is that I can't use Crystal. Having worked with it a bit, that's not really a heartbreaker. Is there a down side to SSRS that I'm overlooking?

          Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

          J Offline
          J Offline
          Jorgen Andersson
          wrote on last edited by
          #4

          Christopher Duncan wrote:

          Is there a down side to SSRS that I'm overlooking?

          I had the impression (I haven't used it, so don't take my word for it) that SSRS had to be installed on the server just like Crystal Reports. While XtraReports can be added to the Bin directory as a dll.

          C 1 Reply Last reply
          0
          • C Christopher Duncan

            Well, I'm not locked to SSRS as I can buy most any of the reporting solutions out there. The only limitation is that I can't use Crystal. Having worked with it a bit, that's not really a heartbreaker. Is there a down side to SSRS that I'm overlooking?

            Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

            L Offline
            L Offline
            leppie
            wrote on last edited by
            #5

            Christopher Duncan wrote:

            The only limitation is that I can't use Crystal. Having worked with it a bit, that's not really a heartbreaker.

            I dont trust people that think Crystal is good. :)

            xacc.ide - now with TabsToSpaces support
            IronScheme - 1.0 beta 2 - out now!
            ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

            T 1 Reply Last reply
            0
            • J Jorgen Andersson

              Christopher Duncan wrote:

              Is there a down side to SSRS that I'm overlooking?

              I had the impression (I haven't used it, so don't take my word for it) that SSRS had to be installed on the server just like Crystal Reports. While XtraReports can be added to the Bin directory as a dll.

              C Offline
              C Offline
              Christopher Duncan
              wrote on last edited by
              #6

              Yeah, it does have to be installed server side. However, since it already is, and it's free, that's where I'm leaning. If Crystal had been installed and was free, I'd probably have gone with that. XtraReports looks cool, but it doesn't seem to bring $350 of extra benefits to the party. And you know how I love a good party. :)

              Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

              1 Reply Last reply
              0
              • C Christopher Duncan

                After a little poking around and a lot of help from my friends here, I've come down to two paths. Turns out my hosting company "doesn't support Crystal reports," i.e. if you wanna use that tool, you need stuff installed / configured on the host server. I was happy to hear their response as it validated my assumptions that this particular dog just won't hunt, and perhaps that I'm not quite as stupid as I thought I was (though the jury is still out on that). What my hosting folks (enthusiastic endorsement: Applied Innovations[^]) do support is Sql Server 2005 Reporting Services (SSRS), which they provide for free. Sometimes Free is actually cheaper than Not Free, so I thought I'd give it a try. Looks like all the basics are there. In the Not Free category, I downloaded the eval of XtraReports after hearing good things from many of you. It seems like a quality product and also gets the job done for my web reporting needs. That said, in this particular case $350 appears to be exactly $350 more than Free, which makes me lean towards SSRS. So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

                Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #7

                Christopher Duncan wrote:

                So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

                1. Support. DevExpress will even write you a small app. for you to show you how to do what you want to do. 2) Portability. What happens when Applied Innovations is bought by a bigger host who doesn't support SSRS? Or the make a fundamental change to their services that doesn't support other things you require? This has recently happened to me with a fairly large host - I'm in the process of moving to a different one right now. 3) I've yet to find a free product that was really worth it. In this case, if free costs me more than 6 hours of time compared to option B, it's really more expensive than $350. Cheers, Drew.
                C G K 3 Replies Last reply
                0
                • L leppie

                  Christopher Duncan wrote:

                  The only limitation is that I can't use Crystal. Having worked with it a bit, that's not really a heartbreaker.

                  I dont trust people that think Crystal is good. :)

                  xacc.ide - now with TabsToSpaces support
                  IronScheme - 1.0 beta 2 - out now!
                  ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

                  T Offline
                  T Offline
                  ToddHileHoffer
                  wrote on last edited by
                  #8

                  leppie wrote:

                  I dont trust people that think Crystal is good. Smile

                  It is far better than SQL Reporting Services...

                  I didn't get any requirements for the signature

                  J 1 Reply Last reply
                  0
                  • L Lost User

                    Christopher Duncan wrote:

                    So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

                    1. Support. DevExpress will even write you a small app. for you to show you how to do what you want to do. 2) Portability. What happens when Applied Innovations is bought by a bigger host who doesn't support SSRS? Or the make a fundamental change to their services that doesn't support other things you require? This has recently happened to me with a fairly large host - I'm in the process of moving to a different one right now. 3) I've yet to find a free product that was really worth it. In this case, if free costs me more than 6 hours of time compared to option B, it's really more expensive than $350. Cheers, Drew.
                    C Offline
                    C Offline
                    Christopher Duncan
                    wrote on last edited by
                    #9

                    Hey, Drew. Those are all excellent points, thanks. Sounds like DevX has good support, which is important. In fact, that's why I've stayed with my hosting company for so long, because of the level of support they give me. If they suddenly got gobbled up and I had to look for a new home, I don't think I'd have difficulty finding one that supported SSRS, so that's not a cause of worry for me. We certainly share the same evaluation of free, though. :)

                    Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                    L 1 Reply Last reply
                    0
                    • L Lost User

                      Christopher Duncan wrote:

                      So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

                      1. Support. DevExpress will even write you a small app. for you to show you how to do what you want to do. 2) Portability. What happens when Applied Innovations is bought by a bigger host who doesn't support SSRS? Or the make a fundamental change to their services that doesn't support other things you require? This has recently happened to me with a fairly large host - I'm in the process of moving to a different one right now. 3) I've yet to find a free product that was really worth it. In this case, if free costs me more than 6 hours of time compared to option B, it's really more expensive than $350. Cheers, Drew.
                      G Offline
                      G Offline
                      Graham Bradshaw
                      wrote on last edited by
                      #10

                      Drew Stainton wrote:

                      Portability. What happens when Applied Innovations is bought by a bigger host who doesn't support SSRS?

                      You use this[^]

                      L 1 Reply Last reply
                      0
                      • C Christopher Duncan

                        Hey, Drew. Those are all excellent points, thanks. Sounds like DevX has good support, which is important. In fact, that's why I've stayed with my hosting company for so long, because of the level of support they give me. If they suddenly got gobbled up and I had to look for a new home, I don't think I'd have difficulty finding one that supported SSRS, so that's not a cause of worry for me. We certainly share the same evaluation of free, though. :)

                        Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #11

                        Christopher Duncan wrote:

                        that's why I've stayed with my hosting company for so long

                        When you have a good home, it's smart to stay put. I'm currently PO'd at my host of 7 years - they changed the way they handle incoming email which has thrown off a bunch of things I have going. Their new spam prevention measures turn away a lot of legitimate emails and there's no way to turn it off. Their 'help' on the matter is to move my email to a semi-dedicated email server at $100 extra per month. Gee thanks - I'd love to pay 6 times the current cost for something that worked fine a few months ago.

                        Christopher Duncan wrote:

                        I don't think I'd have difficulty finding one that supported SSRS, so that's not a cause of worry for me.

                        That's the main thing. If there's lots of choices out there then it's not a worry. Cheers, Drew.

                        1 Reply Last reply
                        0
                        • C Christopher Duncan

                          After a little poking around and a lot of help from my friends here, I've come down to two paths. Turns out my hosting company "doesn't support Crystal reports," i.e. if you wanna use that tool, you need stuff installed / configured on the host server. I was happy to hear their response as it validated my assumptions that this particular dog just won't hunt, and perhaps that I'm not quite as stupid as I thought I was (though the jury is still out on that). What my hosting folks (enthusiastic endorsement: Applied Innovations[^]) do support is Sql Server 2005 Reporting Services (SSRS), which they provide for free. Sometimes Free is actually cheaper than Not Free, so I thought I'd give it a try. Looks like all the basics are there. In the Not Free category, I downloaded the eval of XtraReports after hearing good things from many of you. It seems like a quality product and also gets the job done for my web reporting needs. That said, in this particular case $350 appears to be exactly $350 more than Free, which makes me lean towards SSRS. So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

                          Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                          G Offline
                          G Offline
                          Graham Bradshaw
                          wrote on last edited by
                          #12

                          I'd go wiht Reporting Services. All those who mutter about lock-in maybe aren't aware that the .rdl format is specified (see the bottom of this page[^]. There's even a CP article[^] about it.

                          L 1 Reply Last reply
                          0
                          • G Graham Bradshaw

                            Drew Stainton wrote:

                            Portability. What happens when Applied Innovations is bought by a bigger host who doesn't support SSRS?

                            You use this[^]

                            L Offline
                            L Offline
                            Lost User
                            wrote on last edited by
                            #13

                            And, like everything else, the reports you developed for SSRS will 'almost' work the way you want. Which is why it's important to pick something you can stick with from the beginning. Cheers, Drew.

                            1 Reply Last reply
                            0
                            • G Graham Bradshaw

                              I'd go wiht Reporting Services. All those who mutter about lock-in maybe aren't aware that the .rdl format is specified (see the bottom of this page[^]. There's even a CP article[^] about it.

                              L Offline
                              L Offline
                              Lost User
                              wrote on last edited by
                              #14

                              Lots of formats are specified. HTML is one of them. It's the different interpretations that cause problems. Cheers, Drew.

                              1 Reply Last reply
                              0
                              • T ToddHileHoffer

                                leppie wrote:

                                I dont trust people that think Crystal is good. Smile

                                It is far better than SQL Reporting Services...

                                I didn't get any requirements for the signature

                                J Offline
                                J Offline
                                Jorgen Andersson
                                wrote on last edited by
                                #15

                                ToddHileHoffer wrote:

                                It is far better than SQL Reporting Services...

                                That's scary!

                                L 1 Reply Last reply
                                0
                                • J Jorgen Andersson

                                  ToddHileHoffer wrote:

                                  It is far better than SQL Reporting Services...

                                  That's scary!

                                  L Offline
                                  L Offline
                                  leppie
                                  wrote on last edited by
                                  #16

                                  Jörgen Andersson wrote:

                                  That's scary!

                                  Very :(

                                  xacc.ide - now with TabsToSpaces support
                                  IronScheme - 1.0 beta 2 - out now!
                                  ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

                                  T 1 Reply Last reply
                                  0
                                  • L leppie

                                    Jörgen Andersson wrote:

                                    That's scary!

                                    Very :(

                                    xacc.ide - now with TabsToSpaces support
                                    IronScheme - 1.0 beta 2 - out now!
                                    ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

                                    T Offline
                                    T Offline
                                    ToddHileHoffer
                                    wrote on last edited by
                                    #17

                                    I'm not sure which is detested more on this site. VB or Crystal...

                                    I didn't get any requirements for the signature

                                    M 1 Reply Last reply
                                    0
                                    • C Christopher Duncan

                                      After a little poking around and a lot of help from my friends here, I've come down to two paths. Turns out my hosting company "doesn't support Crystal reports," i.e. if you wanna use that tool, you need stuff installed / configured on the host server. I was happy to hear their response as it validated my assumptions that this particular dog just won't hunt, and perhaps that I'm not quite as stupid as I thought I was (though the jury is still out on that). What my hosting folks (enthusiastic endorsement: Applied Innovations[^]) do support is Sql Server 2005 Reporting Services (SSRS), which they provide for free. Sometimes Free is actually cheaper than Not Free, so I thought I'd give it a try. Looks like all the basics are there. In the Not Free category, I downloaded the eval of XtraReports after hearing good things from many of you. It seems like a quality product and also gets the job done for my web reporting needs. That said, in this particular case $350 appears to be exactly $350 more than Free, which makes me lean towards SSRS. So, before I dig in and start investing time in a particular platform, I thought I'd just ask the obvious question. Anyone know of $350 worth of reasons why XtraReports would be a better way to go than SSRS?

                                      Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                                      E Offline
                                      E Offline
                                      Ennis Ray Lynch Jr
                                      wrote on last edited by
                                      #18

                                      Doesn't SSRS require the data to be from SQL Server? and the reports to be generated from SQL Server?

                                      Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

                                      C M H J 4 Replies Last reply
                                      0
                                      • E Ennis Ray Lynch Jr

                                        Doesn't SSRS require the data to be from SQL Server? and the reports to be generated from SQL Server?

                                        Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

                                        C Offline
                                        C Offline
                                        Christopher Duncan
                                        wrote on last edited by
                                        #19

                                        We use Sql Server. :)

                                        Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                                        E 1 Reply Last reply
                                        0
                                        • C Christopher Duncan

                                          We use Sql Server. :)

                                          Christopher Duncan Author of The Career Programmer and Unite the Tribes www.PracticalUSA.com

                                          E Offline
                                          E Offline
                                          Ennis Ray Lynch Jr
                                          wrote on last edited by
                                          #20

                                          Well yes so do I but what I was getting at is that you have to run the report from SQL Server. Or so I thought. I really like my reporting tool to be independent of the data source so the data can be culled from multiple sources or processed, etc.

                                          Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

                                          C 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups