Master detail and detail with no master

Comments

• technisoft

  April 2013 edited 6:27AM

  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.
  
• collectivefriction

  April 2013 edited 6:27AM

  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?