Hi Paul, On Wed, Sep 16, 2009 at 4:33 PM, Paul McNett <[email protected]> wrote:
> Hi Mike! > > > I am researching report programs for Python and haven't been able to find > > anything that works for my current project. I have attached a mockup of a > > current report we do with Crystal Reports, but we don't want to reply on > > that program and it doesn't do everything we want. > > The list software strips attachments. You could open a trac ticket at: > > http://trac.dabodev.com > > You'll first need to register (easy). Make it a ticket-type of > 'discussion'. Then > attach whatever you want to the ticket. > > > > Anyway, the Earnings and Deductions columns come from different tables. > > There are also several fields that come from one or more other tables. > Does > > the Dabo Report Designer support multiple table/database queries for data > > sources? The video doesn't really show one way or the other. Thanks! > > Unlike Crystal, Dabo's report design is completely disconnected from data. > Nowhere in > the rfxml file is there a reference to data source or the like. > > Here's what the runtime report writer expects to produce a report: > > 1) a report design (rfxml file as designed in the report designer) > 2) a single data 'cursor'. > > A cursor is defined as a sequence of dicts of fieldname:fieldvalue pairs. > > So your code will need to flatten the data into this single cursor before > sending it > to the report writer at runtime. > > So the answer is a qualified 'yes'. > > Paul > > > Your nice video did mention that Report Designer didn't have a connection to a database, but it mentioned that there was a cursor object, so I guess that threw me off. A friend of mine said I could try flattening it as well. If I go that route, I may continue messing with Geraldo... By the way, does the Report Designer provide some kind of grouping functionality so I can keep a "row" of data from being split over two pages? When I was trying to do this by hand with reportlab, it kept splitting my nested tables at awkward spots. Thanks! ----------------- Mike Driscoll Blog: http://blog.pythonlibrary.org --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
