Hi Ross,
The query builder module is a wonderful extension of gibbon and really powerful. However, I wasn’t able to figure out, how I can execute multiple queries in one go. I want to create a school summary report containing multiple data.
- Number of students in the current school year
- Number of girls/boys per year group
- Number of girls/boys per year group and 6 years old
- Number of girls/boys per year group and 7 years old
- Number of girls/boys per year group and 8 years old
- etc.
An interesting option would be to suppress all results returning 0 records.
Kind regards,
Roman
Roman,
This is a good question. You could try and use the UNION statement in SQL to bring together multiple SELECTS into a single statement.
In this case, though, check out People > Students in the main menu and then the report Age & Gender Summary in the sidebar menu. I think this returns what you are after, in a pre-tabulated form.
Cheers,
Ross
Hi Ross,
Thanks for these suggestions!
Let me do a few tests. I will then get back to you.
Kind regards,
Roman
Hi Ross,
You guys are incredible! The Age & Gender Summary is doing exactly, what I needed!
Really well done!
Kind regards,
Roman
Roman, happy to please : ) The HK government mandates schools return an annual survey, and this spits out part of the results for us, saving us doing it by hand. Yay! Ross.
Ross, same here, same here. We call it the annual school census or annual PITA, sorry…