2. PHPRunner General questions
  3. Can anyone guide me with a SImple Work Order Report...
This topic is locked

Can anyone guide me with a SImple Work Order Report...

 		5/26/2010 9:46:27 AM
PHPRunner General questions
X
 xahama author


Real simple:
master.field1 master.field4

master.field2 master.field5

master.field3 master.field6

___
detail.field1 detail.field2 detail.field3
[font="Comic Sans MS"]Should I Add Report or Add View? If I had a simple example I could figure it out.
A
 		ann 5/27/2010

Hi,
create a report for the Master table on the Datasource tables tab. Then proceed to the Query Designer mode on the Edit SQL query tab. Click Add Table button and choose Details table. Check the fields you want to display in the report and create a link between two tables as you did on the Datasource tables tab.

For more information: http://xlinesoft.com/phprunner/docs/query_designer.htm