Hi, I want to create a report that gives a grand total of records with various combinations of two different patron attributes.
I have two different borrower_attributes.code values "CC" and "CD" and I want to output the grand totals of records with all permutations of borrower_attributes.attribute that have these codes. So if borrower_attributes.code CC has values 1, 2, 3 etc and borrower_attributes.code CD has values A, B C I'd want to output the grand totals of all records having CC value "1" CD value "A" CC value "1" CD value "B" CC value "1" CD value "C" ...... CC value "2" CD value "A" CC value "2" CD value "B" etc This is outwith the scope of my very limited SQL, so I'd appreciate any help that the community would be able to offer. Thanks. Kind regards David Hughes Systems Librarian Dublin Business School 13-14 Aungier St. Dublin 2 Ireland 00 353 1 417 8744 [email protected] *http://library.dbs.ie <http://library.dbs-students.com/>* -- *Data Protection: *The protection of your data is important to us. Please see our Privacy Notice <https://www.dbs.ie/privacy-policy> for more information on how we handle your data. _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
