2. PHPRunner General questions
  3. How can I create an invoice report?
This topic is locked

How can I create an invoice report?

 		11/10/2009 2:47:01 PM
PHPRunner General questions
F
 frocco author

Hello,
I have 4 tables.
Table1 to Table2 (1 to 1)

Table1 to Table3 (1 to 1)

Table3 to Table4 (1 to many)
How can I create an invoice report, 1 per page?
Thanks
Frank
J
 		Jane 11/11/2009

Frank,
you can do the following:

  1. join all tables on the Edit SQL query tab,
  2. combine fields from table1 into one custom field. Make the same for table2 and table3.
  3. select three custom fields as group fields on the Report: Group fields tab.