Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Master-Detail-Template

edited September 2002 in End User
I try to built an end-user-application like \...\II. Applicatons\03.
End-User with Data Dictionary. I have create a master-detail-report for
invoices, the preview looks fine, and so i save it to the database. But if i
load the template in my program, every master (order) has all the same
details (items of all orders). What do i make wrong? I work with Delphi 5
and Paradox and try to understand RB 6.03. Simple lists in the preview of
my beginning end-user-application and in my application with
LoadFromDatabase looks fine.

Comments

  • edited September 2002
    When you say you load it to the program, do you have datapipelines on the
    form that may be getting hooked up to the report? Are the subreport
    connected to the respective detail dataviews? They should be assigned since
    they were saved down with the dataviews in the template.

    Can you create a new test program and see if you can load it into that one?
    If you can and it still doesn't work, then check the SQL that is being
    generated after you load the template to your program. Use the designer and
    DADE at runtime to do this (Add daIDE and daDBBDE to you uses clause).
    Control-mouse click over the detail dataview. You should get a window and
    you should see the SQL in this window that is built to support the master
    detail dataset for that dataview. How does this SQL look in the detail
    dataviews?


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.