Group Rows in List Pages

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
elieba
User
Posts: 21

Group Rows in List Pages

Post by elieba »

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
User
Posts: 9498

Post by arbei »


elieba
User
Posts: 21

Post by elieba »

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
User
Posts: 9498

Post by arbei »

  1. Make sure you have installed the system requirement WebView2 Runtime, you may install v124.0.2478.
  2. 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.
  3. 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
User
Posts: 21

Post by elieba »

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
User
Posts: 9498

Post by arbei »

arbei wrote:

  1. Make sure you have installed the system requirement

The system requirements page includes the link for WebView2 Runtime.

Also read Migrating to v2023.

You may also install by using the MicrosoftEdgeWebview2Setup.exe shipped with PHPMaker (you can find it under C:\Program Files (x86)\PHPMaker 2024).

You need to learn by writing your own Custom Template.


Post Reply