Thanks so much Caroline. Perhaps I should look at the statistics wizards more often!
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/>* On 3 August 2018 at 18:29, Caroline Cyr-La-Rose < [email protected]> wrote: > Hi David, > > Did you try with the statistics wizards? If you go in Reports > Statistics > wizards > Patrons and then choose your first attribute "CC" as a row and > "CD" as a column, it should give you a table with all the different > combinations and the count of patrons with that combination. > > Caroline > Caroline Cyr La Rose, M.S.I. > Bibl. prof. / Chargée de la formation et du soutien > > Tél. : 1 (833) 465-4276 > [email protected] > inLibro | pour esprit libre | www.inLibro.com > Le 2018-08-03 à 11:57, David Hughes a écrit : > > 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/> > <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
