This topic is locked

Print Master-Multi detail records

3/10/2011 6:00:37 AM
PHPRunner General questions
fulopattila122 author

Hello,
I'm trying to create a customized print page, that contains data from 3 tables:

  • orders
  • order items
  • used raw materials
    Orders is the master table and the other two are detail tables belonging to the order.

    What I'd like to get as a result is a printing page that contains the selected fields for the order, and the records from the two detail tables.
    Maybe this question has already been answered, but I didn't find a similar solution.

    I already have an order edit page that displays the master fields and the two detail table records, but I can't get it printed.
    Could someone please help me what's the basic concept for this? I don't need a detailed guide how to do it, just the guidelines.
    Thank you

Sergey Kornilov admin 3/10/2011

You can try to create a report in PHPRunner joining all three tables together. Choose grouping by master table primary key so details falls under the record the belong to.
I guess this is the only way to print master record with two details tables on the same page.

fulopattila122 author 3/11/2011

Thank you, I'll give it a try