Group Rows in List Pages

elieba · Post by **elieba** » Thu May 23, 2024 5:37 am

i have a report to do with titles which I created them as columns in the table
to need to put three columns as titles or group by.
how I can do it in phpmaker

TITLE1 column: Will the candidates for the Master of Science degree in the School of Arts & Sciences please come forward. (School of Arts & Sciences is the school)
TITLE2 column: CANDIDATES FOR THE DEGREE OF Master of Science (Master of Science is the Degree column)
TITLE3 Column: Requirements completed in Summer 2023 (Summer 2023 is the term column)
EFULLNAME column: Jana Bilal El Nakouzi
AFULLNAME column : جنى بلال النقوزي

AS
   SELECT DISTINCT 	CONCAT("Will the candidates for the ", `studentslist`.`Degree`, " degree in the School of ", School, " please come forward.") AS `Title1`,
					CONCAT("CANDIDATES FOR THE DEGREE OF ", `studentslist`.`Degree`) AS `Title2`,
					CONCAT("Requirements completed in ", `studentslist`.`Term`) AS `Title3`,
                   CONCAT(`studentslist`.`FName`, " ", `studentslist`.`MName`, " ", `studentslist`.`LName`) AS `EFullName`,
                   `studentslist`.`AFullName` AS `AFullName`,
                   `studentslist`.`Campus` AS `Campus`,
                   `studentslist`.`School` AS `School`,
                   `studentslist`.`Degree` AS `Degree`,
                   `studentslist`.`Term` AS `Term`

report layout:

Will the candidates for the Master of Science degree in the School of Arts & Sciences please come forward.

CANDIDATES FOR THE DEGREE OF			
Master of Science			
		
Requirements completed in Summer 2023			
	Jana Bilal El Nakouzi		جنى بلال النقوزي
	Sara Hassan Tohme		ساره حسان طعمه


Group Rows in List Pages

Field 1 Field 2 Field 3 Field 4

Group 1 - (1 record)
______________________________________
Data Data Data Data
______________________________________
Group 2 - (3 records)
______________________________________
Data Data Data Data
Data Data Data Data
Data Data Data Data
______________________________________
Group 3 - (2 records)
______________________________________
Data Data Data Data
Data Data Data Data
______________________________________
Group 4 - (1 item)
______________________________________

arbei · Post by **arbei** » Thu May 23, 2024 9:38 am

You may use Custom Template for Summary Report.

elieba · Post by **elieba** » Thu May 23, 2024 5:01 pm

i am trying to do the same, but when I opened the custom template header I wasn't able to write a code and I pressed on code repository and when pressing on add nothing happened.

arbei · Post by **arbei** » Thu May 23, 2024 5:18 pm

Make sure you have installed the system requirement WebView2 Runtime, you may install v124.0.2478.
Close and reopen PHPMaker, go to the HTML tab, make sure the preview panel (which also uses WebView2) is working, then go to the Code tab, the editor should be also working. If not, you may choose to use the "Classic" code editor.
The Code Repository is a repo for you to add code to the code editor, select an item and click the "Add" button to add the code to the editor.

elieba · Post by **elieba** » Thu May 23, 2024 6:22 pm

where i can find WebView2 Runtime v124.0.2478? under phpmaker or an external software?

do you have a small sample phpmaker project having this code to do a similar thing for me.

many thanks

arbei · Post by **arbei** » Thu May 23, 2024 6:46 pm

arbei wrote:

Make sure you have installed the system requirement

The system requirements page includes the link for WebView2 Runtime.