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
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://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
david.hug...@dbs.ie
*http://library.dbs.ie <http://library.dbs-students.com/>*
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha