2. PHPRunner General questions
  3. Reporting more than one chile data table
This topic is locked

Reporting more than one chile data table

 		8/29/2011 07:21:13
PHPRunner General questions
J
 jasonfrew author

I have 3 tables i would like to connect in a report.
Table Inquiries is connected to table Notes and table products by the Urn in table Inquiries.
I would like to be able to display some information from table inquiries (the grouped by data), and have a list of products under this and then the notes under the products.
Is this even possible. If not what do you think would be the best way to display the information
Thanks in advance
J
 		jasonfrew author 8/31/2011

Would it be more possible to have a second window or an iframe?
Sergey Kornilov admin 9/1/2011

I guess you need to implement this kind of functionality manually.
You can build a join SQL Query that pulls master and all child tables and then insert subheaders between groups of records. Check this article for inspiration: http://www.asprunner.com/forums/topic/6221-how-to-insert-a-subheader-between-groups-of-records/
J
 		jasonfrew author 9/1/2011

Thanks
I dont think this is quite what im after.
The SQl is fairly straight forward. I've 5 tables pulling information to group in the way i need the first data set. and 2 tables pulling the info together for the second data set.

I cant bring the Query together i any other way.
luckily the notes table has very little info in it.
The solution the the problem is to add on to the product list table the notes fields. Create a custom view of the product table but only show the notes fields

Then when creating the report sort the report by ISNULL on the note field. and arrange the Fields on the report in the layout i require.
This gives me the format im looking to achieve. ITs not elegant in the slightest. but until i find a better way of producing the display im looking for it will serve its purpose.
Thanks for all the advice guys. if i find a better way i will post