On Thursday, September 09, 2010 09:59:47 am Jeff Johnson wrote: > 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]
+1 I too have used Paul's way for the last twenty years and never saw an issue. The thing I see Crystal doing is the same but in the background. IOW when Crystal displays the report it uses one table/cursor (with some added stuff like fk links). But if you like Crystal you can still use it from Dabo (win32). But I like openRPT better. Johnf _______________________________________________ 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]
