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 tutorialBut 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?
You may use Multiple Master/Detail, see:
- Table Setup → List → Multiple Detail Tables,
- Tutorial - Master/Detail
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.
Then you can only customize the generated code or add JavaScript code to rearrange the HTML.
I discovered that when exporting to PDF, the tables are already below one another.
PDF export is fine for what I need, just need to format the output a little.
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_extendedIt 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.
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
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.
Its work , but
1- PDF export with arabic litters as "???"and
2- Detail tables splite every one new page not one page.
About the pdf export, see this thread:
$doc->Filename UTF-8 characters (v2023) the detail tables splitting, see this thread:
Master/Detail export - Add table names
mobhar wrote:
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.
hello
how to create a link in the normal Master/Detail View page to point out to separate Printer Friendly URL version?
You may use Page_DataRendering server event that belongs to the View Page of your master table.
Just check the current page id = view and check also the showdetail is not a blank string, and if it meets the criteria, then write your code to display the link to the related printer friendly page.
Can we do it for custom template view page? I mean can such pages also be exported?
I don’t think so. Custom Template does not support Export Data. You may read the documentation, see Important Notes → 7. Data will be exported in original tabular format only.