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 david.hughes@dbs.ie *http://library.dbs.ie <http://library.dbs-students.com/>* On 3 August 2018 at 18:29, Caroline Cyr-La-Rose < caroline.cyr-la-rose@inlibro.com> 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 caroline.cyr-la-rose@inLibro.com 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 david.hughes@dbs.ie *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.