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. General Programming
  3. Design and Architecture
  4. in search of a better printing/reporting mechanism

in search of a better printing/reporting mechanism

Scheduled Pinned Locked Moved Design and Architecture
questioncsharpdatabasedesignbusiness
4 Posts 3 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.
  • G Offline
    G Offline
    giddy_guitarist
    wrote on last edited by
    #1

    hi, This should hopefully be my last question about my future hotel app. The first time i built it, i made an insane amount of classes to encapsulate printing, and even then printing was messy. I thought I could use crystal reports, but did a few tests and ran into some problems. It seems like its a nice thing when you want to just pull information straight from your database and print it but turns out pretty cumbersome when I want to use my own business objects as data for a report. I know I can add a .NET object to the report via the database expert.But, there are problems when I need data from more than one object on a report. Also, I'm not quite sure how I could feed my own data to a chart in a report. Is there any other printing/reporting scheme I can use? Or is there a particular design used with crystal reports, Printing is a very essential part of my app. Thanks so much Gideon

    L M 2 Replies Last reply
    0
    • G giddy_guitarist

      hi, This should hopefully be my last question about my future hotel app. The first time i built it, i made an insane amount of classes to encapsulate printing, and even then printing was messy. I thought I could use crystal reports, but did a few tests and ran into some problems. It seems like its a nice thing when you want to just pull information straight from your database and print it but turns out pretty cumbersome when I want to use my own business objects as data for a report. I know I can add a .NET object to the report via the database expert.But, there are problems when I need data from more than one object on a report. Also, I'm not quite sure how I could feed my own data to a chart in a report. Is there any other printing/reporting scheme I can use? Or is there a particular design used with crystal reports, Printing is a very essential part of my app. Thanks so much Gideon

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

      Previously I have suggested and recommended Logi Reports as a viable alternative to Crystal Reports. Get it FREE here http://www.freereporting.com/[^] Caution, it is a fairly large download and there are plenty of tutorials and samples there also.

      1 Reply Last reply
      0
      • G giddy_guitarist

        hi, This should hopefully be my last question about my future hotel app. The first time i built it, i made an insane amount of classes to encapsulate printing, and even then printing was messy. I thought I could use crystal reports, but did a few tests and ran into some problems. It seems like its a nice thing when you want to just pull information straight from your database and print it but turns out pretty cumbersome when I want to use my own business objects as data for a report. I know I can add a .NET object to the report via the database expert.But, there are problems when I need data from more than one object on a report. Also, I'm not quite sure how I could feed my own data to a chart in a report. Is there any other printing/reporting scheme I can use? Or is there a particular design used with crystal reports, Printing is a very essential part of my app. Thanks so much Gideon

        M Offline
        M Offline
        Mycroft Holmes
        wrote on last edited by
        #3

        I used CR for many years and have always pulled the data from the database - just the way I design things I guess. All reports were serviced by a stored procedure so to deploy a new report required a proc and a RPT file, no recompile required. A hotel app will require an enormous number of reports and each customer will want custom reports done. I liked it BC you could deploy it fairly simply (as opposed to Reporting Services) in a commercial app. I now do corporate work and use RS exclusively.

        Never underestimate the power of human stupidity RAH

        G 1 Reply Last reply
        0
        • M Mycroft Holmes

          I used CR for many years and have always pulled the data from the database - just the way I design things I guess. All reports were serviced by a stored procedure so to deploy a new report required a proc and a RPT file, no recompile required. A hotel app will require an enormous number of reports and each customer will want custom reports done. I liked it BC you could deploy it fairly simply (as opposed to Reporting Services) in a commercial app. I now do corporate work and use RS exclusively.

          Never underestimate the power of human stupidity RAH

          G Offline
          G Offline
          giddy_guitarist
          wrote on last edited by
          #4

          thanks so much for replying, but someone on the Microsoft newsgroups gave me a work around with CR. I make a new typed dataset for each report that I want to create, I have seperate tables for each chunk of data I need printed.Then I design a new report, when I need the data printed I set the datasource to a new instance of the typed dataset with all my data in it! It works like a charm, also for situations where I've needed Multiple bunches of information all over the place, I use subreports, somehow the dataset passed to the first report is automatically passed to the subreports too, so it works pretty well. Thanks!

          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