I added custom user profile fields and thereafter I built a report using those user profile fields. I then created an SQL report to show student ID Numbers - I wanted to use this report as a sub report and then add these fields to my main report with the user profile fields. However when I go to "Add other report columns" it doesn't show me the SQL report I built or the columns in there to choose and add. I will really appreciate any assistance
Randin,
Unfortunately, that feature does not work with SQL type reports.
Here's the list of types of report combinations that do work: https://docs.moodle.org/32/en/Configurable_reports#Embedded_reports
Hi Randy,
Thank you for your reply. Is there any other way to achieve what I require at the moment?
The only way around this I know of for now is to code that logic of both reports into one.