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)
______________________________________