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. Other Discussions
  3. IT & Infrastructure
  4. Generating Reports

Generating Reports

Scheduled Pinned Locked Moved IT & Infrastructure
databasesysadminhelpquestion
6 Posts 2 Posters 0 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.
  • M Offline
    M Offline
    MadsJ
    wrote on last edited by
    #1

    Hi Does any of you have experience with selecting a tool for generating reports? We have a large server farm with approx. 250 connecting locations, and each of the locations have approx. 4 computers. The locations needs to able to print data from a number of SQL Servers on the server farm. The data just need to be printed as text in columns, and with group boxes around some of the text. We have looked at Crystal Reports 9, but it offers a lot more than we need and it is very expensive. Thanks for your help, Mads

    I 1 Reply Last reply
    0
    • M MadsJ

      Hi Does any of you have experience with selecting a tool for generating reports? We have a large server farm with approx. 250 connecting locations, and each of the locations have approx. 4 computers. The locations needs to able to print data from a number of SQL Servers on the server farm. The data just need to be printed as text in columns, and with group boxes around some of the text. We have looked at Crystal Reports 9, but it offers a lot more than we need and it is very expensive. Thanks for your help, Mads

      I Offline
      I Offline
      Ian Darling
      wrote on last edited by
      #2

      Crystal is expensive, and I'm not that impressed with it. ASP.NET seems pretty good (I'm using it for the reports on a project), and there's a Reports Starter pack that contains example reports. That would be a good place to start. HTH -- Ian Darling

      M 1 Reply Last reply
      0
      • I Ian Darling

        Crystal is expensive, and I'm not that impressed with it. ASP.NET seems pretty good (I'm using it for the reports on a project), and there's a Reports Starter pack that contains example reports. That would be a good place to start. HTH -- Ian Darling

        M Offline
        M Offline
        MadsJ
        wrote on last edited by
        #3

        Thanks for your reply. Unfortunately, ASP.NET is not usable for the project. The clients are "smart clients" that connect to the servers through web services. We want to implement report printing this way: The user press a button on a windows form in the smart client, and a print dialog is shown. On the dialog it shall be possible to select: print preview and print. Mads

        I 1 Reply Last reply
        0
        • M MadsJ

          Thanks for your reply. Unfortunately, ASP.NET is not usable for the project. The clients are "smart clients" that connect to the servers through web services. We want to implement report printing this way: The user press a button on a windows form in the smart client, and a print dialog is shown. On the dialog it shall be possible to select: print preview and print. Mads

          I Offline
          I Offline
          Ian Darling
          wrote on last edited by
          #4

          Madsj wrote: Unfortunately, ASP.NET is not usable for the project. The clients are "smart clients" that connect to the servers through web services. Well, to be slightly contrarian, there is still room to use ASP.NET. a) It can be embedded into your client application - there is an article on CP that demostrates how to do it. b) You could pass the relevant parameters in the URL to the pages, such as which web service to collect the data from. From either you can use IE (or other suitable browser component) to display the reports and print-preview them. If you use thead, tbody and tfoot HTML tags in the rendered output, you can even get page headers and footers (in IE, anyway). Otherwise, you might try Business Objects - given they are buying CrystalDecisions, they probably have a compteing toolset. HTH -- Ian Darling

          M 1 Reply Last reply
          0
          • I Ian Darling

            Madsj wrote: Unfortunately, ASP.NET is not usable for the project. The clients are "smart clients" that connect to the servers through web services. Well, to be slightly contrarian, there is still room to use ASP.NET. a) It can be embedded into your client application - there is an article on CP that demostrates how to do it. b) You could pass the relevant parameters in the URL to the pages, such as which web service to collect the data from. From either you can use IE (or other suitable browser component) to display the reports and print-preview them. If you use thead, tbody and tfoot HTML tags in the rendered output, you can even get page headers and footers (in IE, anyway). Otherwise, you might try Business Objects - given they are buying CrystalDecisions, they probably have a compteing toolset. HTH -- Ian Darling

            M Offline
            M Offline
            MadsJ
            wrote on last edited by
            #5

            But if we use a browser to display the reports etc., we need to test our app. we a zillion browsers. And since we hate testing as much as anyone else, we really want to avoid it. Instead, we have made the selection to use the Crystal Report for .NET that is included with Visual Studio .NET. Performance might not be extraordinary but we save a lot of money. Ian, thanks for your help. Mads

            I 1 Reply Last reply
            0
            • M MadsJ

              But if we use a browser to display the reports etc., we need to test our app. we a zillion browsers. And since we hate testing as much as anyone else, we really want to avoid it. Instead, we have made the selection to use the Crystal Report for .NET that is included with Visual Studio .NET. Performance might not be extraordinary but we save a lot of money. Ian, thanks for your help. Mads

              I Offline
              I Offline
              Ian Darling
              wrote on last edited by
              #6

              No problem :-) Glad I could be of help. -- Ian Darling

              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