On 09/09/2010 09:55 AM, Nate Lowrie wrote: > On Thu, Sep 9, 2010 at 12:20, Paul McNett<[email protected]> wrote: > >> On 9/9/10 9:11 AM, Nate Lowrie wrote: >> >>> Does anyone have a sample report for an order invoice? >>> >> See dabo/dabo/lib/reporting_tests/invoice >> >> > Missed that. It looks good though I am not sure how the parent child > relationship functions... > > I am assuming that the orderlines/order tables need to be > de-normalized to a single set? > > >>> Also, a report >>> that can pull from 2 separate tables (not a parent/child >>> relationship)? >>> >> What you should do is denormalize your data into one big unioned dataset. >> Feed that >> to the Cursor property. >> > That could get really ugly since I wanted to pull multiple rows for > each table and one of the tables had a parent child relationship on > it. Why this design instead of allowing for multiple tables like > Crystal? > > On another note, is there a way to pass variables into a report or to > set report variables dynamically? > _______________________________________________ > Nate: I've used Paul's technique for 20 years since FPD2.0. If a cursor gets too complicated, I create a temporary table and populate the records.
Jeff ------------------- Jeff Johnson [email protected] _______________________________________________ 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]
