Liveware Publishing Support Forum

Im using RRW v 12.5. Is RRW capable of creating a single report with multi-groups? Let say I want to create a table totalling all male and female students per classrooms 1 to 10. Then another table totalling age-brackets of these students per classrooms 1 to 10, and another table for no_of_days_in_class of students per classrooms 1 to 10. Thank you.__ __

Yes, R&R is able to do this in the Xbase edition. The basic structure is that you^d have a master table that^s a stub and then scan into the students table three times creating three aliases (names, ages, days).____I^m assuming that your students table is structured like:____ID__Name__Gender__Birthdate__DaysInClass____The stub table can be nearly anything, but you need to create a FlexLink to tie them together. This can be done with a calculated field on the stub of a single character and this same character as the expression in the FlexLink.

The result should look something like this:____ GENDER/ROOMS__ 1 2 3 4 5 6 7 8 9 10__MALE__FEMALE____ AGE/ROOMS__ 1 2 3 4 5 6 7 8 9 10__1-5__6-10 __11-15__16-20____ DAYS OF STAY/ROOMS__ 1 2 3 4 5 6 7 8 9 10__10-15__16-20__21-25__26-30____Thanks__