Page 1 of 1

Show Master and multiple detail tables in one page

Posted: Mon Nov 21, 2022 3:38 pm
by philmills

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?


Re: Show Master and multiple detail tables in one page

Posted: Mon Nov 21, 2022 5:21 pm
by arbei

You may use Multiple Master/Detail, see:


Re: Show Master and multiple detail tables in one page

Posted: Mon Nov 21, 2022 5:52 pm
by philmills

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.


Re: Show Master and multiple detail tables in one page

Posted: Mon Nov 21, 2022 6:01 pm
by arbei

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


Re: Show Master and multiple detail tables in one page

Posted: Mon Nov 21, 2022 7:14 pm
by philmills

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.


Re: Show Master and multiple detail tables in one page

Posted: Tue Apr 23, 2024 8:22 pm
by mobhar

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.


Re: Show Master and multiple detail tables in one page

Posted: Tue Apr 23, 2024 9:04 pm
by philmills

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


Re: Show Master and multiple detail tables in one page

Posted: Wed Apr 24, 2024 9:57 am
by mobhar

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.


Re: Show Master and multiple detail tables in one page

Posted: Thu Apr 25, 2024 1:19 am
by Aburajeh

Its work , but

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

and

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


Re: Show Master and multiple detail tables in one page

Posted: Fri Apr 26, 2024 9:03 pm
by philmills

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

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


Re: Show Master and multiple detail tables in one page

Posted: Fri May 17, 2024 2:10 am
by Aburajeh

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?


Re: Show Master and multiple detail tables in one page

Posted: Fri May 17, 2024 9:42 am
by mobhar

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.