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-rose@inLibro.com <mailto:caroline.cyr-la-rose@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.hughes@dbs.ie *http://library.dbs.ie <http://library.dbs-students.com/>*