Show Master and multiple detail tables in one page

philmills · Post by **philmills** » Mon Nov 21, 2022 3:38 pm

I have a master table containing basic student data (name, class etc)
I have 3 detail tables containing extended data from different personnel regarding the student (class teacher, subject teachers, support staff)
I need to create something like a report card which combines together the data from the 3 tables into one page.
Something like this view from tutorial

But i have multiple detail tables, and I don't want them shown in tabs but rather one table below the other.
How can I do that?

arbei · Post by **arbei** » Mon Nov 21, 2022 5:21 pm

You may use Multiple Master/Detail, see:

Table Setup -> List -> Multiple Detail Tables,
Tutorial - Master/Detail

philmills · Post by **philmills** » Mon Nov 21, 2022 5:52 pm

I have that already. The problem was:
i have multiple detail tables, and I don't want them shown in tabs but rather one table below the other.

arbei · Post by **arbei** » Mon Nov 21, 2022 6:01 pm

Then you can only customize the generated code or add JavaScript code to rearrange the HTML.

philmills · Post by **philmills** » Mon Nov 21, 2022 7:14 pm

I discovered that when exporting to pdf the tables are already below one another.
This is fine for what I need, just need to format the output a little.

Aburajeh · Post by **Aburajeh** » Tue Apr 23, 2024 6:37 pm

Philmills
Hello

any update for solve its ?!

Thank you

philmills · Post by **philmills** » Tue Apr 23, 2024 8:16 pm

No, I haven't looked at this again, because the PDF export is fine for what I need.

mobhar · Post by **mobhar** » Tue Apr 23, 2024 8:22 pm

You may simply display Master/Multiple-Detail tables simply by including the detail tables name in the URL, and remember to disable Multiple detail tables option from Table setup of your master table, if you don't want to display each detail table separated in each Tab control.

For example, from the demo project, you may simply type this URL from your browser:

http://localhost/demo2024/ordersview/10251?showdetail=orderdetails,order_details_extended

It will show you both Order Details and Order Details Extended detail table below one to each other. To print it, then you may simply click on Printer Friendly (Export to Print) menu above the page.

philmills · Post by **philmills** » Tue Apr 23, 2024 9:04 pm

Can Multiple detail tables be disabled for View only?
I would like them to be available in list via the preview extension, but when using printer friendly view, the tables would not be in tabbed form

mobhar · Post by **mobhar** » Wed Apr 24, 2024 9:57 am

I don't think so.

The closest approach for your case is to separate between the Printer Friendly version page and the normal Master/Detail View page. You may create a link in the normal Master/Detail View page to point out to separate Printer Friendly URL version.

philmills · Post by **philmills** » Wed Apr 24, 2024 4:13 pm

I think that soluton is good enough for me.
I'll try to get that working

Aburajeh · Post by **Aburajeh** » Thu Apr 25, 2024 1:19 am

Its work , but

1- PDF export with arbic litters as "?????"

and

2- Detail tables splite evrey one new page not one page.

philmills · Post by **philmills** » Fri Apr 26, 2024 9:03 pm

About the pdf export, see this thread:
viewtopic.php?t=58899

About the detail tables splitting, see this thread:
viewtopic.php?t=54937