This topic is locked

How generate a list ..

10/3/2020 6:15:08 AM
PHPRunner General questions
J
Jan author

Hello everyone,

I would like to generate a list of the students who enroll in a course.

I have two tables:

1 The enrolled students

2 the lesson dates and the names of the courses
In the table "courses" is the name of the course, the date, the description of the lesson. That table is visible in a grid. I placed a button in the grid. The intention is when I press the button,

that there will be a visible with the students who attend the class on the indicated date and class time.
The question is, how can I fix this? The generated list is dynamic,

because it depends on the name of the course, and also the date.
Can I make a "view" for this? Which code should be placed in the button? Is an example of this?

Thanks in advance for any help.

HJB 10/3/2020

https://xlinesoft.com/phprunner/docs/creating_and_configuring_reports.htm
I think your issue to be a "classic" task for PHPRUNNER's built-in reporting feature.
Say, "name of the lesson", "date" and "participants" are entered in that very sequence

into the report designer. The built-in search feature allows to narrow the reporting down

to needs. Creating a REPORT shall automatically create a button within the menue.
P.S. Optionally (two tables under Master/Detail relationship, say, Master table is showing

name of the course, description and date while a click on the master record row would then

dsiplay the students who enrolled.
Links: https://xlinesoft.com/phprunner/docs/master-details.htm - https://xlinesoft.com/phprunner/docs/master-details_dashboard.htm