Master detail and detail with no master

collectivefrictioncollectivefriction
edited April 2013 in FastReport 4.0
I have two tables with amaster detail relationship.

However:

some of the records in the master table have no corresponding detail record(s)

some of the records in the detail table have no corresponding entry in the master table.

I would like to print a report that contains all of the master records with their corresponding detail records (if any), this bit is easy - but then follow this with all of the (for want of a better word) orphan detail records.

Any ideas?

Comments

  • technisofttechnisoft
    edited 7:54AM
    collectivefriction wrote: »
    I have two tables with amaster detail relationship.

    However:

    some of the records in the master table have no corresponding detail record(s)

    some of the records in the detail table have no corresponding entry in the master table.

    I would like to print a report that contains all of the master records with their corresponding detail records (if any), this bit is easy - but then follow this with all of the (for want of a better word) orphan detail records.

    Any ideas?
    Make 2 reports, merge into one.
  • collectivefrictioncollectivefriction
    edited 7:54AM
    Thanks, although that will work it is not ideal in my situation.

    Is it possible to create a master detail report programatically within FR? By this I mean if I have two tables that are not defined in my application as having a master detail relationship, but do have a common column. Can I do the master-detail link in FR rather than in the dataset itself?

    Basically I have a complicated database with many tables and I am trying to give my users the flexibility of designing their own report without constrianing them in any way.

    Hope this is clear?

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024