2. PHPRunner General questions
  3. report on Master detail detail
This topic is locked

report on Master detail detail

 		6/8/2011 8:46:11 AM
PHPRunner General questions
W
 wlueckemann author

Hallo,
my database has the structure of Master detail1 detail11 detail12 detail13
Detail1 depends on master; Detail11, Detail12 and Detail13 are depending on Detail1
Master

I

Detail1

I

--------------------------------------------

I I I I

Detail13 Detail12 Detail13
Is there a way to show this in one report?
Walther
Sergey Kornilov admin 6/8/2011

Walther,
I guess you can use JOIN SQL Query to join data from all details tables and show them as a single data line in report.
W
 		wlueckemann author 6/8/2011

Hi Sergey,
It is more than a sentence in the tables, the join is therefore the cross product, and thus all data are coming several times.
(I hope you understand my direct German->English)
Best Regards
Walther
Sergey Kornilov admin 6/8/2011

Walther,
I guess I understand what you saying. We would need to take a look at your database structure in order to provide a viable solution.
I would suggest to post your current application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.